Title: Restoring from sql.gz backup file
Last modified: August 21, 2016

---

# Restoring from sql.gz backup file

 *  [micahhorner](https://wordpress.org/support/users/micahhorner/)
 * (@micahhorner)
 * [12 years, 4 months ago](https://wordpress.org/support/topic/restoring-from-sqlgz-backup-file/)
 * All right, I’m trying restore my website from an sql.gz database backup file 
   that was emailed to me every week by a plugin called WP-DB-Backup.
 * I’m using 1and1 for hosting.
 * I created a new MySQL database, and imported the sql.gz file in phpMyAdmin. In
   phpMyAdmin, I can see these files:
 * cwmv1sjxq_commentmeta
    cwmv1sjxq_comments cwmv1sjxq_links cwmv1sjxq_options cwmv1sjxq_postmeta
   cwmv1sjxq_posts cwmv1sjxq_terms cwmv1sjxq_term_relationships cwmv1sjxq_term_taxonomy
   cwmv1sjxq_usermeta cwmv1sjxq_users
 * I added the database information to the wp-config file, added a .maintenance.
   php file, and then uploaded the WordPress 3.8 folder using Webspace Explorer.
 * Everything seems to work fine. When I go to my URL (www.themodernmaids.com), 
   it prompts me to install WordPress, so I do it.
 * After I installed WordPress, these files are showing up in phpMyAdmin as well:
 * wp_commentmeta
    wp_comments wp_links wp_options wp_postmeta wp_posts wp_terms
   wp_term_relationships wp_term_taxonomy wp_usermeta wp_users
 * My website shows up as the default WordPress site. If I “drop” all of the files
   inserted by the WordPress installation in phpMyAdmin so that only the files from
   my sql.gz backup file remain, and then go to my URL, it prompts me to install
   WordPress all over again.
 * This is an endless cycle.
 * It will not use the files from my sql.gz backup file. I tried another sql.gz 
   backup file from a previous backup with the same results.
 * Any clue on why the files from my sql.gz backup file are not working?

Viewing 1 replies (of 1 total)

 *  [Jos.SnchZ](https://wordpress.org/support/users/jossnchz/)
 * (@jossnchz)
 * [12 years, 4 months ago](https://wordpress.org/support/topic/restoring-from-sqlgz-backup-file/#post-4462021)
 * Hi,
 * I’d recommend you to make the proccess without the creation of the “.maintenance.
   php” file.
 * U’d check also if in the table “wp_options” the options related to “home” and“
   siteurl” are linking correctly to your site.
 * Another test you can try is making the same process into your localhost site,
   since it will be probably faster.
 * Anyway, is your backup a new WordPress site or it’s a one which already’s got
   data and stuff working?
 * Regards

Viewing 1 replies (of 1 total)

The topic ‘Restoring from sql.gz backup file’ is closed to new replies.

## Tags

 * [restore from backup](https://wordpress.org/support/topic-tag/restore-from-backup/)

 * In: [Installing WordPress](https://wordpress.org/support/forum/installation/)
 * 1 reply
 * 2 participants
 * Last reply from: [Jos.SnchZ](https://wordpress.org/support/users/jossnchz/)
 * Last activity: [12 years, 4 months ago](https://wordpress.org/support/topic/restoring-from-sqlgz-backup-file/#post-4462021)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics