Clarifying what “Restore” does

  • Resolved deviceguru

    (@deviceguru)


    6 years, 9 months ago

    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!

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author Lester Chan

    (@gamerz)

    It depends on the backup file. If the backup file is with prefix site1, then they will be restored to prefix site1.

    It doesn’t delete your database before restore.

    It drops the table individually before they restore the table.

    It is processed table by table.

    Thread Starter deviceguru

    (@deviceguru)

    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!!

    • This reply was modified 6 years, 9 months ago by deviceguru.
    • This reply was modified 6 years, 9 months ago by deviceguru.
    • This reply was modified 6 years, 9 months ago by deviceguru.
    • This reply was modified 6 years, 9 months ago by deviceguru.
Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Clarifying what “Restore” does’ is closed to new replies.