Search code examples
mysqldatabasedumpdatabase-tabledatabase-dump

Dump only the data with mysqldump without any table information


I am looking for the syntax for dumping all data in my mysql database. I don't want any table information.


Solution

  • mysqldump --no-create-info ...
    

    Also you may use:

    • --skip-triggers: if you are using triggers
    • --no-create-db: if you are using --databases ... option
    • --compact: if you want to get rid of extra comments