At 5:01 PM -0400 04-04-2000, Margie Wiers wrote:
>Thanks, all, for your help, but I am *still* receiving error messages.
>(Yes, I do have mysql installed right on my C drive. And member.txt is in
>MyDirectory.)
>
>C:\>mysql\bin\mysql mycolors < members.txt;
>File not found
That will only work if mysql\bin\mysql is located under your current
directory. Specify the absolute path:
C:\> \mysql\bin\mysql mycolors < members.txt
And don't put the semicolon at the end of the command. The semicolon
should be at the end of the contents of the file (after your
AUTO_INCREMENT = 100 at the end of your CREATE TABLE statement).
If that doesn't work, what happens if you type just:
C:\> \mysql\bin\mysql
>
>C:\>mysql\bin\mysql mycolors < members.txt;
>File not found
>
>C:\>C:\mysql\bin\mysql mycolors < member.txt;
>File not found
>
>C:\>C:\mysql\bin\mysql < member.txt;
>File not found
>
>C:\>C:\mysql\bin\mysql mycolors < member.txt;
>File not found
>
>C:\>C:\mysql\bin\MyDirectory mycolors < member.txt;
>Bad command or file name
>
>C:\>C:\mysql\bin\MyDirectory\mysql mycolors < member.txt;
>Bad command or file name
>
>So, can anyone see what am I missing?
>
>Tearing my hair out,
>Margie
>
>
>
>
>
>> >_____________________________________
>> >CREATE TABLE member
>> >(
>> > member_id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY
>> > lastname VARCHAR(20) NOT NULL
>> > firstname VARCHAR(20) NOT NULL
>> > email VARCHAR(40) NOT NULL
>> > website VARCHAR(40) NOT NULL
>> > interests TEXT(500) NOT NULL
>> >)
>> > AUTO_INCREMENT = 100
>> >__________________________________________
>>
>> >2) I tried at the prompt
>> >C:\>mysql mycolors < member.txt
>> >
>> >but received
>> >Bad command or file name
>>
>> This means the directory containing the MySQL commands isn't listed in
>> your PATH variable. Either modify PATH to contain that directory, or
>> specify the full pathname to the mysql program. For example, if it's
>> in C:\mysql\bin, this might work:
>>
>> C:\> C:\mysql\bin\mysql mycolors < member.txt
>>
--
Paul DuBois, paul@stripped
