Announcement

Collapse
No announcement yet.

Restoring database from backup

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

  • Restoring database from backup

    Over the weekend our forum was hacked and our database was destroyed. We did a SQL dump on the Friday through the Admin control panel.

    How do we go about restoring that into the new database?

    Any help is appricated.

    Dave M

  • #2
    Originally posted by KeyPublishing
    Over the weekend our forum was hacked and our database was destroyed. We did a SQL dump on the Friday through the Admin control panel.

    How do we go about restoring that into the new database?

    Any help is appricated.

    Dave M
    The best way is to do a restore of your SQL dump through phpMyAdmin. Once in phpMyAdmin, go to SQL and where it asks for the location of the textfile, point to your SQL file and hit "go".

    Let it run. Depending on the size of your data, it can take a bit.
    Last edited by Cancorp; Mon 30 Jun '03, 7:52am.

    Comment


    • #3
      Cheers i will give that a go

      Dave

      Comment


      • #4
        I have tried that, after a while it goes to an error page relating to READ_DUMP.PHP what does this mean?

        Our database backup is over 450Mb in size, is that causing the problem?

        Dave

        Comment


        • #5
          It's too large to restore with phpMyAdmin. The only reliable method of backing up and restoring a database is with shell access via telnet or ssh. Please see the instructions here:

          http://www.vbulletin.com/manual/movingservers.html
          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


          • #6
            Sorry, this link does not work. I need the info on how to backup and restore my database.

            Tnx and regards
            John Caradimas

            Comment


            • #7
              Sorry, that was the old link:

              http://www.vbulletin.com/docs/html/main/moving_servers

              In the future you should look in the online manual for this and a lot of other useful information:

              http://www.vbulletin.com/docs/html/
              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
                Thank you Sir!
                John Caradimas

                Comment

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