Announcement

Collapse
No announcement yet.

Database Backup Error

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Database Backup Error

    Just getting ready to upgrade from 3.5.4 to 3.6.4 and I went to backup everything. Once finished the file vbulletin.sql was copied into my computers hard drive with no problem but I then received an email with this error message...

    Database error in vBulletin 3.5.4:

    Invalid SQL:

    INSERT IGNORE INTO session
    (sessionhash, userid, host, idhash, lastactivity, location, styleid, languageid, loggedin, inforum, inthread, incalendar, badlocation, useragent, bypass)
    VALUES
    ('c5bf0c4cf41875dbd48d0c4d621fd195', 1, '72.22.69.150', '24e879e0dce54767b9298ddb46e777d3', 1166451250, '///forums/admincp/backup.php?do=sqltable', 0, 0, 0, 0, 0, 0, 0, 'Mozilla/4.0 (compatible; MSIE 7.0; AOL 9.0; Windows NT 5.1; .NET CLR 1.1.4322)', 0);

    MySQL Error : MySQL server has gone away
    Error Number : 2006
    Date : Monday, December 18th 2006 @ 06:18:22 AM
    Script : http://fire-forums.com:81///forums/admincp/backup.php
    Referrer : http://fire-forums.com//forums/admin....php?do=choose
    IP Address : 72.22.69.150
    Username : Captainron19
    Classname : vB_Database

    SHould I be concerned with anything?

  • #2
    Before you upgrade check if the database is 100%

    how did you dump the database .sql ?

    Comment


    • #3
      How can I check if the db is 100% This was the first time I did a backup I just went into admin / maintenance / database back up and then
      made sure everything was checked off as "yes" then I clicked on go and saved the sql file to the hard drive of my computer.

      Comment


      • #4
        Well, done through the admincp/ means you will get an .sql dump. This dump will then have as LAST LINE IN FILE: ### dump completed ###
        If you do it from the admincp and don't have that last line, it did not complete. You're then best off to try it from shell (ssh2) or phpmyadmin.

        http://www.vbulletin.com/go/backup/

        Once the backup is 100%, you can upload the 3.6.4 files and run upgrade.php - and ignore that email you received.

        Comment

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