mysqldump --no-create-info -uxxxx -pxxxx Database ATable | gzip -9 > xxxx.sql.gz
zcat xxxx.sql.gz | mysql -uxxxx -pxxxx Database
mysqldump --no-create-info -uxxxx -pxxxx Database ATable | gzip -9 > xxxx.sql.gz
zcat xxxx.sql.gz | mysql -uxxxx -pxxxx Database
Tags: admin, backup, cli, command, dump, linux, mysql, mysqldump, restore, server, sysadmin, zcat
Posted in Code, Systems | No Comments »