487
edits
(→Moving Servers: Updated to reflect more complex nature of DB change.) |
(→Moving Servers: Fixed imported data) |
||
Line 84: | Line 84: | ||
1. Edit the wp-config.php file and change the DB_HOST entry to have the following: | 1. Edit the wp-config.php file and change the DB_HOST entry to have the following: | ||
<pre> | |||
define('DB_HOST', ';localhost:3309'); | define('DB_HOST', ';localhost:3309'); | ||
or | or | ||
define('DB_HOST', '127.0.0.1:3309'); | define('DB_HOST', '127.0.0.1:3309'); | ||
</pre> | |||
2. This is the tricky part. Using phpMyAdmin, update the siteurl, home, theme_mods_twentyeleven and dashboard_widget_options entries in the wp_options table and the guids in the wp_posts table as follows. | 2. This is the tricky part. Using phpMyAdmin, update the siteurl, home, theme_mods_twentyeleven and dashboard_widget_options entries in the wp_options table and the guids in the wp_posts table as follows. | ||
#Select the WordPress database for this installation. | #Select the WordPress database for this installation. | ||
#Select the '''wp_options''' table for browse. | #Select the '''wp_options''' table for browse. | ||
#Edit the entry for '''siteurl''' and change | #Edit the entry for '''siteurl''' and change "localhost" to "localhost:83" | ||
#Edit the entry for '''home''' and change | #Edit the entry for '''home''' and change "localhost" to "localhost:83" | ||
#Edit the entry for '''dashboard_widget_options''' and change | #Edit the entry for '''dashboard_widget_options''' and change "localhost" to "localhost:83" in ''three places''. | ||
#Edit the entry for '''theme_mods_twentyeleven''' and change | #Edit the entry for '''theme_mods_twentyeleven''' and change "localhost" to "localhost:83" | ||
#Select the '''wp_posts''' table for browse. | #Select the '''wp_posts''' table for browse. | ||
#For each post entry, edit the '''guid''' and change | #For each post entry, edit the '''guid''' and change "localhost" to "localhost:83" | ||
Your WordPress should now work properly. | Your WordPress should now work properly. |