Hello,
I am newbie to MySQL and I having some problems transferring my existing data to MySQL. Could someone tell me what I am doing wrong?

I started by exporting certain fields from Filemaker 5.5 to a comma-separated .txt file. I then opened the file in BBedit, deleted duplicates and made other adjustments (like sorting the output properly) and then saved the file (with unix line breaks).

I then opened a Terminal on a my Mac running OS 10.2.1 and issued the following command:

mysqlimport -v omomain /Users/paul/Desktop/omostuff/csv_files/aproducer.txt

This is what I got in return:

Connecting to localhost
Selecting database omomain
Loading data from SERVER file: /Users/paul/Desktop/omostuff/csv_files/aproducer.txt into aproducer
mysqlimport: Error: Can't get stat of '/Users/paul/Desktop/omostuff/csv_files/aproducer.txt' (Errcode: 13), when using table: aproducer

I have tried other permutations that I have found at listsearch.com and at mysql.com and but I keep encountering the "Error: Can't get stat of '/Users/paul/Desktop/omostuff/csv_files/aproducer.txt' (Errcode: 13), when using table: aproducer"

The table exists, the database exists, and the spelling is correct so I am stumped.

All files, servers and the Terminal are on the same machine. (nothing is remote)
The version of MySQL I am running is: 3.23.46

Any help is greatly appreciated!

Thanks,
Paul Melia


---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to