Announcement

Collapse
No announcement yet.

backup/restore certains tables using ssh

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

  • backup/restore certains tables using ssh

    My database is over 50mbs in size and I'm moving it to another server and when I tried to do a move it using ssh I get timed out.

    So I was wondering what commands do I use to insert say my post table into the database, it's 19mbs and that shouldn't time out and I could just delete it from orignal database and just drop it into the new one after I move the other to the new server. Also is there a way to do backup a table using ssh because using phpmyadmin times out after so long..

    Thanks (hope it made sense)

  • #2
    50 Mbs should not be a problem. What command exactly are you using?
    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


    • #3
      Originally posted by Steve Machol
      50 Mbs should not be a problem. What command exactly are you using?
      mysql -u shane -p shane_vbtemp < /home/shane/backup/bk010303.sql

      I've tried it on two servers and the same thing happened

      Comment


      • #4
        Hmmm...and what is the error you are getting? I've never heard of a timeout error when running this from the command line.
        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


        • #5
          ERROR 2006 at line 699: MySQL server has gone away

          Comment


          • #6
            This is a server issue. Here are the reasons for the MySQL server going away:

            http://www.vbulletin.com/forum/showt...265#post310265

            Edit: A bug is keeping me from posting this link. You need top remove the 'amp;' to get this to work.
            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


            • #7
              dead link

              Comment


              • #8
                Originally posted by xShanex
                dead link
                See my edited note.
                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


                • #9
                  Yeah timing out (as I said) I'll ask my host what the time out limit is and it must be low since it does it after a minute..

                  While I wait does anyone know the commands for what I asked in the first post?
                  Last edited by xShanex; Fri 3rd Jan '03, 9:53pm.

                  Comment


                  • #10
                    Originally posted by xShanex
                    Yeah timing out (as I said) I'll ask my host what the time out limit is and it must be low since it does it after a minute..

                    While I wait does anyone know the commands for what I asked in the first post?
                    Nope - sorry.
                    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

                    Loading...
                    Working...
                    X