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

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

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

difference command

2004-11-23 Thread TM
Do you know what is differnet between command mysql_connect and mysql_pconnect Thankx -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

character sets error

2001-02-05 Thread TM Safar Tibor Leo
Hi, I work under WinNT with MySQLODBC cilent, and the mySQL server is installed to the linux server. I receive an error message: 'can't initialize character set 21 (path: c:\mysql\\share\charsets)'. I use the hungarian character set, and I try to put in the showed location the hungarian.conf fi

character sets error

2001-02-05 Thread TM Safar Tibor Leo
I work under WinNT with MySQLODBC cilent, and the mySQL server is installed to the linux server. I receive an error message: 'can't initialize character set 21 (path: c:\mysql\\share\charsets)'. I use the hungarian character set, and I try to put in the showed location the hungarian.conf file bu