Mysqldump How to use

usage:mysqldump [OPTIONS] database [tables] backing up a single library
OR mysqldump [Options]--databases [options] DB1 [DB2 DB3 ...] backing up multiple libraries
OR mysqldump [Options]--all-databases [options] back up all libraries

/usr/local/webserver/mysql/bin/mysqldump-uroot-p ' * * * '--all-databases-s/home/mysql_config/run/mysqld.sock MySQL > 1.sql

Error reason:--all-databases and MySQL conflict

/usr/local/webserver/mysql/bin/mysqldump-uroot-p ' * * * '-s/home/mysql_config/run/mysqld.sock mysql | gzip > zabbix_bk_20150302.sql.gz

Gunzip zabbix_bk_20150302.sql.gz does not retain the original compressed file

Gunzip-c zabbix_bk_20150302.sql.gz > Aa.sql retain the original compressed file and place the extracted results into the Aa.sql

Mysqldump How to use