On Sun, 21 Nov 2004 02:26:44 -0200, Daniel da Veiga wrote:
>PhpMyAdmin is good, of course, but you see, it really hides a lot of
>details that you'll step on while you're a developer, it would be good
>if you learn the commands (console, SQL) instead of using this kind of
>wizard.
Well, I don't mind learning some commands but it seems like there are
many dozens/hundreds of commands, and variations of commands. A
major undertaking to learn/apply correctly.
If I were 30 years younger your idea might have more appeal, but I am
not. Added to that I ceased doing much command line stuff over ten
years ago.
>Even if your machine isn't the server, you can install the
>client
No idea what "client" you are talking about. Or how to setup/use
it. :-( My system is a win '98 one. My hosting co has, IIRC,
Unix/Apache/MySQL.
>and connect to the database via console.
I am guessing you are meaning some sort of telnet connection from my
windows box ? In any case I haven't used telnet for many years either
and wouldn't know which directories to connect to or execute commands
in.
>The command "grant all
>privileges on *.* to 'jf'" might work...
Ah ! That looks good. If I can work out where/how to apply that
command I will try it.
>To import data, the command
>"load data infile" is a good way.
The "infile" is my .sql or c.s.v. file ? If so I am not sure what the
relative syntax for transfer from my C:\ drive to the server's C:\
drive is. I guess I would get the IP address' of both and use
them somehow ?
Somewhat more complex than copy C:\something to D:\ It is
a pity everything Unix is so tedious/complex. :-(
>Best regards,
< snip >
Thanks Daniel. It sure is nice to see some competent people here
willing to help those of us who are newbies in regard to SQL/Unix.
Regards, John.
