Search Posts on Binpipe Blog

Mysqldump Database Excluding a Table

Many a times you would like to dump a database and move it elsewhere but there is/are a certain table(s) which is very big and is causing the backup/restore a time killing job. In such a case you can invariably resort to this command snippet:
mysqldump -u username -ppassword -h localhost --ignore-table=my_db_name.my_table_name my_db_name 

You can use the '--ignore-table' switch multiple times to have multiple tables ignored.

No comments:

Post a Comment

Hi, Leave a comment here and one of the binary piper's will reply soon :)