MySQL Dumping Cheat-Sheet

Make a quick dump of a mysql database:

mysql_dump db_name > backup-file.sql

You can then read that dump file back into the server like this

mysql db_name < backup-file.sql

or like this:

mysql -e “source /path/to/backup/backup-file.sql” db_name

Leave a Reply

Your email address will not be published. Required fields are marked *

Previous post List of Ruby Operands
Next post Working with gems