Mysql Dump

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;

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>