Hello Pallavi, > 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.....
Please review 4.2.4 Security issues with LOAD DATA LOCAL =dn --------------------------------------------------------------------- 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
