MySql code snippet - mysqldump example
The following code snippet in SQL is occasionally used by me and I tend to forget the basic syntax or the same.
So here it is, just for reference for future use.
How to backup database in mysql:
Mysqldump –u username –p database_name > dump.sql
How to restore a database from dump file:
mysql -u username -p database_name < dump.sql
