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 :)