• 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

kaieivindm

Active member
#1
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?
 

Brogan

XenForo moderator
Staff member
#2
Unless there is an option to roll back the changes made to the database, you will need to restore from a viable backup.
 

kaieivindm

Active member
#3
Unless there is an option to roll back the changes made to the database, you will need to restore from a viable backup.
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.
 

kaieivindm

Active member
#4
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
 

Brogan

XenForo moderator
Staff member
#5
That could be due to a bad dump or restore.

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

kaieivindm

Active member
#6
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?