Windows MySQL backup, restore, using mysqldump

Direct backup mysqldump-u user name-p password-h 192.168.1.15-c--default-character-set=utf8 database name >XXX.SQL use gzip compressed backup mysqldump-u user name-p password -H 192.168.1.15-c--default-character-set=utf8 database name | Gzip >xxx.sql Direct Restore MYSQL-U user name-p password-C--default-character-set=utf8-h192.168.1.15 database name using gzip decompression restore gzip-d <xxx.bak | Mysql-u User name-p password-C--default-character-set=utf8-h192.168.1.15 database name