For export : mysqldump -u root -p DBNAME > mybackUP.sql
For import : mysql -u root -p DBNAME < mybackUP.sql
mysqldump -p -h 192.168.1.11 DBName > filename.sql
mysqldump –no-data -u root -p DBNAME > mybackUP.sql
mysql -u username -p dbname –ignore-table=db.tbname –ignore-table=db.tbname < C:\wamp\bin\mysql\filename.sql
mysqldump -u username -p dbname –ignore-table=db.tbname –ignore-table=db.tbname >filename.sql
mysqldump -u username -e -q –single-transaction –master-data –databases dbname -p > fulldump.sql
grant replication slave on *.* to ‘user’@’localhost’ identified by ‘pass’;flush privileges;