chetan chetan - 1 year ago 139
MySQL Question

create dump file from database in mysql

following is the that I create dump from mysql database.

mysqldump -u root tempbkk > ttt.dump

but I want to create a dump that exclude one or more file while creating dump from database we select.What is the command for that ?

Answer Source

mysqldump can skip tables, you need the --ignore-table parameter. Check out the manual of mysqldump.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download