- 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
Get last 30 days records in MySQLDelete all records from a table in MySQLSort MySQL resultsCreate table in MySQLBackup MySQL data onlyCreate INSERT statement for each record with mysqldumpBackup MySQL database without locking tablesBackup only certain rows from MySQL databaseList all tables in a MySQL databaseDelete records from MySQL tableBackup MySQL schema onlyList databases on MySQL serverBackup only selected tables in MySQLBackup MySQL databaseSkip tables in MySQL backupFind MySQL data directory location
Network articles
Add key prop to React fragmentWrite vertical text in HTMLTest with multiple data using PHPUnitRemove HTML tags from a string in PHPWrite comments in CSSPHP form data into arrayPHP Array tutorialPHP heredoc syntaxConvert binary to decimal in PHPCreate mailto link with pre-populated contentSet cursor to pointer in CSSSet media query in CSSAutomatically redirect HTTP to HTTPS on Apache webserversSet selected element in a drop down listGet the last day of a month in JavaGet the number of days between two dates in JavaAdd CSS class based on condition in ThymeleafUse foreach in JavaScriptReplace spaces with dashes in JavaScriptGet month name from Date in JavaScript