I'm fairly new to MySQL as well (although, I do have experience with Oracle).
Even though you create a new database doesn't mean that MySQL will automatically start using that database. After all you might want to create 10 or 15 databases all at once (why? I don't know), then start creating tables for the 5th one you created.
So your script needs to do something like:
create database 'Temp'; use 'Temp';
(You need the quotes [or maybe it's the backquotes] if you actually want a mixed case name.)
I'm sure that if I'm off, someone here will correct me.
jeff
At 12:27 -0500 3/2/03, Stephen Tiano wrote:
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". 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
--
Jeff Shapiro, Colorado Springs, CO, USA
At work I *have* to use a Windows machine, at home I *get* to use a Mac.
--------------------------------------------------------------------- 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
