Skip to content

Instantly share code, notes, and snippets.

@berliozd

berliozd/mysql_dump_import.sh

Last active March 4, 2020 11:03
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save berliozd/94d39281839b0266cbfc441f0dddfa48 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save berliozd/94d39281839b0266cbfc441f0dddfa48 to your computer and use it in GitHub Desktop.
Download ZIP
mysql dump and dump import
Raw
mysql_dump_import.sh
# simple dump
mysqldump -u <user> -h <host> -p <database_name> > dump.sql
# simple dump as gzip file
mysqldump -u <user> -h <host> -p <database_name> | gzip -> dump.sql.gz
# gzip a dump
cat dump.sql | gzip -> dump.sql.gz
# import a dump
mysql -u <user> -h <host> -p <database_name> < dump.sql
# import a gzip dump
zcat dump.sql.gz | mysql -u <user> -h <host> -p <database_name>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment