MySql

During my project implementation, I found a scenario where whole database dump is required except few table which will be processed by a script.

After doing a bit of research, I found it is pretty easy with mysqldump command using --ignore-table option.

mysqldump -uusername -ppassword -h localhost --ignore-table=my_db_name.my_table_name my_db_name