Just for the record: How to combine mysqldump and zip to archive all MySQL databases on the host. I am using a simple MySQL database server on localhost, to organise research tables before analysis.
mysqldump --all-databases | zip -9 allDB_backup_110415.sql.zip -
mysqldump --all-databases writes the content of all databases into the pipe and
zip -9 Filename - compresses the standard input (note the dash ‘-‘ at the end!) to ‘Filename’ (-9 gives maximum compression).
The reverse following the man page of ‘mysqldump’:
You can load the dump file back into the server like this:
shell> mysql db_name < backup-file.sqlOr like this:
shell> mysql -e "source /path-to-backup/backup-file.sql" db_name
Rforge 