I'm doing all kinds of exercises and tutorials to get up to speed on MySQL
on my PowerBook with OS X.2 running. I just tried an exercise that, for the
first time, had me creating a table not right in the MySQL monitor, but,
rather, via a script that I saved as a textfile--Temp.sql--and then call
Hy Steve,
bin/mysql -p bin/mysql -p /[the complete pathname, honest]/Temp.sql
try the following command :
bin/mysql -p /[the complete pathname, honest]/Temp.sql
HTH
Oliver
-
Before posting, please check:
Oliver,
Thanks for responding. Foolish of me to be in such a rush that I wasn't
watching what I was copying and pasting. I actually did use the command
you suggest below. And that's what drew the error message.
So I'm back to the drawing board.
Take care, and thanks again--
Steve
Hy Steve,
At 8:53 -0500 3/2/03, [EMAIL PROTECTED] wrote:
I'm doing all kinds of exercises and tutorials to get up to speed on MySQL
on my PowerBook with OS X.2 running. I just tried an exercise that, for the
first time, had me creating a table not right in the MySQL monitor, but,
rather, via a script that I
Paul,
Thanks very much for responding.
I tried what you suggested, but got:
ERROR 1102: Incorrect database name '/Users/stephent/Sites/Temp.sql'
I don't get this. What wrong database name? The script is supposed to
create the database and a table in it. What an I too dense to see?
Thanks
Hy Steve,
USE DATABASE Temp;
try to change this into :
USE Temp;
and try it again, this should work.
HTH
Oliver
for the filter : sql,query,queries,smallint
-
Before posting, please check:
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
Guys, Guys--
I got it! I stopped being a dimwit long enough to realize that the
change to USE Temp; below was for INSIDE the script.
When I made that change and again went to a new shell and typed
(actually, I dragged the file from the window in which it sat in the
Finder into the Terminal
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
At 12:25 -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
10 matches
Mail list logo