I have to get back from mysql database,but condition is the fact that support file should consists of only tables that consists of data, and there must be an create and drop claims too.

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

Thanks kumar kasimala.

Knowing the tables which contain data, so why do explore simply selectively dump individuals tables?

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