Reply to thread

Message

OK, it's been a very long time, but for completeness: the MySQL problems persisted (slow startup) whatever I tried. Then a recent power cut messed up my HTPC and I had some repairs to do - and thought I'll have another go at getting MySQL to work properly. Tried a complete uninstall (including relevant program and app data folder deletions after exporting my TV channels etc) and reinstall (if you run the deploy tool thingy it will only reinstall the MySQL bit) - check at the final before install screen) => no improvement. So I thought well how about finally trying MS SQL Server? MP seems to be set up ready to do it with at least the 2005 Express version (no complex ini files to cut and paste etc). So deleted MySQL again as above, and did the deploy tool thing again, only selecting MS SQL Server as the database - and it installed with out error. Needed a reboot (the TV service was still tied to MySQL) and of course import of the exported channels etc and Bingo - MP started! Plus none of that hanging around while MySQL got going...

So if anyone else has the same problem, and is like I was too nervous to try switching from MySQL to MS SQL Server - all I can say is that having bitten the bullet, it seems to work!

<blockquote data-quote="CathodeRay" data-source="post: 1213861" data-attributes="member: 128074">OK, it's been a very long time, but for completeness: the MySQL problems persisted (slow startup) whatever I tried. Then a recent power cut messed up my HTPC and I had some repairs to do - and thought I'll have another go at getting MySQL to work properly. Tried a complete uninstall (including relevant program and app data folder deletions after exporting my TV channels etc) and reinstall (if you run the deploy tool thingy it will only reinstall the MySQL bit) - check at the final before install screen) =&gt; no improvement. So I thought well how about finally trying MS SQL Server? MP seems to be set up ready to do it with at least the 2005 Express version (no complex ini files to cut and paste etc). So deleted MySQL again as above, and did the deploy tool thing again, only selecting MS SQL Server as the database - and it installed with out error. Needed a reboot (the TV service was still tied to MySQL) and of course import of the exported channels etc and Bingo - MP started! Plus none of that hanging around while MySQL got going...So if anyone else has the same problem, and is like I was too nervous to try switching from MySQL to MS SQL Server - all I can say is that having bitten the bullet, it seems to work!</blockquote>

[QUOTE="CathodeRay, post: 1213861, member: 128074"] OK, it's been a very long time, but for completeness: the MySQL problems persisted (slow startup) whatever I tried. Then a recent power cut messed up my HTPC and I had some repairs to do - and thought I'll have another go at getting MySQL to work properly. Tried a complete uninstall (including relevant program and app data folder deletions after exporting my TV channels etc) and reinstall (if you run the deploy tool thingy it will only reinstall the MySQL bit) - check at the final before install screen) => no improvement. So I thought well how about finally trying MS SQL Server? MP seems to be set up ready to do it with at least the 2005 Express version (no complex ini files to cut and paste etc). So deleted MySQL again as above, and did the deploy tool thing again, only selecting MS SQL Server as the database - and it installed with out error. Needed a reboot (the TV service was still tied to MySQL) and of course import of the exported channels etc and Bingo - MP started! Plus none of that hanging around while MySQL got going... So if anyone else has the same problem, and is like I was too nervous to try switching from MySQL to MS SQL Server - all I can say is that having bitten the bullet, it seems to work! [/QUOTE]