load data local infile

[Pallavi Arun Patil]

hello everybody,
i m using redhat linux 7.2 with & mysql 3.23.49a-max-log with
Apache 1.3.24 .

i have encounter following error for load data local infile when i tried to use an example on mysql site's documentation file :

mysql> use test;
Database changed
mysql> show tables;
+----------------+
| Tables_in_test |
+----------------+
| dept |
| emp |
| person |
| pet |
| shirt |
+----------------+
5 rows in set (0.00 sec)
mysql> desc pet;
+---------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------+-------------+------+-----+---------+-------+
| name | varchar(20) | YES | | NULL | |
| owner | varchar(20) | YES | | NULL | |
| species | varchar(20) | YES | | NULL | |
| sex | char(1) | YES | | NULL | |
| birth | date | YES | | NULL | |
| death | date | YES | | NULL | |
+---------+-------------+------+-----+---------+-------+
6 rows in set (0.00 sec)

mysql> LOAD DATA LOCAL INFILE "pet.txt" INTO TABLE pet;
ERROR 1148: The used command is not allowed with this MySQL version
mysql>

mysql> select version();
+------------------+
| version() |
+------------------+
| 3.23.49a-max-log |
+------------------+
1 row in set (0.00 sec)

how do i go about it..........if i want to load thousands of papers data data in text file?

u'r response R most appreciated.....
pallavi

---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php