- Instant help with your Sql coding problems

Create INSERT statement for each record with mysqldump

by Mike
Question:
How to create INSERT statement for each record with mysqldump?
Answer:
mysqldump -u testuser -p testdb --skip-extended-insert > /tmp/backup_insert_each.sql
Description:

If you want to create one INSERT statement for each record during backup use the --skip-extended-insert option of the mysqldump utility.

Using the --skip-extended-insert option mysqldump writes INSERT statements using one-row syntax that includes only one record in one statement. This results in a bigger dump file and slows down inserts when the file is reloaded.

This can be useful if you want to compare different database dumps as in this case the diff result is more readable.

Reference:
The --skip-extended-insert option reference
Share "How to create INSERT statement for each record with mysqldump?"
Related snippets:
Tags:
one insert for each record, one insert statement for each data row
Technical term:
Create INSERT statement for each record with mysqldump
Trending snippets
Backup only certain rows from MySQL databaseGet last 30 days records in MySQLCreate INSERT statement for each record with mysqldumpBackup MySQL data onlyBackup MySQL database without locking tablesSkip tables in MySQL backupDelete all records from a table in MySQLBackup MySQL schema onlyCreate table in MySQLDelete records from MySQL tableSort MySQL resultsGet current year in MySQLBackup only selected tables in MySQLBackup MySQL databaseList all tables in a MySQL databaseFind MySQL data directory locationConvert INT to DATETIME in MySQLList databases on MySQL serverGroup by year of Unix timestamp in MySQLImport an SQL file using the command line in MySQL
Network articles
Truncate text in TailwindCSSCreate a neon effect with TailwindCSSLocate a substring within a string in PHPFix the Using / for division outside of calc() is deprecatedSolve the Typed property X must not be accessed before initialization errorFix: Require statement not part of import statementSelect all occurrences of selected word in VS CodeAdd new Key - Value pair to an object in JavaScriptRemove emojis from a string with JavaScriptConvert snake case to camel case in JavaScriptConvert a float number to integer in JavaScriptRound a number to 2 decimal places in JavaScriptCreate endless rotation animation in CSSOpen files always in a new tab in VS CodeCreate rounded corners with CSSGenerate random string with PHPSetup xdebug 3 debugger for PHPSplit a string into wordsCompare strings in JavaStylesheet not loaded because of MIME-type