mysqldump all tables with data, with create and add-drop tables statements (Urgent help)

Question

Hi all,

I need to take back up of mysql database,but condition is that back up file should contains only tables that contains data, and there should be an create and drop statements too.

Please me out. its very urgent. I checkd mysqldupm manual pages. did nt get options.

Thanks kumar kasimala.

Answer 1

If you know the tables that contain data, why do you not simply selectively dump those tables?

mysqldump [options] [db_name [tbl_name ...]]