backup/restore certains tables using ssh

[xShanex]

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)

[Steve Machol]

50 Mbs should not be a problem. What command exactly are you using?

[xShanex]

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

[Steve Machol]

Hmmm...and what is the error you are getting? I've never heard of a timeout error when running this from the command line.

[xShanex]

ERROR 2006 at line 699: MySQL server has gone away

[Steve Machol]

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

http://www.vbulletin.com/forum/showthread.php?s=&amp;postid=310265#post310265

Edit: A bug is keeping me from posting this link. You need top remove the 'amp;' to get this to work.

[xShanex]

dead link

[Steve Machol]

Originally posted by xShanex
dead link

See my edited note.

[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?

[Steve Machol]

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.