Thank you very much. I really appreciate your analogy to the waterfall.
This helped me out tremendously. I was able to sort out the problem and
all is now well! It appears that this wonderful little GUI tool the
lets you create ER diagrams that auto-generate CREATE scripts assumes
that you won'
I'm a total newbie to mySQL, but was hoping someone could answer a
question regarding adding a record into a database that has foreign key
constraints. Remember, I'm a total newbie so I'm hoping I'm using the
right words to express this. I'm taking a class that required us to use
an ER diagramm
Michael Gale <[EMAIL PROTECTED]> wrote:
>
>I have a question about data loading using mysql 4.0.20. If you need to load
> let's say 50,000 items into a database.
> Now 50,000 is not a lot for a DB.
>
> So my question is would it be fast to load the file us
infile is a lot faster.
Matthew McNicol
Michael Gale wrote:
Hello,
I have a question about data loading using mysql 4.0.20. If you need to load let's say 50,000 items into a database.
Now 50,000 is not a lot for a DB.
So my question is would it be fast to load the file using the local i
Hello,
I have a question about data loading using mysql 4.0.20. If you need to load
let's say 50,000 items into a database.
Now 50,000 is not a lot for a DB.
So my question is would it be fast to load the file using the local infile which is a
security concern or should I be
us
hi all..
i'm using mysql with php4 to develop an online ordering system.
the problem:
when it comes to save, retrieve/view and update data into mysql database, it
takes a long time for the page to load.
the problem occurs after we insert / key in data ( a lot types of data ), after
we click the
> -Original Message-
> From: Menard, Inc. Information Systems
> Sent: Friday, May 24, 2002 3:44 PM
> I figured it out but I'm a bit confused as to why it happened.
> I'm running the load as user1. The file resides at
> /home/user1/data/filename
> Permissions:
> filename 666
> data 777
> us
o work. If I'm
> logged in as that user, why would I have to do that???
>
> Thanks
> Jake
>
> -Original Message-
> From: Menard, Inc. Information Systems [mailto:[EMAIL PROTECTED]]
> Sent: Friday, May 24, 2002 8:26 AM
> To: Jay Blanchard; [EMAIL PROTECTED]
> Subj
Because mysql needs 'rx' permissions to read and search the directory.
755 should have been sufficient.
Menard, Inc. Information Systems wrote:
>I figured it out but I'm a bit confused as to why it happened.
>I'm running the load as user1. The file resides at /home/user1/data/filename
>Permiss
er, why would I have to do that???
Thanks
Jake
-Original Message-
From: Menard, Inc. Information Systems [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 24, 2002 8:26 AM
To: Jay Blanchard; [EMAIL PROTECTED]
Subject: RE: Newbie--Easy data loading question
yes. I tried all of these methods:
1
t...that would be
the next step, but I prefer not to go there.
-Original Message-
From: Jay Blanchard [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 24, 2002 8:22 AM
To: 'Menard, Inc. Information Systems'; [EMAIL PROTECTED]
Subject: RE: Newbie--Easy data loading question
did
did you supply the /full/path/to/the/file/ ?
-Original Message-
From: Menard, Inc. Information Systems [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 24, 2002 8:15 AM
To: [EMAIL PROTECTED]
Subject: Newbie--Easy data loading question
Hello
Forgive me for being a little naive but.
I
Hello
Forgive me for being a little naive but.
I am trying to load a table with a text file using the load data infile
command in mysql. I can do it if I place the
text file in the db directory, but I want it to reside in a different dir. I
am getting the error 13: Can't get stat on
What
13 matches
Mail list logo