- Instant help with your Sql coding problems

Backup only certain rows from MySQL database

by Mike
Question:
How to backup only certain rows from MySQL database?
Answer:
mysqldump -u testuser -p testdb events --where="event_date>='2020-06-01' AND event_date<='2020-08-31'" > /tmp/backup_filtered.sql
Description:

If you want to export only certain rows from a MySQL database using mysqldump , you can select the records using the --where option. 

It dumps only rows selected by the given WHERE condition. Quotes around the condition are mandatory if it contains spaces or other characters that are special to your command interpreter.

Reference:
The --where option reference
Share "How to backup only certain rows from MySQL database?"
Related snippets:
Tags:
backup only certain rows, dump some records only, selected row only
Technical term:
Backup only certain rows from MySQL database
Trending snippets
Create table in MySQLSort MySQL resultsList all tables in a MySQL databaseDelete all records from a table in MySQLFind MySQL data directory locationList databases on MySQL serverDelete records from MySQL tableGet last 30 days records in MySQLBackup MySQL schema onlyBackup MySQL data onlyBackup MySQL databaseSkip tables in MySQL backupBackup only selected tables in MySQLBackup MySQL database without locking tablesBackup only certain rows from MySQL databaseCreate INSERT statement for each record with mysqldump
Network articles
Add minutes to date time in PHPGet the last day of a month from date in PHPRemove HTML tags from a string in PHPGet the number of days between two dates in PHPForce line break in a long word using CSSGet actual date in PHPRemove focus border around input elementPHP array lengthPHP Array tutorialPHP in_array function use and examplesCreate mailto link with pre-populated contentRedirect all requests to index.php using htaccessUse dns-prefetch to improve performanceSet X-Frame-Options on Apache webserversSet selected element in a drop down listGet the first Monday of a month in JavaDetect Ctrl+C and Ctrl+V using JavaScriptGet yesterday's date in JavaCreate new dialect in ThymeleafGet yesterday's date in JavaScript