MySQLd question ...
Hi all... I need to add (or change) an option when my Mysql daeon starts. Where and how can I do this? Thanks, JIM Jim Hatridge Linux User #88484 -- Our country was colonized by the religious, political, economic, and criminal rejects of every country in the world. We have been carefully breeding insane, obsessive, fanatic lunatics with each other for over 400 years, resulting in the glorious strain of humanity known as "Americans". You have to expect some... peculiarities.
On Wednesday 03 September 2003 16:27, James Hatridge wrote:
I need to add (or change) an option when my Mysql daeon starts. Where and how can I do this?
You could try /etc/my.conf, but it depends on what you want to change. -- Best wishes Kevin Donnelly www.kyfieithu.co.uk - Meddalwedd Rydd yn Gymraeg
Hi Kevin et al... Thanks for the idea, but it did not help at all. What I am trying to do is to get the "Load data local infile" working. To get this working I have to add "-- local-infile=1" as an option to mysqld when I boot the system. My problem is WHERE do I put that !"§$! thing? I've been fiddling with this for the past 2-3 days. I hope that someone from SuSE (or mysql) happens to read this and takes pity on me. <G> Thanks JIM On Wednesday 03 September 2003 20:56, Kevin Donnelly wrote:
On Wednesday 03 September 2003 16:27, James Hatridge wrote:
I need to add (or change) an option when my Mysql daeon starts. Where and how can I do this?
You could try /etc/my.conf, but it depends on what you want to change. --
Best wishes
Kevin Donnelly
www.kyfieithu.co.uk - Meddalwedd Rydd yn Gymraeg
Jim Hatridge Linux User #88484 -- Our country was colonized by the religious, political, economic, and criminal rejects of every country in the world. We have been carefully breeding insane, obsessive, fanatic lunatics with each other for over 400 years, resulting in the glorious strain of humanity known as "Americans". You have to expect some... peculiarities.
On Thursday 04 September 2003 17:53, James Hatridge wrote:
Thanks for the idea, but it did not help at all. What I am trying to do is to get the "Load data local infile" working. To get this working I have to add "-- local-infile=1" as an option to mysqld when I boot the system.
My problem is WHERE do I put that !"§$! thing? I've been fiddling with this for the past 2-3 days.
Strange - I have used just this command in a script on a stock 8.2 install, and it was OK. The line in the PHP script was: $sql=" load data infile '$sales_upd' into table $tmptable fields terminated by ',' enclosed by '\"' ignore 1 lines (dist,code,sagedate,partno,quantity,value,analysis) "; Change the two variables to real names (and amend the column definitions of course), and you should be able to type this directly into phpMyAdmin (or mysql if you use the dash notation) and get a result. IIRC, it did take a few tries with the "fields terminated by ..." to get the right combination, but that is a minor issue. Start working with a representative set of around 20 records, and see what you get. If you make no headway, you'll have to be a bit more specific about your setup, what you've tried, and your data. -- Best wishes Kevin Donnelly www.kyfieithu.co.uk - Meddalwedd Rydd yn Gymraeg
Hi Kevin et al.... OK, I've got a bit more done. I was useing "load data local infile" you are using "load data infile". So I dropped "local" I am now getting this error, any ideas? mysql> load data infile "/home/hatridge/public_html/Datebase/euroUSA1.txt" into table Money_USA; ERROR 13: Can't get stat of '/home/hatridge/public_html/Datebase/euroUSA1.txt' (Errcode: 2) Thanks JIM On Friday 05 September 2003 11:33, Kevin Donnelly wrote:
On Thursday 04 September 2003 17:53, James Hatridge wrote:
Thanks for the idea, but it did not help at all. What I am trying to do is to get the "Load data local infile" working. To get this working I have to add "-- local-infile=1" as an option to mysqld when I boot the system.
My problem is WHERE do I put that !"§$! thing? I've been fiddling with this for the past 2-3 days.
Strange - I have used just this command in a script on a stock 8.2 install, and it was OK.
The line in the PHP script was: $sql=" load data infile '$sales_upd' into table $tmptable fields terminated by ',' enclosed by '\"' ignore 1 lines (dist,code,sagedate,partno,quantity,value,analysis) "; Change the two variables to real names (and amend the column definitions of course), and you should be able to type this directly into phpMyAdmin (or mysql if you use the dash notation) and get a result.
IIRC, it did take a few tries with the "fields terminated by ..." to get the right combination, but that is a minor issue. Start working with a representative set of around 20 records, and see what you get.
If you make no headway, you'll have to be a bit more specific about your setup, what you've tried, and your data.
--
Best wishes
Kevin Donnelly
www.kyfieithu.co.uk - Meddalwedd Rydd yn Gymraeg
Jim Hatridge Linux User #88484 -- Our country was colonized by the religious, political, economic, and criminal rejects of every country in the world. We have been carefully breeding insane, obsessive, fanatic lunatics with each other for over 400 years, resulting in the glorious strain of humanity known as "Americans". You have to expect some... peculiarities.
On Friday 05 September 2003 19:04, James Hatridge wrote:
OK, I've got a bit more done. I was useing "load data local infile" you are using "load data infile". So I dropped "local" I am now getting this error, any ideas?
mysql> load data infile "/home/hatridge/public_html/Datebase/euroUSA1.txt" into table Money_USA; ERROR 13: Can't get stat of '/home/hatridge/public_html/Datebase/euroUSA1.txt' (Errcode: 2)
Permissions on the .txt.file? -- Best wishes Kevin Donnelly www.kyfieithu.co.uk - Meddalwedd Rydd yn Gymraeg
Hi Kevin et al... Ok, I've got it working! The key is to first take out the "local" and then put the files in the same dir as your database. For me that is "var/lib/mysql/WartHog". I had to change the permissions on var to do this. So I'm not totally happy with this, but I can live with it. Now on to the next problem! Thanks JIM On Friday 05 September 2003 22:11, Kevin Donnelly wrote:
On Friday 05 September 2003 19:04, James Hatridge wrote:
OK, I've got a bit more done. I was useing "load data local infile" you are using "load data infile". So I dropped "local" I am now getting this error, any ideas?
mysql> load data infile "/home/hatridge/public_html/Datebase/euroUSA1.txt" into table Money_USA; ERROR 13: Can't get stat of '/home/hatridge/public_html/Datebase/euroUSA1.txt' (Errcode: 2)
Permissions on the .txt.file?
--
Best wishes
Kevin Donnelly
www.kyfieithu.co.uk - Meddalwedd Rydd yn Gymraeg
-- Jim Hatridge Linux User #88484 ------------------------------------------------------ BayerWulf Linux System # 129656 The Recycled Beowulf Project Looking for throw-away or obsolete computers and parts to recycle into a Linux super computer Viel Feind -- Viel Ehr' Anti-US Propaganda stamp collecton http://www.fuzzybunnymilitia.org/~hatridge/collection
On Sunday 07 September 2003 15:21, James Hatridge wrote:
Ok, I've got it working! The key is to first take out the "local" and then put the files in the same dir as your database. For me that is "var/lib/mysql/WartHog". I had to change the permissions on var to do this. So I'm not totally happy with this, but I can live with it. Now on to the next problem!
You should be able to put the files anywhere you want - just give the full path to mysql. -- Best wishes Kevin Donnelly www.kyfieithu.co.uk - Meddalwedd Rydd yn Gymraeg
could you please just say what you want your mysql to do when you start it , so that we can get a good picture of what you want to do exactly. On Wed, 2003-09-03 at 15:27, James Hatridge wrote:
Hi all...
I need to add (or change) an option when my Mysql daeon starts. Where and how can I do this?
Thanks,
JIM
Jim Hatridge Linux User #88484 -- Our country was colonized by the religious, political, economic, and criminal rejects of every country in the world. We have been carefully breeding insane, obsessive, fanatic lunatics with each other for over 400 years, resulting in the glorious strain of humanity known as "Americans". You have to expect some... peculiarities. --
Regards David Ziggy Lubowa Network Engineer One2net ING -------------------------------------------- "Curiosity is a willing, a proud, an eager confession of ignorance." - Leonard Rubenstein
participants (3)
-
David Ziggy Lubowa -
James Hatridge -
Kevin Donnelly