Skip to content

Instantly share code, notes, and snippets.

@andysdesigns

andysdesigns/gist:12005a233a8bb73413a5dc61c5ab5b52

Created January 31, 2018 14:02
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save andysdesigns/12005a233a8bb73413a5dc61c5ab5b52 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save andysdesigns/12005a233a8bb73413a5dc61c5ab5b52 to your computer and use it in GitHub Desktop.
Download ZIP
Mysql Import + Export using terminal
Raw
gistfile1.txt
# import .sql.gz with progress bar
>> pv [/path/to/database.sql.gz] | gunzip | mysql -u [username] -p [database_name]
---
# import .sql without progress bar
>> mysql -u [username] -p [database_name] < [/path/to/database.sql]
---
# export
>> mysqldump -u [username] -p [database_name] > [database_name.sql]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment