MySQL backup upgrade and restore
Before an upgrade from MySQL 5.0.x to MySQL 5.1 I did a backup of all databases. First I created a folder without any spaces in the path:
C:\mysql
Then I start the command prompt (cmd) and run:
mysqldump -u root -p -all-databases > C:\mysql\backup.sql
Enter the password when MySQl ask for it, and when MySQL is done, I uninstall MySQL 5.0.x and installs the MYSQL 5.5 by MS Web Platform Installer.
When done I run the following in the command prompt:
mysql -u root -p < C:\mysql\backup.sql