Skip to content

Instantly share code, notes, and snippets.

@visabhishek

visabhishek/db_backup_with_procedure.sql

Created April 19, 2016 16:45
Show Gist options
  • Save visabhishek/5a5cb1882048a937fbc771d5433c6686 to your computer and use it in GitHub Desktop.
Save visabhishek/5a5cb1882048a937fbc771d5433c6686 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
db_backup_with_procedure.sql
//mysql export
mysqldump --opt --max_allowed_packet=512M -u root -p np_bo > np_bo_dumpxx.sql
//mysql import
mysql --max_allowed_packet=512M -u username -p db < sqlfile.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment