Import Gzipped Mysql Dump

If you ever need to import a gzipped MySQL dump on the CLI, here’s a quick an easy command to do it while leaving the dump file compressed.

zcat < /path/to/sqldump.sql.gz | mysql -u username -p db_name

Related Posts

Find Empty Directories
Create Large File Using fallocate
No Audio on Razer Book 13 (Linux)
Recursively Count Files in Directories With Linux
Kill All MySQL Queries With State
© 2014 - 2023 · Home ·