Links after moving my site to another domain

See Moving WordPress « WordPress Codex These are typical queries to run in phpmyadmin to change URLs, but you may also have serialized data in widget and theme options that will have to be changed, too: UPDATE wp_options SET option_value = replace(option_value, ‘http://olddomain.com’, ‘http://newdomain.com’) WHERE option_name=”home” OR option_name=”siteurl”; UPDATE wp_posts SET guid = replace(guid, ‘http://olddomain.com’,’http://newdomain.com’); … Read more

Error establishing a database connection After Copy localhost wordpress site (with site url directly to hosting server’s url before copy)

Read http://codex.wordpress.org/Moving_WordPress#When_Your_Domain_Name_or_URLs_Change You’ve only moved the PHP files. That is only part of the process. Migrating the databse would mean: Create a database, if there isn’t one already Move the database from your local server to the remote one. Edit/alter key values in the database The same wp-config editing trick used here will get you … Read more

How to change a WordPress network domain

The database Initially you should update all references to your old domain in the database. The following SQL will take care of that, but first read these notes – This SQL assumes that you are using the default wp_ table prefix. Simply change this to your chosen table prefix if you have changed it. Replace … Read more

What’s a better workflow for database migration?

I use this for search and replace on databases – https://interconnectit.com/products/search-and-replace-for-wordpress-databases/ Simply move files with FTP, export and import database and then run the script searching for old URL and replacing with the new URL. Then I resave permalinks and I’m done. I’ve moved WP thousands of times using this. I’ve got the old script … Read more

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)