Backing up MySQL databases

Backup...

> mysqldump mydatabase > mydatabase.sql


Restore...

> mysql < mydatabase.sql


Options:

-X : outputs database info as XML.
--all-databases : dumps all databases to stdio
-p : to add a password