Problems with MySQL on Linux (Linux Newbie)

2003-09-23 Thread Donald Tyler
Hi, I am just learning to use Linux and I am having some problems with getting MySQL to load. I have successfully installed & tested both Apache & PHP, so I am pretty comfortable with the whole configure and make processes. I followed the MySQL installation docs to the letter, however w

RE: [PHP] Lost Connection to MySQL server during query

2003-09-09 Thread Donald Tyler
I am using mysql_connect. But I just changed it to mysql_pconnect and it did exactly the same thing. -Original Message- From: Marek Kilimajer [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 09, 2003 10:48 AM To: Donald Tyler Cc: [EMAIL PROTECTED] Subject: Re: [PHP] Lost Connection to

Lost Connection to MySQL server during query

2003-09-09 Thread Donald Tyler
I have a script that is processing data from a single table and splitting it into smaller normalized tables. The script takes anywhere between 5-10 minutes to complete, and as it runs it constantly outputs a report on its progress. The script seems to run fine the first time I run it, but w

FW: mysql LOAD DATA INFILE

2003-08-14 Thread Donald Tyler
iday, August 08, 2003 3:24 PM To: Donald Tyler; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: mysql LOAD DATA INFILE Ah. No wonder it dinna work. Neither did specifying the columns as Jay suggested. I also have no choice but to do it through the browser - I don't have command line

FW: mysql LOAD DATA INFILE

2003-08-14 Thread Donald Tyler
. -Original Message- From: Mike At Spy [mailto:[EMAIL PROTECTED] Sent: Friday, August 08, 2003 2:59 PM To: Donald Tyler; [EMAIL PROTECTED] Subject: RE: mysql LOAD DATA INFILE Sorry, that is the error - my mistake. I am getting this: LOAD DATA LOCAL INFILE '/tmp/php9GOwvw'

FW: Can MySQL 4.0.14 store HTML? Among other things....

2003-08-14 Thread Donald Tyler
Yes it can. But you should understand the three distinct levels of that situation. You need the following: Database Web Server Server-Side Scripting Language I would suggest using AMP (Apache, MySQL & PHP). If you want to know more about how these work in conjunction I would suggest the excelle

RE: mysql LOAD DATA INFILE

2003-08-08 Thread Donald Tyler
Oh and just a note. This solution won't work if you are uploading the file to the server through the browser. You will need to put the file on the server and adjust the commands PATH accordingly. -Original Message- From: Donald Tyler [mailto:[EMAIL PROTECTED] Sent: Friday, Augu

RE: mysql LOAD DATA INFILE

2003-08-08 Thread Donald Tyler
PHPMyAdmin uses the "LOAD DATA LOCAL INFILE" command. Just remove the word LOCAL and it should work fine. -Original Message- From: Mike At Spy [mailto:[EMAIL PROTECTED] Sent: Friday, August 08, 2003 2:35 PM To: [EMAIL PROTECTED] Subject: mysql LOAD DATA INFILE When I come across this er

Advice wanted on Data Structure

2003-07-30 Thread Donald Tyler
I have a question that I hope I can explain well enough: I am trying to figure out a data structure for an inventory system. The system contains: Items Kits(Made from a collection of Items and/or other Kits) Now my question is: Is there any way to structure this in a databas