format37/mysql_backup.txt

Last active January 19, 2021 17:11

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/format37/2093a3caad1cefcd3c18cb55d73612fb.js"></script>
Save format37/2093a3caad1cefcd3c18cb55d73612fb to your computer and use it in GitHub Desktop.

Download ZIP

msql backup

Raw

mysql_backup.txt

	mysqldump -u USER -p PASSWORD DATABASE > dump.sql

	mysql
	create database DATABASE;

	mysql -u USER -p PASSWORD DATABASE < dump.sql

Author

format37 commented Jan 19, 2021 •

edited

Loading

saving

mysqldump --databases db_name > mydump.sql
or
mysqldump --all-databases > mydump.sql

loading

mysql < mydump.sql

https://www.dbrnd.com/2017/11/mysql-copy-database-from-one-server-to-another-server-using-mysqldump/

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment