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
