How to: Restore your site from backup zip
There are 2 ways to do this:
1. Download your site from the WP Remote dashboard.
Once you have a zip file of the latest backup saved locally, unzip the files. In OS X, you can simply double-click on the file. In Windows, you can use an archiving tool to extract the backup file (there are many available for download on the internet). The unzipped file will contain your database file (ending .sql) and sites files
Restore your files
The backup site files consist of three folders called wp-admin, wp-content and wp-includes plus a number of php files and a .htaccess file. You will need to upload the site files to your site and overwrite the existing files. This can be done via FTP using the file manager provided by your hosting company panel or via an FTP or SFTP client (such as Filezilla for PCs, Transmit for Mac, or Cyberduck, which is free and works on both operating systems ). Make sure you choose to replace the existing files with the new ones. If you are restoring your site after a hack or virus attack it is better to delete all the site files prior to uploading the new files in case additional files have been added.
( in the below example we are using transmit )
Restore your database
You will then need to import your database. This should automatically overwrite the old tables. There are a number of different ways that this can be done:
- Using a tool such as phpMyAdmin. This and similar tools are usually available via your hosting company panel.
- Using a desktop tool.
- MySQL commands via the command line prompt.
- For more information see WordPress codex article on restoring your database from backup.
Again, if you are restoring after a security breach it may be better to delete all old database tables before importing the new ones.
The below example we use Sequel Pro to import a database, selecting the .sql file present in the downloaded zip root directory.
If you are restoring your site to a new domain, you’ll need to update the siteurl and home values in your wp_options table. You can either edit the SQL (.sql) export file, or import the SQL and edit your database using phpMyAdmin or a desktop tool like Sequel Pro.