Category Archives: MySQL

2 Database Configurations That You Should Notice When Migrating WordPress

Are you facing 404 error or page not found when changing your hosting server for your WordPress? Is your wp-admin link not found after installing WordPress. Try to check the following configuration:

1) siteurl configuration

This is the configuration in your database. Login and navigate to your WordPress database. Open table wp_options. Look for option_name “siteurl“. See the image below:

Wordpress Siteurl

Configure option_value for “siteurl” as following:

If your blog URL = http://www.myexample.com then siteurl is http://www.myexample.com
If your blog URL is inside a folder = http://www.myexample.com/wordpress/ then siteurl is http://www.myexample.com/wordpress/

2) home configuration

Similar to above, “home” option_name is inside “wp_options” table too. Look for “home” keyword and update.

home

Configure option_value for “siteurl” as following:

If your blog URL = http://www.myexample.com then home is http://www.myexample.com
If your blog URL is inside a folder = http://www.myexample.com/wordpress/ then home is http://www.myexample.com/wordpress/

Hint: “siteurl” and “home” table entry should be at record ID 1 and 36 respectively.

Good luck and have fun in debugging.