Pernod
Admin
| Posts: 2783 |  |
 
|
Upgrading MySQL - 2009/08/02 09:51
I have identified an issue when upgrading MySQL from previous versions.
When using the Simese installation package to update MySQL and PHP it will replace existing MySQL executables but not actually upgrade the database.
For most users this may not be a problem. When upgrading MySQL you should upgrade through each release of MySQL to avoid corrupting your existing database. ie. 4.0 -> 5.0 -> 5.1. You cannot upgrade a 4.0 database to 5.1, you must upgrade to 5.0 first.
Even though I had been previously using MySQL 5.0 for some time I expected upgrading to 5.1 to not be a problem. However, my database was originally created years ago using 4.0 and worked with MySQL 5.0 but was still a 4.0 database. MySQL 5.1 claimed this database had Incorrect key file for table '...'; try to repair it. Corrupt. and was unable to repair it. This was the case for most tables in the database, newer tables created with 5.0 were fine.
To solve this problem I had to reinstall MySQL 5.0 and use mysql_upgrade to make sure the database was upgraded before installing 5.1.
This may be complicated to understand for some users, so to avoid all this I would recommend that before upgrading Simese, PHP, MySQL you should export your SwissCenter settings to XML and also run a 'Export all extra information to XML' for video and tv to ensure you have a backup of all data.
After the upgrade if you have problems then re-create the database and import all your settings. The only data which will be missing will be the Theme settings unfortunately.
This issue is only applicable if your existing database was created using a pre MySQL 5.0 release.
Players : Netgear EVA700 | Popcorn A-100 (091202) | Popcorn A-200 (100208)
Webserver : Simese v2.6.4 | Apache 2.2.14 | PHP v5.2.12 | MySQL v5.1.32
Server : Windows 7 Home Premium 64bit
Spec : Intel C2Q Q6600 - 4GB RAM - 3TB HDD
AV : Pioneer VSX-915 | Samsung LE40C650 |
Forums 
