Quck and Dirty MySQL Database Backup

Here is a quick and dirty way to backup a database in MySQL, structure and data included. Run this from the command line, NOT the MySQL Client command line:

C:\Program Files\MySQL\MySQL Server 4.1\bin>mysqldump --user=root 
--password=mypassword --databases mydbname
--result-file=c:\mydbname-20070608.sql

Of course, this assumes a Windows environment and that the installation directory is the same.

phpMyAdmin and the "Client does not support authentication" Error

When you see the following error...

#1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client

...there is a problem with the password you created for a user. You'll need to run...

mysql> SET PASSWORD FOR 'username'@'host' = OLD_PASSWORD('password');

See http://dev.mysql.com/doc/refman/5.0/en/old-client.html for more information.