At 17:28 -0400 10/19/02, Paul Melia wrote:
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"
% perror 13 Error code 13: Permission denied
This means the server can't read the file. Most likely the permissions you have on it don't allow other users to read it, and the server probably runs as a different user than you. You can either make the file world readable, or use the --local option to have the client send the file to the server over the connection. I'm assuming the server is on the same machine; if it's not, only the --local approach will work.
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
