Paul, Oliver--
I really, really appreciate you guys taking time from your respective Sundays to try and enlighten me. But I'm still getting nowhere fast.
I've gotten it to this:
I open a new shell and type:
/usr/local/bin/mysql --local-infile -u root -p [the full pathname up to]/Temp.sql
at which point it informs me "incorrect database name".
Of course. The first non-option argument, if there is one, is taken as the name of the default database. You need a < character before the filename if you want to redirect the input of the command to read from the file:
/usr/local/bin/mysql --local-infile -u root -p < filename
Well, yes, the script is to create a nonexistent database and then a table called "Temp" in that database.
I'm now officially lost. 'use' would only apply to an existing database.
By the way, I've also tried:
/usr/local/bin/mysql -u root -p [the full pathname up to]/Temp.sql
to no avail.
Soooo frustrating ...
Steve Tiano
--------------------------------------------------------------------- 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
