Tweet
mysqldump with selected tables
Mysql Command to take Dump of Selected Tables in the Mysql Database
If you wish to take dump of on few tables such as table1, table2 & table3 use the command
mysqldump -u mysqlusername -p databasename table1 table2 table3 > databasebackup.sql
If you wish to take backup of the database by ignoring specific tables such as table1 and table2 and generate the dump containing all the tables.
Use the following command.
mysqldump -u username -p database –ignore-table=database.table1 –ignore-table=database.table2 > database.sql
If you have multiple database use the following command.
mysqldump -u user -p –ignore-table=database1.table1 –ignore-table=database2.table2 –databases database1 database2
Mysql Command to take Dump of Selected Tables in the Mysql Database
If you wish to take dump of on few tables such as table1, table2 & table3 use the command
mysqldump -u mysqlusername -p databasename table1 table2 table3 > databasebackup.sql
If you wish to take backup of the database by ignoring specific tables such as table1 and table2 and generate the dump containing all the tables.
Use the following command.
mysqldump -u username -p database –ignore-table=database.table1 –ignore-table=database.table2 > database.sql
If you have multiple database use the following command.
mysqldump -u user -p –ignore-table=database1.table1 –ignore-table=database2.table2 –databases database1 database2