Restore of a backup in new site corrupts databank

UpdraftPlus Home › Forums › Paid support forum – UpdraftPlus backup plugin › Restore of a backup in new site corrupts databank

Tagged: 

Viewing 6 posts - 1 through 6 (of 6 total)
  • Author
    Posts
  • January 1, 2016 at 6:41 pm #138521
    Christiane
    Participant

    Hi,

    I wanted to clone my database to a new installation but this failed.
    Thus I copied a successful backup manually in the ftp folder and tried to restore the backup manually into the new installation.

    Doing this the restore does not finish and the site stays in maintenance mode.
    After waiting for more than 30 minutes the situation did not change.
    The database then has no longer the user-table.

    This happened twice, and I had to create new databases that I linked to the installation.

    Unfortunately I can’t attach any screenshots as I did not think of making them before I cleaned up…

    Is this a known issue? I lost two days trying to migrate this database, thus I really hope you can help.

    Thanks
    Christiane

    January 1, 2016 at 11:43 pm #138541
    udadmin
    Keymaster

    Hi Christine,

    Are you able to link a copy of the restore log? This file can be found in the folder wp-content/updraft on the destination site. Then, we can read it and see what happened.

    Based on the description, it sounds most likely that the webserver that the destination site is on enforces a low time-out, and kills off the restore operation before it can finish. But, we’d need to see the log to be able to confirm that.

    David

    January 2, 2016 at 9:34 am #138558
    Christiane
    Participant
    This reply has been marked as private.
    January 2, 2016 at 10:22 pm #138615
    udadmin
    Keymaster

    Hi Christiane,

    It looks like your database has 674,000 rows in the options table – which is the largest I’ve ever seen; and that you’re trying to restore into web hosting space with 1&1, who are one of the web hosting companies who provide fewest resources (from our experience of reading logs in the support channel). This is a recipe for pain.

    As your best bet, you could try restoring the database backup in phpMyAdmin, assuming that that’s available in their control panel. Rename the db.gz file so that it ends in db.sql.gz (phpMyAdmin likes to see the “sql.gz” pattern at the end). Then after doing that, add this to your wp-config.php file so that you can log in:

    define(‘WP_SITEURL’, ‘https://clean-lifestyle.de’);
    define(‘WP_HOME’, WP_SITEURL);

    Then go to UpdraftPlus, and to the “advanced tools” tab, and search/replace the old site URL for the new one (https://clean-lifestyle.de).

    This is a lot of work though, compared to just getting a hosting company that provides more resources, so you might want to consider that option too.

    David

    January 3, 2016 at 12:42 pm #138637
    Christiane
    Participant

    Hi David,

    I just found the right table and saw that I have two different one…I got someone to move my installation and apparently this is what happened…
    I did not see any possibility to delete my answer.

    For the moment no further action from you side is required.

    Thanks
    Christiane

    ****

    Hi David,

    I checked my options-table vie phpMaAdmin and it stated 265 datasets.
    I screened them and am a little confused as it seems to show options from a theme that I used on another website (but not on this one), from which I imported the blog posts.
    Do you know if importing blog posts from another website also imports options from the theme used on the particular website?

    Where did you get the amount of 674,000 from? How would I see this?

    Thanks
    Christiane

    January 4, 2016 at 10:25 pm #138781
    udadmin
    Keymaster

    Glad you got it fixed!

    David

  • Author
    Posts
Viewing 6 posts - 1 through 6 (of 6 total)
  • The topic ‘Restore of a backup in new site corrupts databank’ is closed to new replies.