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
Soln:-
mysql
mysql dump data only :-
mysqldump --no-create-info
mysql dump structure only :-
mysqldump --no-data
No comments:
Post a Comment