Installing WordPress on 8-Coral: Difference between revisions

→‎Moving Servers: Fixed imported data
(→‎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>
<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');
&lt;/pre&gt;
</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 &quot;localhost&quot; to &quot;localhost:83&quot;
#Edit the entry for '''siteurl''' and change "localhost" to "localhost:83"
#Edit the entry for '''home''' and change &quot;localhost&quot; to &quot;localhost:83&quot;
#Edit the entry for '''home''' and change "localhost" to "localhost:83"
#Edit the entry for '''dashboard_widget_options''' and change &quot;localhost&quot; to &quot;localhost:83&quot; in ''three places''.
#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 &quot;localhost&quot; to &quot;localhost:83&quot;
#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 &quot;localhost&quot; to &quot;localhost:83&quot;
#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.