Import podataka u mysql

LOAD DATA LOCAL INFILE 'importfile.csv' 
INTO TABLE _test_table_
FIELDS TERMINATED BY ',' 
LINES TERMINATED BY '\n' 
(field1, filed2, field3);

Updated by Marijana Glavica on Oct 13 3:26pm

Posted by Marijana Glavica on Mar 17 1:15pm

permalink

WebPAC2

Korisne bilješke za korištenje WebPAC2 sa Kohom.

Indeksiranje podataka iz Kohe

http://blog.rot13.org/2009/07/sharing_mysql_between_openvz_containers.html

root@koha-hw:~# mount --bind /vz/root/212052/var/run/mysqld/ \
      /vz/root/212056/var/run/mysqld/

dpavlin@webpac2:/srv/webpac2$ export KOHA_USER=kohaadmin
dpavlin@webpac2:/srv/webpac2$ export KOHA_PASSWD=password
dpavlin@webpac2:/srv/webpac2$ ./run.pl --config vhost/koha/config.yml

http://webpac2.rot13.org/webpac2.cgi/koha

Drugi način je korištenje DBD::Gofer DBI_AUTOPROXY='dbi:Gofer:transport=stream;url=ssh:dpavlin@koha.ffzg.hr' ali za to cijeli resultset mora stati u memoriju

Updated by Dobrica Pavlinušić on Jan 29 3:34am

Posted by Dobrica Pavlinušić on Jan 29 3:18am

permalink

Sorting Croatian characters in MySQL

http://forums.mysql.com/read.php?103,192187,192187#msg-192187

http://forge.mysql.com/wiki/How_to_Add_a_Collation

Updated by Marijana Glavica on Dec 9 1:25pm

Posted by Marijana Glavica on Dec 2 5:06pm

permalink