No announcement yet.

Database backup problems

  • Filter
  • Time
  • Show
Clear All
new posts

  • Database backup problems

    I am having problems backing up database and moving to a new server

    I've tried using myphpadmin and have been able to backup most other databases including a smaller vBulletin db also. Except the one im having problems with is a 180meg database. Everytime I try to back it up, it times out and i get nothing

    So i've tried backing it up by going into the server via telnet and running a few commands to back this thing up:

    mysqldump --opt -uUSERNAME -p databasename > /path/to/dump.sql

    dumping database on server A and then moving it to server B
    then running:

    mysql -uUSERNAME -p newdbname < /path/to/dump.sql

    After all this, when i try to go into admin/index.php to configure the message board &/or if I try to just access the board /index.php, i keep getting this error.

    There seems to have been a slight problem with the (name of forums) Forums database.
    Please try again by pressing the refresh button in your browser.

    An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

    We apologise for any inconvenience.


  • #2
    Right-click on the error page and view source. Post the complete error message here.

    Also were the vB files on the old server and new server the same version?
    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.


    • #3
      Here's the whole thing with names left out

      <html><head><title>(site name) Forums Database Error</title><style>P,BODY{FONT-FAMILY:tahoma,arial,sans-serif;FONT-SIZE:11px;}</style><body>

      <!-- Database error in vBulletin 2.2.6:

      Invalid SQL: INSERT INTO session (sessionhash,userid,host,useragent,lastactivity,althash,location) VALUES ('00c7919d7339772b0a88cc6fdc2b5cd8',0,'','Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 5.0;','1032670978','','/forums/index22.php')
      mysql error: Unknown column 'althash' in 'field list'

      mysql error number: 1054

      Date: Sunday 22nd of September 2002 12:02:58 AM
      Script: http://www.(site name).com/forums/forums/index.php

      <blockquote><p>&nbsp;</p><p><b>There seems to have been a slight problem with the (site name)Forums database.</b><br>
      Please try again by pressing the <a href="javascript:window.location=window.location;">refresh</a> button in your browser.</p>An E-Mail has been dispatched to our <a href="mailtoemail address)">Technical Staff</a>, who you can also contact if the problem persists.</p><p>We apologise for any inconvenience.</p></blockquote></body></head></html>


      • #4
        ok thanks i fixed it


        • #5
          What is the fix?


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