Title: WordPress Migration Woes Last modified: August 24, 2016 --- # WordPress Migration Woes * [gdavisiv](https://wordpress.org/support/users/gdavisiv/) * (@gdavisiv) * [11 years, 2 months ago](https://wordpress.org/support/topic/wordpress-migration-woes/) * My predecessor had created and modified a lot of the php/etc for our old website. I am taking our current database and migrating into to a newer version of WP that our central office is using: 4.1.1 * I am on a mac/mamp: I have created a new database in phpmyadmin and imported the old database. I have also installed WP in the MAMP directory. * I have followed these tutorials: – [http://timmyomahony.com/blog/MAMP-phpmyadmin-and-big-database-imports-errors-or-timeouts/](http://timmyomahony.com/blog/MAMP-phpmyadmin-and-big-database-imports-errors-or-timeouts/)– [http://www.billerickson.net/migrating-wordpress-websites/](http://www.billerickson.net/migrating-wordpress-websites/)– [http://www.wpbeginner.com/wp-tutorials/how-to-install-wordpress-locally-on-mac-using-mamp/](http://www.wpbeginner.com/wp-tutorials/how-to-install-wordpress-locally-on-mac-using-mamp/) * When i follow the installation instructions for WordPress it gives me an error message: * WordPress Already Installed you appear to have already installed wordpress. to reinstall please clear your old database tables first. * I want to use the old database not clear it! Please help! Thank you! Viewing 11 replies - 1 through 11 (of 11 total) * Moderator [t-p](https://wordpress.org/support/users/t-p/) * (@t-p) * [11 years, 2 months ago](https://wordpress.org/support/topic/wordpress-migration-woes/#post-5961182) * Try incremental update. Use this tutorial: [https://codex.wordpress.org/Upgrading_WordPress_-_Extended_Instructions](https://codex.wordpress.org/Upgrading_WordPress_-_Extended_Instructions) * Thread Starter [gdavisiv](https://wordpress.org/support/users/gdavisiv/) * (@gdavisiv) * [11 years, 2 months ago](https://wordpress.org/support/topic/wordpress-migration-woes/#post-5961344) * Hi Tara, * > Try incremental update. Use this tutorial: > [https://codex.wordpress.org/Upgrading_WordPress_-_Extended_Instructions](https://codex.wordpress.org/Upgrading_WordPress_-_Extended_Instructions) * Thank you for your response but I do not think incremental updates would help me because I want to take the current database of information we have and migrate it into the newer version that is supported by our central office. * [rwaynick a11n](https://wordpress.org/support/users/rwaynick/) * (@rwaynick) * [11 years, 2 months ago](https://wordpress.org/support/topic/wordpress-migration-woes/#post-5961350) * Hi gdavisiv, * Did you update your wp-config.php file with the new database details? When transferring a site I prefer to get a clean config file. You can use the wp-config-sample. php file. Once you enter your details, rename it to wp-config.php. Also, make sure to backup your current wp-config.php file. * Let me know if that helps, or if you have any other questions. * Thread Starter [gdavisiv](https://wordpress.org/support/users/gdavisiv/) * (@gdavisiv) * [11 years, 2 months ago](https://wordpress.org/support/topic/wordpress-migration-woes/#post-5961352) * Hi rwaynick thank you for your response also! * Yes I did update the wp-config.php file, after i created the database table, and imported the database I installed the new wordpress version into the ‘/www’ folder in MAMP. Then changed the database name, username, password, hostname, and prefix. * Still nothing, I have attempted this 3 times, when i go to [http://localhost/mysite](http://localhost/mysite), I either get the error message I had mentioned earlier, or the screen is white:/ * [rwaynick a11n](https://wordpress.org/support/users/rwaynick/) * (@rwaynick) * [11 years, 2 months ago](https://wordpress.org/support/topic/wordpress-migration-woes/#post-5961356) * > when i go to [http://localhost/mysite](http://localhost/mysite) * Unless you changed the port to 80, you’ll need access your site at [http://localhost:8888/mysite](http://localhost:8888/mysite) * > the screen is white :/ * I’ve had this issue when forgetting to put a single quote mark (‘) either before or after the database information in the config file. * Let me know if that helps. * Thread Starter [gdavisiv](https://wordpress.org/support/users/gdavisiv/) * (@gdavisiv) * [11 years, 2 months ago](https://wordpress.org/support/topic/wordpress-migration-woes/#post-5961358) * > Unless you changed the port to 80, you’ll need access your site at [http://localhost:8888/mysite](http://localhost:8888/mysite) * Yes I changed the port to 80 in MAMP * > I’ve had this issue when forgetting to put a single quote mark (‘) either before > or after the database information in the config file. * This is what is in my config file. * define(‘DB_NAME’, ‘mysite’); define(‘DB_USER’, ‘root’); define(‘DB_PASSWORD’,‘ root’); define(‘DB_HOST’, ‘localhost’); define(‘DB_CHARSET’, ‘utf8’); $table_prefix = ‘main_F5_’; * Thread Starter [gdavisiv](https://wordpress.org/support/users/gdavisiv/) * (@gdavisiv) * [11 years, 2 months ago](https://wordpress.org/support/topic/wordpress-migration-woes/#post-5961363) * I even ran this utility tool on the database, so I could setup the new website as a test. * [https://interconnectit.com/products/search-and-replace-for-wordpress-databases/](https://interconnectit.com/products/search-and-replace-for-wordpress-databases/) searchreplacedb2.php * [rwaynick a11n](https://wordpress.org/support/users/rwaynick/) * (@rwaynick) * [11 years, 2 months ago](https://wordpress.org/support/topic/wordpress-migration-woes/#post-5961364) * I’m not sure of the next best step, but below are a few things I would look at next. * 1. Is your site and home url set properly inside of the wp_options table? 2. Try to change the table prefix to wp_. Inside of phpMyAdmin, you can select all tables, then ‘Replace table prefix’. Also, make sure to update the config file. * Thread Starter [gdavisiv](https://wordpress.org/support/users/gdavisiv/) * (@gdavisiv) * [11 years, 2 months ago](https://wordpress.org/support/topic/wordpress-migration-woes/#post-5961419) * That was the problem! thank you rwaynick!! when I checked the wp_options table the ‘siteurl’ was not what I assumed with would be! Now it is working!! 😀 * [rwaynick a11n](https://wordpress.org/support/users/rwaynick/) * (@rwaynick) * [11 years, 2 months ago](https://wordpress.org/support/topic/wordpress-migration-woes/#post-5961420) * Awesome! Glad you got it working! * Thread Starter [gdavisiv](https://wordpress.org/support/users/gdavisiv/) * (@gdavisiv) * [11 years, 2 months ago](https://wordpress.org/support/topic/wordpress-migration-woes/#post-5961421) * Thanks again!! 🙂 Viewing 11 replies - 1 through 11 (of 11 total) The topic ‘WordPress Migration Woes’ is closed to new replies. ## Tags * [database](https://wordpress.org/support/topic-tag/database/) * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/) * 11 replies * 3 participants * Last reply from: [gdavisiv](https://wordpress.org/support/users/gdavisiv/) * Last activity: [11 years, 2 months ago](https://wordpress.org/support/topic/wordpress-migration-woes/#post-5961421) * Status: not resolved ## Topics ### Topics with no replies ### Non-support topics ### Resolved topics ### Unresolved topics ### All topics