dump database to file:
mysqldump --opt -h 192.168.0.2 -P 3306 -u adm -padm -R mydb > mydb.sql&
load data from file:
source mydb.sql
mysql -u{username} -p{password} mydb < mydb.sql
dump database to file:
mysqldump --opt -h 192.168.0.2 -P 3306 -u adm -padm -R mydb > mydb.sql&
load data from file:
source mydb.sql
mysql -u{username} -p{password} mydb < mydb.sql