Restoring from sql.gz backup file

  • micahhorner

    (@micahhorner)


    12 years, 4 months ago

    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

    (@jossnchz)

    12 years, 4 months ago

    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.