20. mysql mysqldump Backup tool

1. Back up all databases mysqldump-uroot-p--all-database >C:\all.sql backing up all databases to the All,sql file under the C drive2. Back up a database mysqldump-uroot-p foo >C:\foo.sql backup only foo database3. Back up a table mysqldump-uroot-p foo EMP >C:\foo.emp.sql backup The EMP table below the Foo database4. Full recovery based on backup files1. mysql-uroot-p Foo <C:\foo.sql PS:: You must manually create the Foo database before you can use recovery2. Mysqlbinlog mysql-bin.0000xx | Mysql-u root-p foo Log redo