If you have a compressed file from a mysqldump backup of your mysql database, and you don’t have space to uncompress it to load it on another machine.  You can load it directly from the compress file using this command: zcat backupdump.sql.gz | mysql -uusername -p databasename This will uncompress the file on the fly [...]