I use MySQL.  I like MySQL... but I don't trust MySQL. 

Actually, I don't trust anything computer-based, its nothing against MySQL at all... so I like to back up my databases from time to time.

Now because I have my own server, I can use the command line to do most of my management, which I prefer,  but try as I might the backup and restore commands escape me every time I go to use them... so here they are, just for me (and you too)

to back up:

mysqldump -u username -p databasename > backupfile.sql

To restore:

Have you had this error while developing a Drupal site on a WAMP server?  Its common, and relatively easy to fix.

<strong>Fatal error</strong>:  Maximum execution time of 30 seconds exceeded in <strong>C:\wamp\www\&lt;mysite&gt;\includes\database.mysqli.inc</strong> on line <strong>108</strong>

I recently decided to install WAMP so that I could speed up my development, and work on my development projects on my laptop while not within internet coverage.  There are a number of ways to do this, but one of the more popular is the WAMP package (www.wampserver.com) which automagically installs the server packages you need to run most modern sites, including Drupal.