Announcement

Collapse
No announcement yet.

Mysqldump with selected tables

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Mysqldump with selected tables

    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
Working...
X