1 Answer
1

You should upgrade to MySQL 5.0 and then 5.1. Before you upgrade you should backup your database and test it on the new MySQL version on a VM or another Machine before committing to the new version completely.

As much as I'd like to upgrade the database server, I don't own it sadly. I just connect to it with SELECT privileges only. I made a compromise and installed MySQL Connector/NET 5 instead. It works with MySQL 4, but doesnt support nice stuff in Visual Studio such as being available for use in SQLDataSource control.
–
user59623Jan 12 '11 at 1:15