Announcement

Collapse
No announcement yet.

I killed my boards! I have a backup but do not know how to load it

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

  • I killed my boards! I have a backup but do not know how to load it

    how is that done? I have SQL dump's as well as the vB backup

  • #2
    you can restore your database backup by running this command from the shell (telnet connection to your server):

    mysql -uusername -p databasename < backupname.sql

    replace the bold text with your info... this comes straight out of your config.php file. replace backupname.sql with the name of your backup file.

    Comment


    • #3
      sweet...cept

      Iam running windows and have no access to a box running linux. Certianly their must be anoter way, how about if I just recreate the tables? I did a backup of everything a few times and in as many ways as I could

      Comment


      • #4
        the only way to restore a database backup file is through the shell.

        Comment


        • #5
          The command Jake gave you should work for Windows systems too.
          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
            Jake is their an alternative?

            can I recreate the tables individually? my boards were running on db allmadden_org now their on all-madden-net and are updated from .6 to .9 I have 2,700 users getting pissed, I was confident I would be able to do this quickly and effectivly, however I was wrong! I do not have a linux box nor access to a telnet capable machine!

            Comment


            • #7
              Have you tried running the command Jake gave you? You do not need a Linux box to do this. You do need shell access though. If your host does not provide telnet or ssh access, then the best option is to ask them to restore your backup for you. It should only take them a couple of minutes.
              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
                also I cant get into my .org account

                I have a license that how I got here!







                Originally posted by Steve Machol
                The command Jake gave you should work for Windows systems too.

                Comment


                • #9
                  Originally posted by All-Madden
                  I have a license that how I got here!
                  Huh? No one was questioning your license. I asked you if you've run the command Jake gave you.

                  mysql -uusername -p databasename < backupname.sql
                  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


                  • #10
                    lol, your cool


                    How from were?
                    mysql -uusername -p databasename < backupname.sql
                    [/QUOTE]

                    Comment


                    • #11
                      Also were do i put the backup?

                      It on my machine now! I erased our main server nothing is left

                      Comment


                      • #12
                        You need to start reading my messages closer.

                        Your run this from the shell command line which you access via telnet or ssh. if you don;t have this access then your best option is to ask your host to do this for you.
                        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


                        • #13
                          Originally posted by All-Madden
                          It on my machine now! I erased our main server nothing is left
                          You need to upload the backup to your server.
                          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


                          • #14
                            I read it clearly

                            I asked how do i connect, and with what? I do have telnet I installed the service. but I have never done it before, i have on a linux machine, to download assignments for class but never since

                            Comment


                            • #15
                              Btw

                              Thanks for your help!

                              Comment

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