Re: Can't import dump file OS X
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
Can't import dump file OS X
Hi all, I'm having a problem importing a dump file in Mac OSX. I created the dump from phpMyAdmin, and tried to import it in these 2 ways with the following results: From mysql command line: Mysql database_name dumped_file; Result: ERROR 1064: You have an error in your SQL syntax near 'database_name dumped_file' at line 1 From /usr/local/mysql/bin directory, using shell command line: shell mysql -uuser_name -p database_name dumped_file Result: I am prompted for a password, which I give correctly. When I go into mysql and SHOW TABLES for the database in question, I get Empty set (0.00 sec) FWIW I have successfully imported the same dump file into our production mySQL server - which is running Red Hat Linux. Any help greatly appreciated! Thanks, ollie - 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