Shulou(Shulou.com)06/01 Report--

Backup: mysqldump-u user-p pwd-h host dbname [tbname, [tbname...]] > filename.sql-(logical backup)-Q or-quick-No memory usage-w "WHERE Clause" or-where = "Where clause"-condition-- all-databases-all databases-databases-multiple databases Separate databases with spaces-skip-opt-do not use memory mysqlhotcopy db_name_1,...db_name_n / path/to/new_directory-Cold backup (physical backup) (not applicable to InnoDB)-Hot backup does not apply to myisam restore: mysql-u user-p [dbname]

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.