Re: Filling database with load data

2005-05-31 Thread lists . mysql-users
Hallo Peter,

Op 30 May 05 schreef Peter aan [EMAIL PROTECTED]:

 P http://dev.mysql.com/doc/mysql/en/load-data-local.html

 P #

 P If LOAD DATA LOCAL INFILE is disabled, either in the server or the
 P client, a client that attempts to issue such a statement receives the
 P following error message:

 P ERROR 1148: The used command is not allowed with this MySQL version

 P   I hope this help.

I sure does, thank you very much. And that information was even in the
tutorial part of the manual. I'm ashamed of myself :(

Groetjes,

   Hans.

--- GoldED+/LNX 1.1.5/040412
 * Origin: The Wizard is using MBSE/Linux (2:280/1018)

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Filling database with load data

2005-05-30 Thread lists . mysql-users
Hallo,

I'm using MySQL 4.0.23a as found in the SlackWare 10.1 distribution.
As I'm totally new to MySQL I tried tom follow the tutorial from the
manual. When I tried to fill the data base using a text file with the
command
load data local infile '~/temp' into table huisdier;
I got
ERROR 1148: The used command is not allowed with this MySQL version
What's going wrong?
The insert command works without problem.

Groetjes,

   Hans.

--- GoldED+/LNX 1.1.5/040412
 * Origin: The Wizard is using MBSE/Linux (2:280/1018)

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: Filling database with load data

2005-05-30 Thread Peter

http://dev.mysql.com/doc/mysql/en/load-data-local.html

#

If LOAD DATA LOCAL INFILE is disabled, either in the server or the 
client, a client that attempts to issue such a statement receives the 
following error message:


ERROR 1148: The used command is not allowed with this MySQL version

 I hope this help.

Peter

[EMAIL PROTECTED] wrote:

Hallo,

I'm using MySQL 4.0.23a as found in the SlackWare 10.1 distribution.
As I'm totally new to MySQL I tried tom follow the tutorial from the
manual. When I tried to fill the data base using a text file with the
command
load data local infile '~/temp' into table huisdier;
I got
ERROR 1148: The used command is not allowed with this MySQL version
What's going wrong?
The insert command works without problem.

Groetjes,

   Hans.

--- GoldED+/LNX 1.1.5/040412
 * Origin: The Wizard is using MBSE/Linux (2:280/1018)



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]