mysql backup/dump all databases with mysqldump command
mysqldump --all-databases > allDB.sql
The above dumps ALL the mysql databases to "allDB.sql" but you could save a lot of space using gzip.
If you want to compress with gzip you could do this instead:
mysqldump --all-databases | gzip > ALLDB.sql.gz
To restore the compressed backup do this:
gunzip ALLDB.sql.gz | mysql -u youruser -p
How much space does gzip save?
A lot since it's essentially just text:
Look at this example where you save almost 4x the space with gzip (121M compressed vs 489M uncompressed).
-rw-r--r-- 1 root root 489M Jul 23 20:45 20260723-sqlbackup.sql
-rw-r--r-- 1 root root 121M Jul 23 20:49 20260723-sqlbackup.sql.gz
Tags:
mysql, databases, mysqldump, commandmysqldump, alldb, sql, dumps, quot, compress, gzip, gz,