Skip to content

Instantly share code, notes, and snippets.

@ekapujiw2002

ekapujiw2002/gist:c9dc8fff7ffc9eeeb8a027b23fa2647b

Forked from carltondickson/gist:b14d72d9d3631f870c48
Created June 7, 2022 02:16
Show Gist options
  • Save ekapujiw2002/c9dc8fff7ffc9eeeb8a027b23fa2647b to your computer and use it in GitHub Desktop.
Save ekapujiw2002/c9dc8fff7ffc9eeeb8a027b23fa2647b to your computer and use it in GitHub Desktop.
Download ZIP
mysqldump export and zip
Raw
gistfile1.sql
# Exporting entire database:
mysqldump -u user -p database --opt | gzip > database.sql.gz
# Export table
mysqldump -uroot --opt --databases DB_NAME --tables TABLE_NAME | gzip > /tmp/TABLE_NAME.export.sql.gz
# Importing:
gunzip < database.sql.gz | mysql -u user -p database
# Credit http://failshell.io/mysql/using-gzip-and-gunzip-with-mysql-to-importexport-backups/
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment