Existing users, log in.  New users, create a free account.  Lost password?

Mac OS X  |  Business / Productivity  |  Database  |  MySQL  |  Importing and Exporting Data?

MySQL

MySQL

Manage an SQL database server.

Version:  5.1.21 Beta

   [ Views: 697 ]

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

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   
System Info:Does anyone do it right for a Mac??

Rate this Troubleshooting Report

Was this Troubleshooting Report helpful? Yes | No

Comments

3 comments |

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


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?

Reply to This

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.

Reply to This

Saturday, September 01 2007 @ 10:46 AM PDT