Skip to content

Instantly share code, notes, and snippets.

@smithcommajoseph

smithcommajoseph/dump.mysql

Created March 26, 2012 23:19
Show Gist options
  • Save smithcommajoseph/2210559 to your computer and use it in GitHub Desktop.
Save smithcommajoseph/2210559 to your computer and use it in GitHub Desktop.
Download ZIP
Skip phpMyAdmin and dump your DB using terminal commands
Raw
dump.mysql
mysqldump -u DATABASE_USER -p -h HOST DATABASE_NAME > FILE.sql
Raw
import.mysql
mysql -u DATABASE_USER -p -h HOST DATABASE_NAME < FILE.sql
Raw
timestamp.mysql
site_name_$(date +%Y-%m-%d-%H%M.%S).sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment