1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

XF 1.4 HeidiSQL and upload of older SQL file

Discussion in 'Troubleshooting and Problems' started by kaieivindm, Apr 11, 2015.

  1. kaieivindm

    kaieivindm Active Member

    Soooo... I think I just made a huge error! Because my site is now down.

    I was planning to find some old stuff in a backup database I had on disk.
    So I uploaded it to HeidiSQL for viewing, however I was still connected to the database on my forum, and it seems like I have overwritten lots of stuff.

    When the panic hit me like a truck doing easily 100mph... I canceled the upload.
    So the result is, site is down and all is ****!

    Even worse, is that my last backup is from 3rd of April, and I have done major changes to the forum since then.

    Question: is there anything I can do? Or have I got the lesson of a lifetime now?
  2. Brogan

    Brogan XenForo Moderator Staff Member

    Unless there is an option to roll back the changes made to the database, you will need to restore from a viable backup.
  3. kaieivindm

    kaieivindm Active Member

    Thanks, but there is no roll back possibilities here.

    Guess I have to check my hosting company if they have database copies and can restore for me.
  4. kaieivindm

    kaieivindm Active Member

    Tried to restore the database.

    But seems like forum is in maintenance? And I cant get in.

    Server Error
    Server Error
    unserialize(): Error at offset 4688 of 6583 bytes

    1. XenForo_Application::handlePhpError()
    2. unserialize()inXenForo/Model/Language.phpat line387
    3. XenForo_Model_Language->getAllLanguagesForCache()inXenForo/Visitor.phpat line478
    4. XenForo_Visitor->setVisitorLanguage()inXenForo/Visitor.phpat line463
    5. XenForo_Visitor::setup()inXenForo/Install/Controller/Upgrade.phpat line50
    6. XenForo_Install_Controller_Upgrade->_setupSession()inXenForo/Controller.phpat line306
    7. XenForo_Controller->preDispatch()inXenForo/FrontController.phpat line346
    8. XenForo_FrontController->dispatch()inXenForo/FrontController.phpat line134
    9. XenForo_FrontController->run()in/home/4/s/spillforumet/www/install/index.phpat line18

    Also showing when I go to link/install
  5. Brogan

    Brogan XenForo Moderator Staff Member

    That could be due to a bad dump or restore.

    How was the dump taken and what did you use to restore it?
  6. kaieivindm

    kaieivindm Active Member

    I took a dump directly from my host, so it created a full SQL dump.

    Then uploaded via HeidiSQL for restore. But maybe I should try and do it via MySQL and via shell instead?
  7. Anton_Bodryachkom

    Anton_Bodryachkom Active Member

    Usualy hosting companies does daily backups , i think
  8. Anton_Bodryachkom

    Anton_Bodryachkom Active Member

    Sorry to hear that , its sux :/

Share This Page