Restore to new site

  • Resolved tippers

    (@tippers)


    11 years, 3 months ago

    I am using BackupWordpress to backup my production site and I now want to create a replica of my production site in test to check upgrades etc before doing the upgrade in the production site.

    In order to restore my backup I would like to know if the following will work (using IIS7, php 5.3.24, mySQL 5.1):

    1) Create a new site in IIS for the test website.
    2) Create a new database and user in mySQL for the test site.
    3) Restore the files (and .sql database backup) to the test website directory).
    4) Change the wp-config.php file to the database name, username and password of the test site.

    Do I need to do anything in the .sql backup file with changing the database name, username and password from production to test?

    Or do I just run the following in mySQL:
    mysql -u username -p test_database_name < file.sql

    and it will import the backup data into the test database I already created?

    https://wordpress.org/plugins/backupwordpress/

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Contributor Paul de Wouters

    (@pauldewouters)

    11 years, 3 months ago

    tippers

    This article should answer your questions, https://bwp.hmn.md/support-center/restore-backup/

    Thread Starter tippers

    (@tippers)

    11 years, 3 months ago

    Thanks, I read that article but under “Restore your Database” it states that it will overwrite your old tables which I don’t want to do.

    Instead I want to create a new database to restore the tables to for the new test site.

    Thread Starter tippers

    (@tippers)

    11 years, 3 months ago

    Bump. Any chance of a further reply?

    Plugin Author cuvelier

    (@cuvelier)

    11 years, 3 months ago

    Hi Tippers,

    You’ll have to create a new database in that case and restore to the new database.

    Your hosting provider will likely have setup guide for detailed instructions on how to do this.

    Cheers,
    Owain

    Thread Starter tippers

    (@tippers)

    11 years, 3 months ago

    Hi Owain,

    Thanks for your reply.

    I thought so (see my original post) but can you just check the command I stated above to restore the .sql file into the newly created database?

    Regards
    Tippers

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘Restore to new site’ is closed to new replies.