Wednesday, December 16, 2015

Mysql :: How can I dump a specific table or set of tables without including the rest of the db tables?

Mysql :: How can I dump a specific table or set of tables without including the rest of the db tables?

Soln:-

mysql -u -p -e 'show tables like "_%"' | grep -v Tables_in | xargs mysqldump -u -p 

mysql dump data only :-
mysqldump --no-create-info

mysql dump structure only :-
mysqldump --no-data

No comments: