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
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
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
Regards