Pages

Tuesday, June 26, 2012

mysql dump of data only - no table and database schema

Mates, I want to dump the data from the tables only rather than its definition and data.

The problem with mysqldump is it checks if database/table exist  or not. if the table exist it drops the table create the blank table and then enters the insert into statements. I don't want to use this.

goggled and found



dump the database with options --no-create-db and --no-create-info


No comments:

Post a Comment