mariusv.com

Backup is a VERY important thing. I’m unfortunately not the best to remember it myself and it’s been costly.. But it is also very nice to dump all tables to a file and move it to another server and restore it with a simple command (after you have created the database of course).

To back up your database use the following command:

mysqldump -u [Username] -p[password] [databasename] > [backupfile.sql]

And to restore it again use this:

mysql -u [Username] -p[password] [databasename] < [backupfile.sql]

And then it’s done! Just remember to store your backups a safe place.