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 »
sed is a wonderful tool. Just used this command today to remove most of the whitespace from a file.
sed 's/ //g' test.txt > test2.txt
Tags: cli, command, linux, manipulation, sed, systems, text
Posted in Code, Systems | No Comments »