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
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
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.
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