[Urgent Help] Need SSH Command ( Sql Backup)

[rahulw]

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

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


I think that this was the command which will do the work is

mysqldump -f DB -u -p | ssh user@IP of NEW SERVER "( > /home/user/public_html/test.sql)"

but i am getting this error

mysqldump: Got errno 0 on write
mysqldump: Got errno 0 on write
mysqldump: Got errno 0 on write
mysqldump: Got errno 0 on write
mysqldump: Got errno 32 on write
mysqldump: Got errno 0 on write
mysqldump: Got errno 0 on write
mysqldump: Got errno 0 on write
mysqldump: Got errno 0 on write
mysqldump: Got errno 0 on write
mysqldump: Got errno 0 on write
mysqldump: Got errno 0 on write
mysqldump: Got errno 0 on write
mysqldump: Got errno 0 on write
mysqldump: Got errno 0 on write

Please help me asap :(



Regards

[rahulw]

Topic To Be Closed > No One Alive To Help !

[koala]

You double posted. There's a reply in [Urgent Help] Need SSH Command ( Sql Backup)