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
More Related Contents:
- “INSERT IGNORE” vs “INSERT … ON DUPLICATE KEY UPDATE”
- How can I make SQL case sensitive string comparison on MySQL?
- Library not loaded: libmysqlclient.16.dylib error when trying to run ‘rails server’ on OS X 10.6 with mysql2 gem
- Count the occurrences of DISTINCT values
- Codeigniter – multiple database connections
- Column count doesn’t match value count at row 1
- How to add levenshtein function in mysql?
- How to search JSON data in MySQL?
- MySQL > Table doesn’t exist. But it does (or it should)
- INSERT INTO … SELECT FROM … ON DUPLICATE KEY UPDATE
- How do I modify a MySQL column to allow NULL?
- Connect to mysql in a docker container from the host
- Is there ANY_VALUE capability for mysql 5.6?
- Set NOW() as Default Value for datetime datatype?
- MySQL update CASE WHEN/THEN/ELSE [duplicate]
- SQL DELETE with JOIN another table for WHERE condition
- How to connect to a MySQL Data Source in Visual Studio
- DOs and DONTs for Indexes [closed]
- Error Dropping Database (Can’t rmdir ‘.test\’, errno: 17)
- MySQL: #1075 – Incorrect table definition; autoincrement vs another key?
- mysql update query with sub query
- How can I implement single table inheritance using Laravel’s Eloquent?
- Converting SELECT DISTINCT ON queries from Postgresql to MySQL
- Integrity constraint violation: 1452 Cannot add or update a child row:
- How to change the mysql root password
- How can I set autoincrement format to 0001 in MySQL?
- Why MYSQL IN keyword not considering NULL values
- MySQL. Can’t create table errno 150
- Returning records from the last 3 months only in MySQL
- Incorrect integer value: ” for column ‘id’ at row 1