Welcome guest, is this your first visit? Click the "Create Account" button now to join.
Results 1 to 1 of 1

Thread: Mysqldump with selected tables

  
Bookmark and Share
  1. #1

    Default 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

  2. # ADS
    Circuit advertisement
    Join Date
    Always
    Posts
    Many
     

 

 

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •