Wessley Roche wrote:
I'm having a problem with the following code:
$sql = LOAD DATA LOCAL INFILE '/path/to/file.txt' INTO TABLE `mytable`
FIELDS TERMINATED BY '\t' ESCAPED BY '\' LINES TERMINATED BY '\n';
mysql_query($sql) or die('brbr'.mysql_error());
I get this MySQL error:
You have an
You have mysql 4.1.8, but your php was built with the library for an earlier
version, which, as the error message says, doesn't support the new, more
secure authentication protocol. Your choices are to tell mysql to use the
older, less-secure protocol, or build a copy of php using your current
I am still new to the PHP scene could you tell me how I rebuild the
PHP with the client library...
On Mon, 07 Feb 2005 12:20:26 -0500, Michael Stassen
[EMAIL PROTECTED] wrote:
You have mysql 4.1.8, but your php was built with the library for an earlier
version, which, as the error message
The short answer is, download the php source and add
--with-mysql=/your/path/to/mysql
to your build options. The long answer is in the directions in the php
manual http://us4.php.net/manual/en/install.unix.php.
Michael
GH wrote:
I am still new to the PHP scene could you tell me how I rebuild
also try to:
echo mysql_error();
after the select-query, it will tell you what went wrong.
Thomas
On Fri, 17 May 2002 18:45:07 +0100
[EMAIL PROTECTED] (Randum Ian) wrote:
Hi all,
I have got this code but I can get it to work, it doesnt make sense!
snip
?php
$host=localhost;
It would help if you gave us some more information. If you look in your
MySQL folder you will see a folder call include. In that folder there is
file call mysqld_error.h, this a list of some of the errors you will
encounter. This will help you track down the problems you are having, in
the
Maybe you run out of diskspace??
Greets, Leon
Elias wrote:
Table is full?
did you try searching MySql.com for Table is full error message?
Andreas ) [EMAIL PROTECTED] wrote in message
000c01c10b81$c765aa60$8d0a@devel01">news:000c01c10b81$c765aa60$8d0a@devel01...
hi all,
my
Correct, SET must be before WHERE.
Joseph
CollegeSucks.com
-Original Message-
From: Tyler Longren [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 22, 2001 4:04 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP] mysql error, dont see why.. please help
Shouldn't it be:
8 matches
Mail list logo