[Urgent Help] Need SSH Command ( Sql Backup)

rahulw · 05-13-2007, 12:39 PM

Hello Mates ,

I want to transfer a huge database (sql ) of 5 GB to other server ( Remote ) , but i do not know how to do it ! and later i want to restore it also on the 1st server after i format it !!

I know how to backup on my own server by using

Quote:

mysqldump -q -uxyourdomain -p -hmysql.yourdomain.com xyourdomain_2 >./myfile.txt

But please help me in telling a command which can make MySql backup from DB to another server

and

a command which can restore MySql backup of DB to another server

Regards

~~PureEvilDan~~ · 05-13-2007, 01:55 PM

Code:

mysql -u username -p -h 192.168.1.1 databasename < data.sql

Replace the ip with either the ip of the server or the host name, and fill in the other italics with your details.

rahulw · 05-14-2007, 11:28 AM

Quote:

Originally Posted by PureEvilDan

Code:

mysql -u username -p -h 192.168.1.1 databasename < data.sql

Replace the ip with either the ip of the server or the host name, and fill in the other italics with your details.

EVEN THIS IS OF NO GOOD !!

PLEASE CLOSE THIS TOPIC TOO

05-13-2007, 01:55 PM	#2 (permalink)
~~PureEvilDan~~ Register user Join Date: May 2005 Location: England Posts: 229 OS: Gentoo AMD XP 2400+ 1GB Ram / WinXp Intel 805D 2GB Ram My System	Re: [Urgent Help] Need SSH Command ( Sql Backup) Code: mysql -u username -p -h 192.168.1.1 databasename < data.sql Replace the ip with either the ip of the server or the host name, and fill in the other italics with your details.