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

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

Sergei N Lukin · Accepted Answer · 2013-10-22 08:35:35Z

2

Mysqldump:

http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html

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

http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html#option_mysqldump_ignore-table

answered Oct 22, 2013 at 8:35

Sergei N Lukin

5952 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Kathir Over a year ago

can you pls specific the command for DDL as well as DML?

Kathir Over a year ago

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

Collectives™ on Stack Overflow

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

1 Answer 1

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Linked

Related