Problem: backing up sql

[eXaLs]

my sql is 252mb :(
i tried to backing up with ssh but everytime give me this problem

Session is Closed
Disconnected from server

what can i do? how do i backing up it

thanks

[nexialys]

session closed during process ?!

you can ask your host about this behavior, and they may even help

[timnp]

Yeah ask your host. I think in MySQL config there is an option for setting the maximum execution time of a query, perhaps this value is set too low.

[Marco van Herwaarden]

It is not his MySQL server that is closing the connection. ;) It is the server that closes a SSH connection if no input is received after some time. It could help if you just ype a character once every minute to keep the connection alive.

[eXaLs]

It could help if you just ype a character once every minute to keep the connection alive.

how can i do this?

[timnp]

Or screen it.

login to ssh, type "screen" , run your commands

If you get disconnected then login and reattach to the screen "screen -r".

You can have multiple screens open at any one time, if so then you need to specify the number when reattaching "screen -r ###" , you can get a list of the numbers with "screen -ls", the man pages are well worth a read on this one its very handy.

Not always installed by default but availiable for pretty much all distros, "yum install screen" or whatever.