RE: RE: Converting text files to MySQL
When I do a search on my entire machine, the only 4 cnf files it finds are those four samples. Where should the file be? I installed and started MySQL myself but I did it under an administrator account. I'm now running under my own account...would this make a difference? -Original Message- From: Gurhan Ozen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 07, 2002 2:56 PM To: Christy Roberts; [EMAIL PROTECTED] Subject: RE: RE: Converting text files to MySQL are you sure you don't have a my.cnf file in /etc dir? Who has installed, started MySQL server? If no default files are given, mysqld will read options from /etc/my.cnf . Gurhan -Original Message- From: Christy Roberts [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 07, 2002 1:00 PM To: 'Gurhan Ozen'; [EMAIL PROTECTED] Subject: RE: RE: Converting text files to MySQL Thanks, Gurhan. I don't seem to have a my.cnf - the only cnf files I have are the four samples - so can I just use one of the sample ones, change the name, and add the local-infile =1 line? -Original Message- From: Gurhan Ozen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 07, 2002 12:58 PM To: Christy Roberts; [EMAIL PROTECTED] Subject: RE: RE: Converting text files to MySQL Christy, You need to edit the defaults file for your MySQL server. It is by default, /etc/my.cnf , unless another one is specified when mysqld is started. The four files that you have mentioned comes with MySQL downloads to be used as an example... See: http://www.mysql.com/doc/O/p/Option_files.html Gurhan -Original Message- From: Christy Roberts [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 07, 2002 11:02 AM To: 'Egor Egorov'; [EMAIL PROTECTED] Subject: RE: RE: Converting text files to MySQL Thanks, Egor. I still can't get it to work though. I added those lines under the [mysqld] and [client] sections - into my four .cnf files, they are my-small.cnf, my-medium.cnf, my-large.cnf, and my-huge.cnf. I dind't have a my.cnf like you mentioned. Is there something else I should be doing? Thanks so much for your help! Egor Egorov wrote: Add in your my.cnf file rows: [mysqld] local-infile=1 [client] local-infile=1 - 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
RE: RE: Converting text files to MySQL
are you sure you don't have a my.cnf file in /etc dir? Who has installed, started MySQL server? If no default files are given, mysqld will read options from /etc/my.cnf . Gurhan -Original Message- From: Christy Roberts [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 07, 2002 1:00 PM To: 'Gurhan Ozen'; [EMAIL PROTECTED] Subject: RE: RE: Converting text files to MySQL Thanks, Gurhan. I don't seem to have a my.cnf - the only cnf files I have are the four samples - so can I just use one of the sample ones, change the name, and add the local-infile =1 line? -Original Message- From: Gurhan Ozen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 07, 2002 12:58 PM To: Christy Roberts; [EMAIL PROTECTED] Subject: RE: RE: Converting text files to MySQL Christy, You need to edit the defaults file for your MySQL server. It is by default, /etc/my.cnf , unless another one is specified when mysqld is started. The four files that you have mentioned comes with MySQL downloads to be used as an example... See: http://www.mysql.com/doc/O/p/Option_files.html Gurhan -Original Message- From: Christy Roberts [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 07, 2002 11:02 AM To: 'Egor Egorov'; [EMAIL PROTECTED] Subject: RE: RE: Converting text files to MySQL Thanks, Egor. I still can't get it to work though. I added those lines under the [mysqld] and [client] sections - into my four .cnf files, they are my-small.cnf, my-medium.cnf, my-large.cnf, and my-huge.cnf. I dind't have a my.cnf like you mentioned. Is there something else I should be doing? Thanks so much for your help! Egor Egorov wrote: Add in your my.cnf file rows: [mysqld] local-infile=1 [client] local-infile=1 - 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
RE: RE: Converting text files to MySQL
Thanks, Gurhan. I don't seem to have a my.cnf - the only cnf files I have are the four samples - so can I just use one of the sample ones, change the name, and add the local-infile =1 line? -Original Message- From: Gurhan Ozen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 07, 2002 12:58 PM To: Christy Roberts; [EMAIL PROTECTED] Subject: RE: RE: Converting text files to MySQL Christy, You need to edit the defaults file for your MySQL server. It is by default, /etc/my.cnf , unless another one is specified when mysqld is started. The four files that you have mentioned comes with MySQL downloads to be used as an example... See: http://www.mysql.com/doc/O/p/Option_files.html Gurhan -Original Message- From: Christy Roberts [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 07, 2002 11:02 AM To: 'Egor Egorov'; [EMAIL PROTECTED] Subject: RE: RE: Converting text files to MySQL Thanks, Egor. I still can't get it to work though. I added those lines under the [mysqld] and [client] sections - into my four .cnf files, they are my-small.cnf, my-medium.cnf, my-large.cnf, and my-huge.cnf. I dind't have a my.cnf like you mentioned. Is there something else I should be doing? Thanks so much for your help! Egor Egorov wrote: Add in your my.cnf file rows: [mysqld] local-infile=1 [client] local-infile=1 - 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
RE: RE: Converting text files to MySQL
Christy, You need to edit the defaults file for your MySQL server. It is by default, /etc/my.cnf , unless another one is specified when mysqld is started. The four files that you have mentioned comes with MySQL downloads to be used as an example... See: http://www.mysql.com/doc/O/p/Option_files.html Gurhan -Original Message- From: Christy Roberts [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 07, 2002 11:02 AM To: 'Egor Egorov'; [EMAIL PROTECTED] Subject: RE: RE: Converting text files to MySQL Thanks, Egor. I still can't get it to work though. I added those lines under the [mysqld] and [client] sections - into my four .cnf files, they are my-small.cnf, my-medium.cnf, my-large.cnf, and my-huge.cnf. I dind't have a my.cnf like you mentioned. Is there something else I should be doing? Thanks so much for your help! Egor Egorov wrote: Add in your my.cnf file rows: [mysqld] local-infile=1 [client] local-infile=1 - 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 - 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
RE: RE: Converting text files to MySQL
Thanks, Egor. I still can't get it to work though. I added those lines under the [mysqld] and [client] sections - into my four .cnf files, they are my-small.cnf, my-medium.cnf, my-large.cnf, and my-huge.cnf. I dind't have a my.cnf like you mentioned. Is there something else I should be doing? Thanks so much for your help! Egor Egorov wrote: Add in your my.cnf file rows: [mysqld] local-infile=1 [client] local-infile=1 - 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
Re: RE: Converting text files to MySQL
Christy, Tuesday, May 07, 2002, 3:07:25 PM, you wrote: CR>> I've been trying to import text files into MySQL, but I can't get it CR> to CR>> work. I'm new to MySQL and am still getting familiar with it, so CR>> perhaps I'm missing something. I'm using the LOAD DATA LOCAL CR> command CR>> but I keep getting error 1148 "The used command is not allowed with CR> this CR>> MySQL version." Now from reading the information in the docs CR> section CR>> (http://www.mysql.com/doc/L/O/LOAD_DATA_LOCAL.html) it appears that CR> LOAD CR>> DATA LOCAL is sometimes disabled for security reasons, and that CR> there CR>> are two ways around this. CR> Christy, give me some more info: CR> 1. What OS are your using? CR> 2. What MySQL server are you using (version, binary or source CR> distribution etc.)? CR> 3. What is your client software? CR> Hi Egor - we're running Windows XP on that machine. We're running MySQL CR> version 3.23.49, binary distribution. Add in your my.cnf file rows: [mysqld] local-infile=1 [client] local-infile=1 CR> I'm not sure what you mean by CR> "client software." Doesn't MySQL include server and client? Sure, MySQL has server and client packages, but in Windows binary they combine into one package. CR> Maybe I'm CR> missing something here. :) :) Seems, you have worked only with Windows ... CR> Thanks, CR> Christy CR> :) -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - 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
RE: Converting text files to MySQL
CR> I've been trying to import text files into MySQL, but I can't get it to CR> work. I'm new to MySQL and am still getting familiar with it, so CR> perhaps I'm missing something. I'm using the LOAD DATA LOCAL command CR> but I keep getting error 1148 "The used command is not allowed with this CR> MySQL version." Now from reading the information in the docs section CR> (http://www.mysql.com/doc/L/O/LOAD_DATA_LOCAL.html) it appears that LOAD CR> DATA LOCAL is sometimes disabled for security reasons, and that there CR> are two ways around this. I've tried both ways but it doesn't seem to CR> work. I tried using the command --enable-local-infile but apparently CR> that's only compatible with version 3.23.48 and before, and we have CR> 3.23.49. Is there something else I should do? Can anyone help me CR> please? Thanks so much! Christy, give me some more info: 1. What OS are your using? 2. What MySQL server are you using (version, binary or source distribution etc.)? 3. What is your client software? Hi Egor - we're running Windows XP on that machine. We're running MySQL version 3.23.49, binary distribution. I'm not sure what you mean by "client software." Doesn't MySQL include server and client? Maybe I'm missing something here. :) Thanks, Christy :) -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - 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 - 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
Re: Converting text files to MySQL
Christy, Monday, May 06, 2002, 8:56:53 PM, you wrote: CR> I've been trying to import text files into MySQL, but I can't get it to CR> work. I'm new to MySQL and am still getting familiar with it, so CR> perhaps I'm missing something. I'm using the LOAD DATA LOCAL command CR> but I keep getting error 1148 "The used command is not allowed with this CR> MySQL version." Now from reading the information in the docs section CR> (http://www.mysql.com/doc/L/O/LOAD_DATA_LOCAL.html) it appears that LOAD CR> DATA LOCAL is sometimes disabled for security reasons, and that there CR> are two ways around this. I've tried both ways but it doesn't seem to CR> work. I tried using the command --enable-local-infile but apparently CR> that's only compatible with version 3.23.48 and before, and we have CR> 3.23.49. Is there something else I should do? Can anyone help me CR> please? Thanks so much! Christy, give me some more info: 1. What OS are your using? 2. What MySQL server are you using (version, binary or source distribution etc.)? 3. What is your client software? CR> Christy Roberts -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - 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
Converting text files to MySQL
I've been trying to import text files into MySQL, but I can't get it to work. I'm new to MySQL and am still getting familiar with it, so perhaps I'm missing something. I'm using the LOAD DATA LOCAL command but I keep getting error 1148 "The used command is not allowed with this MySQL version." Now from reading the information in the docs section (http://www.mysql.com/doc/L/O/LOAD_DATA_LOCAL.html) it appears that LOAD DATA LOCAL is sometimes disabled for security reasons, and that there are two ways around this. I've tried both ways but it doesn't seem to work. I tried using the command --enable-local-infile but apparently that's only compatible with version 3.23.48 and before, and we have 3.23.49. Is there something else I should do? Can anyone help me please? Thanks so much! Christy Roberts Technical Project Lead iMIRADOR.com Inc. St. John's, Newfoundland Tel: 709.737.4485 - 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
