Thank-q mas denny, udah bisa masuk. saya baru nyoba. ternyata memang salah memasukkan variable
makasih atas bantuannya yak ... salam, yanu On Thu, 2006-06-08 at 07:48, Denny Zulfikar wrote: > sintaks di mysql nya salah mas... > > seharusnya : > mysql -u root --password=pswd table_ku -e "LOAD DATA INFILE '$file' INTO > TABLE lpc" > > bukan ini : > mysql -u root --password=pswd table_ku -e "LOAD DATA INFILE '$FILES' INTO > TABLE lpc" > > reasonnya sudah saya kirimkan japri ke email mas yanu. > > salam, > denny. > > > #------------ > > FILES="/mnt/serverku/test_out/060530.txt" > > for file in $FILES > > do > > mysql -u root --password=pswd table_ku -e "LOAD DATA INFILE '$FILES' INTO > > TABLE lpc" > > done > > #---------- > > > > tapi kalo coba pake : > > FILES=`ls /mnt/serverku/test_out/060530.txt` > > > > hasilnya, for udah bisa jalan, tapi muncul ERROR ginian: > > > > # sh coba.sh > > ERROR 13 at line 1: Can't get stat of '%s' (Errcode: 36) > > ERROR 13 at line 1: Can't get stat of '%s' (Errcode: 36) > > ERROR 13 at line 1: Can't get stat of '%s' (Errcode: 36) > > ERROR 13 at line 1: Can't get stat of '%s' (Errcode: 36) > > dst > > > > > > atas bantuannya, makasih bangett > > > > > > salam, > > yanu > -- FAQ milis di http://wiki.linux.or.id/FAQ_milis_tanya-jawab Unsubscribe: kirim email ke [EMAIL PROTECTED] Arsip dan info milis selengkapnya di http://linux.or.id/milis