Backup mysql database

xiaoxiao2021-03-06  39

The backup command can be written as a BAT and write a Services program to install a automatic backup program.

C: / mysql / bin / mysqldump --all-databases> C: //% 1 -h localhost -u root -n --default-character-set = latin1

-h is the host address

-u super administrator name

-default-character-set default character set

- AlL-Databases Backup All Databases

C: //% 1 is a database name that can be better than the parameter in the command line.

转载请注明原文地址:https://www.9cbs.com/read-85750.html

New Post(0)