MySql Limitations??

2006-05-29 Thread Harish TM
hi... I need to store something like a couple of million rows is a MySql table. Is that ok or do I have to split them up. I intend to index each of the columns that I will need to access so as to speed up access. Insertion will be done only when there is very little or no load on the server

Re: MySql Limitations??

2006-05-30 Thread Harish TM
ize is 400MB, so you should not have any problems. Peter On 29/05/06, Chris W <[EMAIL PROTECTED]> wrote: > Harish TM wrote: > hi... > I need to store something like a couple of million rows is a MySql > table. Is that ok or do I have to split them up. I intend to index > e

Re: Problem in using LOAD DATA LOCAL INFILE

2006-05-30 Thread Harish TM
I went through a lot of trouble with Load data local infile... There are a lot of things regarding Local that MySql does not allow due to security reasons. As mentioned before this you could give us the error... that might help alternatively try out mysqlimport http://dev.mysql.com/doc/refman/5.

Re: Problem in using LOAD DATA LOCAL INFILE

2006-05-31 Thread Harish TM
a for all columns getting loaded in first column only and getting > error line now data for other columns > > > Hope you will find the solution > > Cheers.:) > > Neeraj Black Bits > -Original Message- > From: Harish TM [mailto:[EMAIL PROTECTED] > Sent: Tuesd