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
MySQL
Manage an SQL database server.
Version: 5.1.21 Beta
Importing and Exporting Data?
Feedback Type: Troubleshooting Report
Contributed by: Jefferis Peterson Friday, August 31 2007 @ 08:22 AM PDT
Product Platform: MacOSX
Used Product For: 1-6 months
System Info:Does anyone do it right for a Mac??
Comments
Importing and Exporting Data? - Jefferis Peterson
The command line binary in Which "This" package? Is there a prewritten command in Mysql that you just need to modify the file?Saturday, September 01 2007 @ 08:04 AM PDT
Importing and Exporting Data? - 8675309_jane
The MySQL package installer includes all of the command line binaries such as mysql, mysqldump, mysqladmin, etc. By default, they're installed in /usr/local/mysql/bin, which is not in Terminal's default path, so you'll either need to enter the entire path when executing a MySQL command or simply add that path to your search path. You can use the mysql command to import SQL queries from a file or use mysqldump to export a database (or its tables) to an SQL file or straight-to-screen output.Saturday, September 01 2007 @ 10:46 AM PDT
Importing and Exporting Data? - 8675309_jane
Try phpMyAdmin at www.phpmyadmin.net. Or you can always use the mysql command-line binary that's installed by this package.Reply to This
Friday, August 31 2007 @ 07:53 PM PDT