Announcement

Collapse
No announcement yet.

Database Backup

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

  • Database Backup

    I was trying to backup via server as per the recommendation and it seems to go through about half way before I get the following error.

    Database error in vBulletin 3.7.0:

    Database error in vBulletin 3.7.0:

    Invalid SQL:
    SHOW CREATE TABLE vb_postedithistory;

    MySQL Error : MySQL server has gone away
    Error Number : 2006
    Request Date : Saturday, July 12th 2008 @ 12:30:45 PM
    Error Date : Saturday, July 12th 2008 @ 12:31:08 PM
    Script : http://forums.digitalsloth.net/admin...php?do=sqlfile
    Referrer : http://forums.digitalsloth.net/admin....php?do=choose
    IP Address : 72.130.111.89
    Username : Slayne
    Classname : vB_Database
    MySQL Version :


    Any suggestions on how to remedy this? As is, I think I'm only getting about half way through before it stops. I get this even after running the optimize / repair utility.

  • #2
    MySQL server has gone away is a server issue, most likely you need to increase some timeout or other mysql values
    http://dev.mysql.com/doc/refman/5.0/en/gone-away.html

    Comment


    • #3
      Any ideas on what I'd need to tell my host in resolving the problem?

      Comment


      • #4
        First thing to ask is for them to tell you what is the 'wait_timeout' in my.cnf file (for mysqld) and perhaps starting to increase it in 60 second increments and restart mysqld, then see if the errors continue.

        Comment


        • #5
          On a shared and it will affect everyone, so looks like I'll just have to use the php method.

          Comment


          • #6
            It now gives me the same error when doing the PHP method. Assuming the host hasn't changed anything, would anything else cause this error that I can fix?

            Comment


            • #7
              This is a server issue. You will have to contact your host.

              Note: The only consistently reliable method of backing up and restoring a database is with shell access via telnet or ssh. This is because backing up with a PHP script like that in the Admin CP or phpMyAdmin can result in PHP timeout errors and an incomplete backup file. Please see the instructions here:

              Backup:
              http://www.vbulletin.com/docs/html/m...nce_ssh_backup

              Restore:
              http://www.vbulletin.com/docs/html/m...ce_ssh_restore

              If you don't have telnet or SSH access, some people have reported success with these scripts:

              MySQLDumper:
              http://www.mysqldumper.de/en/index.php
              MySQLHotxcopy:
              http://www.vbulletin.com/forum/showt...t=mysqlhotcopy
              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.


              Comment


              • #8
                If I use mysql admin and just download a backup of the mysql database that the forum is using, would this be basically the same thing?

                Comment


                • #9
                  No, it wouldn't. It will have the same timeout risk.
                  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.


                  Comment

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