Skip to content

Instantly share code, notes, and snippets.

@z2015

z2015/mysql.sql

Created May 2, 2016 02:32
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save z2015/45b21f0af43536d727967ed152a9c3d4 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save z2015/45b21f0af43536d727967ed152a9c3d4 to your computer and use it in GitHub Desktop.
Download ZIP
mysql备份还原操作命令
Raw
mysql.sql
mysqldump -u username -p database_to_backup > backup_name.sql
mysql -u username -p
CREATE DATABASE database_name;
exit
mysql -u username -p database_name < backup_name.sql
//https://www.digitalocean.com/community/tutorials/how-to-backup-mysql-databases-on-an-ubuntu-vps
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment