I get the "Database Conversion Failed!" message when trying to change to MySQL
This can happen for two different reasons. You can tell which by looking at the preceding error message.
1. If the message said: "Invalid authorization specification, message from server: "Access denied for user 'root'@'localhost' (using password: NO)"
You have configured the database to use a specific password, this is against the very important step 4 in the instructions. You should however be able to fix this manually by following the steps below:
A. Open up a command prompt.
B. Change directory to MySQLs bin-folder.
If you installed MySQL in "C:\Program Files\MySQL" enter "cd C:\Program Files\MySQL\MySQL Server 4.1\bin" and press enter.
C. Type the command "mysql --user=root --password"
D. You will be prompted for your password, type the password you used when you configured MySQL, then press enter. (If you don't remember your password you have to uninstall and then reinstall MySQL)
E. Type the command "SET PASSWORD = PASSWORD('');" and hit enter.
F. Restart PokerOffice and try the conversion again.
2. If the message said: "Database conversion failed! Database does already exist on MySQL server."
You already have a database called "pokeroffice" on your MySQL server. This can happen if you have reinstalled PokerOffice but not MySQL. You can fix this by manually editing the settings file: "../pokeroffice/settings/mysql.conf". Open up the file in a text editor and do the following:
A. Delete all text that might already be in the file.
B. Enter the text: "true" then hit enter, creating a new line.
C. On the second line enter the correct path to where MySQL is installed, E.g. "C:\Program Files\MySQL\MySQL Server 4.1"
D. Save the file and restart PokerOffice.
|