With a similar case I had my problems because the exported database records from Sage KHK, a german biz management software, had " and other special chars in it that made it not possible to run a proper import from a CSV file and manual cleaning with 35.000 records was out of question ;o)
I did the following: exported an Access db from KHK, Opened it in M$ Access, made an ODBC connection to MySQL and exported the tables to the MySQL db. Some lines SQL and I got rid of duplicates, etc. Does Filemaker has the feature to connect to an ODBC source and if yes to export tables there? I have no clue with Mac's. STIBS > 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 > -- --------------------------------------------------------- PLEASE NO HTML EMAILS! THANX ALOT SAYS MY KMAIL CLIENT. --------------------------------------------------------- Best Regards/ Freundliche Grüße Michael Stibane (STIBS) [EMAIL PROTECTED] Training, Linux, Admin, Programming, Web http://www.stibs.cc Escapade Server-Side Scripting Engine Development Team Pensacola - Dallas - Dresden - London http://www.escapade.org +++ GMX - Mail, Messaging & more http://www.gmx.net +++ NEU: Mit GMX ins Internet. Rund um die Uhr für 1 ct/ Min. surfen! --------------------------------------------------------------------- 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
