Restore appeared to complete but failed – Site down with Database Error

UpdraftPlus Home › Forums › Paid support forum – UpdraftPlus backup plugin › Restore appeared to complete but failed – Site down with Database Error

Tagged: 

Viewing 8 posts - 1 through 8 (of 8 total)
  • Author
    Posts
  • May 2, 2019 at 9:03 pm #383301
    saca.tucson
    Participant

    1) I took a full backup prior to troubleshooting a small issue – reverted to Twenty Sixteen theme and disable plugins to make sure no conflict.
    2) After ruling out conflict, I turned my Theme back on and activated the plugins. Unhappily I had lost my Theme settings, so I decided to restore the backup.
    3) The restore appeared to complete. I followed the instructions on the screen. I got a message that I needed to repair the database by inserting a line in the wp-config file. and refreshed the screen. Then followed instruction to remove the line from wp-config
    4) Accessing my site I still see Error establishing a database connection
    5) Hosting support tells me there are tables missing from the database.
    6) It will cost me $100 to have their people restore the database.

    I thought you should know there are problems with your backup / restore process.

    May 3, 2019 at 5:08 pm #383637
    Bryle Crodua
    Moderator

    Hi,

    To help us work out the cause of your problem, can you please send us a copy of the restoration log?
    You can find this log in the ‘wp-content/updraft’ directory of your site via FTP.
    You can send the log file as an attachment or copy the contents into an online tool (such as https://pastebin.com/ )

    Best Wishes,
    Bryle

    May 3, 2019 at 5:45 pm #383657
    saca.tucson
    Participant
    This reply has been marked as private.
    May 6, 2019 at 12:24 am #384312
    cindy9
    Participant

    I have the same problem. I see 2 logs from the same time. Where do I email them to?
    Thanks

    May 6, 2019 at 12:37 am #384317
    cindy9
    Participant
    This reply has been marked as private.
    May 6, 2019 at 8:44 pm #384623
    Bryle Crodua
    Moderator

    Hi @saca.tucson,

    “0083.804 () Top-level entities being moved: twentysixteen, twentyfifteen, twentyseventeen, index.php, spun, genesis, academy-pro, genesis-sample, daily-dish-pro, authority-pro, breakthrough-pro, twentynineteen”

    Is the that you are using listed here?

    Could you also try to restore/migrate your site on a staging/test site and see if you are able to restore everything?


    @cindy9     could you also do the same? It appears that is a duplicate error your on your database.

    Regards,
    Bryle

    May 6, 2019 at 11:32 pm #384677
    cindy9
    Participant

    Thank you but I have no idea what you mean when you say “Is the that you are using listed here?”. I don’t have time to mess with 1) getting or setting up a staging/test site and 2) waiting on a reply to this. After almost 24 hours waiting for a reply, I had to go ahead and pay GoDaddy $150 to restore the site.

    Thank you
    Cindy

    May 7, 2019 at 8:29 am #384790
    saca.tucson
    Participant

    The theme we were using was Breakthrough Pro, Genesis child.

    I suppose I could figure out a way to create a staging/test site on another account to try it out. I also have already paid my hosting support to recover a backup of my database to get our site up again. It was down for 96 hours.

    I would like to understand what this means. Are these the lines you are referring to?
    0083.804 () Top-level entities being moved: twentysixteen, twentyfifteen, twentyseventeen, index.php, spun, genesis, academy-pro, genesis-sample, daily-dish-pro, authority-pro, breakthrough-pro, twentynineteen
    0083.822 () Moving unpacked backup into place…
    0084.225 () Top-level entities being moved: academy-pro, authority-pro, breakthrough-pro, daily-dish-pro, genesis, genesis-sample, spun, twentyfifteen, twentynineteen, twentyseventeen, twentysixteen, index.php

  • Author
    Posts
Viewing 8 posts - 1 through 8 (of 8 total)
  • The topic ‘Restore appeared to complete but failed – Site down with Database Error’ is closed to new replies.