Mysql database backup and table data export based on conditions

Mysql database backup and conditional export of table data 1. Backup database # mysqldump-u root-p dbcurr>/home/20090219. SQL mysqldum is the BACKUP command,-u user,-p password, dbcurr Database Name,> Backup character,/home/20090219. path of the data file stored in SQL. Www.2cto.com Note: If you back up a remote database, you only need to add the-h parameter and the specific IP address before-u. 2. Restore the database # mysql-u root-p dbcurr