Installing WordPress on 8-Coral: Difference between revisions

Installing WordPress on 8-Coral (view source)

573 bytes added , 4 January 2012

Updated database changes.

487

edits

@@ Line 87: / Line 87: @@
 define('DB_HOST', '127.0.0.1:3309');
 </pre>
-. Using phpMyAdmin, update the siteurl and home entries in the wp_options table as follows.
+. 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 '''wp_options''' table for browse.
-#Edit the entry for '''siteurl''' (normally the first location) and change "localhost" to "localhost:83"
+#Edit the entry for '''siteurl''' (ID=1) and change "localhost" to "localhost:83"
-#Edit the entry for '''home''' (normally about 30-40 entries down) and change "localhost" to "localhost:83"
+#Edit the entry for '''home''' (ID=37) and change "localhost" to "localhost:83"
+#Edit the entry for '''dashboard_widget_options''' (ID=119) and change "localhost" to "localhost:83" in ''three places''.
+#Edit the entry for '''theme_mods_twentyeleven''' (ID=234) and change "localhost" to "localhost:83"
+#Select the '''wp_posts''' table for browse.
+#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.  However, if you have many posts, we suggest that you export the data and edit the file with a text editor to do the bulk changes needed.  Then reload  the database from the edited file.
 == Security ==