Thanks Brent, Yes, I too can import with LOAD DATA and mysqlimport, but the thing that's irritating is that I have to create the tables first in order to import the data in either case.
With a 'regular' import from a dumped table, mysql should be able to read the SQL statements within the dump file to create the table(s) AND then populate them with the data. Job done in one hit! I'd appreciate if you could try this on your system and let me know how you get on! > I've successfully imported a very small dataset (about 10k records) into > MySQL under OSX. I'm just getting started in MySQL, so I'm afraid I don't > have much to offer except to say it can be done. > > I'm not sure what syntax you are using in your example. All examples I've > seen use the LOAD DATA ... INFILE ... INTO TABLE ... command to get a text > file into a database. The alternative is to use the mysqlimport utility if > everything that is needed is contained in the text file. > > Perhaps that points you in the right direction??? --------------------------------------------------------------------- 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
