MySQL command to Extract DDL and DML and Exclude tables which are not required?

Question

I have a db and looking for a mysql commands to extract Extract DDL and DML and Exclude tables which are not required

could you please let me know how we can do it via command prompt?

Thanks, Kathir

score 2 · Accepted Answer · answered Oct 22 '13 at 08:35

2

Mysqldump:

able to dump DDL/DML and has option for exclude list of tables:

answered Oct 22 '13 at 08:35

Sergey N Lukin

can you pls specific the command for DDL as well as DML? – Kathir Oct 22 '13 at 09:50
for ddl: mysqldump -uroot -pmysql --no-data testdb > testdb_exported_ddl_file.sql for dml: mysqldump -uroot -pmysql --skip-triggers --no-create-info --ignore-table=testdb.emp_table --ignore-table=testdb.emp_history testdb > testdb_dml.sql – Kathir Nov 13 '13 at 08:46

1 Answers1