MySQL - 5.1.21 Beta

I'm a bit flumoxed by this interface. I cannot find a way to upload or import data to an online database. I have used YourSql, CocoaMySql, demoed Aqua Data Studio, bought SQL Boss Developer, and I cannot find a reliable program to do this necessary feature. YourSql has the nicest or easiest interface, but it fails often on uploads and introduces errors. It cannot upload all types of files {xls, csv & txt}, Cocoa is very limited in what it will upload, and I also find it failing often. Both have said number of columns do not match to the table when they clearly do. Yet there isn't enough flexibility to overcome the problem of auto indexed primary key fields... That appears to be where they choke. SQL Boss has been a better program in that regard, but crashes continuously and i don't think it is supported any more. AquaData Studio's interface is obtuse and fails to maintain connections between windows and table data... I tried dbSuite, but their site is down and it will not let me demo the Manager Pro version, because I tried the non pro version first. Other programs I see recommended here seem to be for managing data locally only....

I could write insert commands long hand, but I don't want to waste time and I barely need a program to help if I could do that well.
I checked the manual, but can't find a way to upload files from this program. Maybe I'm missing it. But I'll take some good recommendations for shareware to moderately priced programs that work and do it all.

Thanks
Jeff

If you have the DarwinPorts package manager, you can issue this command:

sudo port install mysql5

Downloads from http://dev.mysql.com/downloads/mysql/4.1.html allow you to download for 10.2 or 10.3, and provide md5 checksums. The checksum on the file linked here indicates it is for 10.2.

Everything went fine with the update this time (had to fix a couple things after updating to 4.1.10).

One thing to note is that you must move your databases to the 'data' directory in the new MySQL dir. Notice that MySQL lives in /usr/local/mysql, but that this is just a symlink to your current install dir. When you update, you get a new data directory, and "/usr/local/mysql" gets pointed at your new directory. (Personally I think this is a good thing, as it means all you have to do is change that one symlink (point it back at the old dir) to revert to the previous version if you have any trouble.)

So if you've updated from, say, 4.1.10 to 4.1.11, you will now have both of these dirs:
/usr/local/mysql-standard-4.1.10-apple-darwin7.7.0-powerpc
/usr/local/mysql-standard-4.1.11-apple-darwin6.8-powerpc

Each of these has a 'data' directory in it, and you must move any databases from your old 'data' dir to the new one (make sure you include the 'mysql' database, as that's where all your permissions are). Stop the MySQL server first, then start it back up after you've moved the data.

The MySQL System Preferences pane still incorrectly says the server is "running" when you first start it up (even though the icon has the red square indicating that it's not)...so trust the icon, not the text. Better yet, do a "ps x | grep mysql" and find out for sure.

This 'popular' DB has some serious licensing issues... if you use it for commercial gain, you will have to pay. If you truly want a free DB, take a look at the arguably better DB of PostgreSQL.

Just a helpful tip...