Q:
Can I change the Database engine?
A:
Yes you can use a MySQL database instead of the internal Java database. MySQL will greatly improve performance for large databases. Please follow the steps below to change to MySQL. Please take special note of step 4.
1. Download MySQL 4.1.14 from
http://downloads.mysql.com/archives/...1.14-win32.msi
or go to
http://www.mysql.com and download 4.1.14
2. Run the mysql-essential-4.1.14-win32.msi-file.
3. Follow the installers on-screen instructions to complete the installation.
4. 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.
5. Start PokerOffice and select the "Change Database to MySQL" option from the 'Database'-menu. A new window will pop up.
6. In the new window check the "Use MySQL as the database engine" checkbox. You must also enter where you have installed MySQL (i.e. C:\Program Files\MySQL\MySQL Server 4.1))
7. Press the Save button. If you have done the above steps correct your database engine should change to MySQL and your databases will be converted to the new database.
8. Done! Restart PokerOffice.