Menu
If my database has 10 tables and I want to dump only 3 tables. Is it possible with mysqldump command?
293
Open the MySQL database wizard & select the table you want to export. Right-click on the table name & select the table data export wizard option.
To dump multiple tables with multiple where conditions. Then, for second table, use ">>". It will append the previous dump file.
If you want to export only certain rows from a MySQL database using mysqldump , you can select the records using the --where option. It dumps only rows selected by the given WHERE condition. Quotes around the condition are mandatory if it contains spaces or other characters that are special to your command interpreter.
Usage: mysqldump [OPTIONS] database [tables] i.e.
mysqldump -u username -p db_name table1_name table2_name table3_name > dump.sql If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
