How do I manually backup my database via SSH/telnet?

[VelMurugan]

How do I manually backup my database via SSH/telnet?

If you need SSH access, open a support ticket with a request to enable SSH. Remember to include a qualified reason of why you require SSH access.


How to back up a mySQL database using SSH Telnet:

Log into your account on our server and issue the following command:

[This is all one command line!]

/usr/bin/mysqldump $databasename -u $user -p$password > /home/$user/file.dump

$ indicates a variable, so instead of entering $user, you'll enter your actual user name for your account. Your mySQL username and password are usually the same as the ones that you use to access your control panel.

For example, your actual command might look like this:

/usr/bin/mysqldump joescars_com -u frankie -p18circ > /home/frankie/joesbackup.sql


How to restore a mySQL database using SSH Telnet:

Log into your account on our server and issue the following command:

[This is all one command line!]

mysql $databasename -u $user -p$password < /home/$user/file.dump

Source : esupport

[nandagopal]

Thanks vel,

This is what i am searching for, command for restore a mySQL database using SSH Telnet

It works perfectly...