Home > General > MySql DB Dump Queries

MySql DB Dump Queries

December 6, 2011

Syncronize remote database with local one
===========================================
mysqldump -uroot -proot -hlocalhost -C hq | ssh @ “mysql -uroot -proot HQ”

Syncronize local database with remote one
===========================================
ssh@ “mysqldump -uroot -proot HQ” | mysql -uroot -proot -hlocalhost -C hq


Mysql dump command

===================
mysqldump -uroot -pw1On5NCz HQ > datadump.sql for exporting

mysqldump -uroot -pw1On5NCz HQ < datadump.sql for importing

Advertisements
Categories: General
%d bloggers like this: