Yii Framework Forum: Help Import Csv To Mysql - Yii Framework Forum

Jump to content

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

Help Import Csv To Mysql gimana ya gan import data csv ke table mysql Rate Topic: -----

#1 User is offline   alif 

  • Newbie
  • Yii
  • Group: Members
  • Posts: 2
  • Joined: 23-January 10

Posted 16 October 2012 - 10:19 PM

sy pake pclinuxos, XAMPP for Linux 1.7.7

dari postingan2 di http://www.yiiframew...d-data-command/

tak coba lancar sampai proses
$connection->createCommand($sql)->execute();
ada warning dan error seperti dibawah

PDOStatement::execute() [<a href='pdostatement.execute'>pdostatement.execute</a>]: LOAD DATA LOCAL INFILE forbidden


untuk koneksi nya sudah tak tambahi ....
'attributes' => array(PDO::MYSQL_ATTR_LOCAL_INFILE),
.......
PDO hasil cek melalui requirements sudah aktif juga di "PDO MySQL extension, Passed, All DB-related classes, This is required if you are using MySQL database."

tolongin ya gan ......
0

#2 User is offline   xent 

  • Junior Member
  • Pip
  • Yii
  • Group: Members
  • Posts: 97
  • Joined: 14-November 10

Posted 09 November 2012 - 12:19 AM

LOAD DATA LOCAL INFILE forbidden => mungkin permision linux ga ngijinin baca file
coba chmod 755 atao paling ekstrim 777 filenya
xent

My first app: School Information System
Find error? Post here
My Blog
0

Share this topic:


Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users