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
