MySQL backup data that meets specific criteria

When using MySQL data export for backup, the entire table of data is backed up, sometimes just want to back up part of the data, this time can use the following methods:

1. Use INSERT into and select to combine:

Insert  into  Selectfrom where>= "-  < 9-03 ";

This will back up the data that satisfies the where limit to the new Table_bak table.

2. Use SELECT INTO outfile to back up the data to a file:

SELECT  into OUTFILE "/tmp/result. text  by ' , '  by ' " '  by ' \ n '  from Table_data;

This method requires the operation permissions of the machine running the MySQL service. Some cloud databases do not provide access to the machines running the MySQL service, so this method does not necessarily apply.

3. Mysqldump-w

- -p password table_data–> tmp.dump

This method is not tested.

MySQL backup data that meets specific criteria