Clarifying what “Restore” does
-
I would like to move two WordPress sites onto a single server. I am running WP-DBmanager on both sites. My question is, assuming the two sites’ mysql tables have unique prefixes (on one they all start with “site1_”, and on the other they all start with “site2_”), can I import site2’s db export file into site1 using using WP-DBmanager’s Restore function? Or, does WP-DBmanager’s Restore function completely delete all mysql database tables prior to importing a backup file? Thanks!
-
Using WP-DBManager running on site 1 located on server 1, I created a backup of site 1’s WP db. Then, I “restored” that backup at server 2, using WP-DBManager running on site 2 (another wordpress site) at server 2. (Note: before doing this, I made sure that sites 1 and 2 did not have any tables with identical names. However, this was expected because I always use a unique “table_prefix” setting in wp-config.php for each of my wordpress sites.)
After “restoring” site 1’s mysql tables to server 2, I created a zip of site 1’s wordpress root directory and sub-directories, and copied and unzipped it onto server 2 in the appropriate path. After verifying permissions and setting up the apache conf area for site 1 on server 2, I restarted apache on server 2 and changed site 1’s DNS to point to server 2’s IP. Site 1 came up on server 2 just fine!
Thanks for a great utility!!
- The topic ‘Clarifying what “Restore” does’ is closed to new replies.
