No announcement yet.

vb database backups not working at all...

  • Filter
  • Time
  • Show
Clear All
new posts

  • vb database backups not working at all...

    Since my server swap I immediately could not "Backup database to a file on the server". No matter though because I could save it to my home computer. Now when I try to save it to my home compter I am getting a tiny ass 400k file when it should be about 70megs. I'm stuck here trying to figure out what the hell is going on. Any ideas?

    Thanks ahead of time.
    - Luke

  • #2
    just got an error email also...

    "Database error in vBulletin 3.0.7:

    Invalid SQL: SELECT * FROM attachment
    mysql error: MySQL client run out of memory

    mysql error number: 2008"
    - Luke


    • #3
      You will probably not be able to backup your database with the Admin CP option. The only reliable method of backing up and restoring a database is with shell access via telnet or ssh. Please see the instructions here:



      This is because backing up with a PHP script like that in the Admin CP or phpMyAdmin can result in PHP timeouts errors and an incomplete backup file.
      Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
      Change CKEditor Colors to Match Style (for 4.1.4 and above)

      Steve Machol Photography

      Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


      widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.