mkoryak
Reputation: 57928
How can I mysqldump the contents of a few tables or just the schema?
Can you help me with the following:
- dump from the database just the contents of a few tables?
- dump just the schema?
Upvotes: 0
Views: 233
Answers (1)
Ignacio
Reputation: 5720
mysqldump -u username -p database [table] > file.sql
Use the --no-data option to dump just the schema.
mysqldump --no-data ...
Upvotes: 3
Related Questions
- How to skip certain database tables with mysqldump?
- Dump only the data with mysqldump without any table information
- How to dump only specific tables from MySQL?
- How to mysqldump WITHOUT dropping any tables
- mysqldump entire structure but only data from selected tables in a single command
- How to use mysqldump only specific database and table in MYSQL
- mysqldump all tables with data, with create and add-drop tables statements
- Mysqldump more than one table?
- mysqldump with some tables, not using --skip-table
- Dump tables from database in mysql?