Can I change from MySQL 4.0 to MySQL 4.1

[PokerOffice Support]

Q:
Can I change from MySQL 4.0 to MySQL 4.1

A:
Yes, you can it might be a bit cumbersome, but still possible. Please follow the steps below and make an extra note of step 9.


1. Close PokerOffice.

2. Backup your database(s): Copy the MySQL sub-folder called ?data? (i.e. ?c:\mysql\data?). Copy it to a location of your choice, like ?My Documents?

3. Uninstall/remove MySQL 4.0: Open ?Control Panel? then select ?Add or Remove Programs? then select MySQL 4.0 and click ?Remove?.

4. Follow the uninstaller?s instructions.

5. Restart your computer.

6. Download the file: mysql-4.1.7-essential-win.msi from http://dev.mysql.com/get/Downloads/M...m/pick#mirrors

7. Run the MySQL 4.1 ?mysql-4.1.7-essential-win.msi?-file.

8. Follow the installer?s instructions.

9. Important: When you get to the point in the installer which say ?Wizard Complete? you must uncheck the checkbox which say ?Configure the MySQL Server now?, then click the ?Finish?-button.

10. Copy back the ?data?-folder which you backed up in step 1. and paste it in the MySQL 4.1 root folder. (i.e. C:\Program Files\MySQL\MySQL Server 4.1)

11. Answer ?Yes To All? to the question ?Confirm Folder Replace?

12. Open the file called ?mysql.conf? in the PokerOffice ?settings?-folder (i.e. C:\Program Files\PokerOffice\settings)

13. Replace whatever is on the second line (i.e. c:\mysql) with the line matching the path where you installed MySQL 4.1 (i.e. C:\Program Files\MySQL\MySQL Server 4.1)

14. Done! Start PokerOffice