MySQL baza iz komandne linije

Backup

$ mysqldump --add-drop-table --single-transaction -u _root_ -p_password_ koha > 2008-11-11_koha.sql
$ mysqldump --add-drop-table -u _root_ -p_password_ koha issues > 2008-11-11_koha.issues.sql

http://www.nabble.com/Backing-up-3.0-to21076508.html

Restore

$ mysql -u _root_ -p_password_ koha < koha.sql
$ mysql -u _root_ -p_password_ koha.issues < koha.issues.sql

Virtualna mašina

Nakon restora sa zfs-a treba napraviti slijedeća podešavanja:

Pokrenuti screen u kojem će biti virtualna mašina

dpavlin@mlin:~$ screen -S koha-upgrade

Filesystem

lvcreate -s /dev/vg/koha -L 80G -n koha-upgrade

root@mlin:~# mount /dev/vg/koha-upgrade /virtual.clone/koha-upgrade/
root@mlin:~# df /virtual.clone/koha-upgrade/
Filesystem           1K-blocks      Used Available Use% Mounted on
/dev/mapper/vg-koha--upgrade
                      82569904  56551456  26018448  69% /virtual.clone/koha-upgrade

Start LXC

root@mlin:~# cd /srv/sysadmin-cookbook/recepies/lxc/
root@mlin:/srv/sysadmin-cookbook/recepies/lxc# ./ve2lxc.sh /virtual.clone/koha-upgrade/ 10.60.0.253 koha-upgrade

Setup inside LXC

provjeriti IP adrese u /etc/apache2/sites-enabled/
ugasiti monit apt-get remove monit

Koha's virtual LDAP

dpavlin@koha-upgrade:~$ screen -S virtual-ldap

Upgrade na r59 koji ima podršku za novu koha konfiguraciju:

dpavlin@koha-upgrade:/srv/virtual-ldap$ svn update
A    sql
A    sql/organizationalunit.sql
A    sql/group.sql
A    sql/hreduperson.sql
U    lib/LDAP/Virtual.pm
U    lib/LDAP/Koha.pm
Updated to revision 59.

ovaj update traži llin na portu 8022, tako da treba pokrenuti prije njega:

dpavlin@llin:~$ ssh -R 8022:localhost:22 10.60.0.253

Pokrenuti server (inače to radi monit, ali on je deinstaliran da ne gnjavi)

dpavlin@koha-upgrade:~$ cd /srv/virtual-ldap/
dpavlin@koha-upgrade:/srv/virtual-ldap$ ./bin/virtual-ldap.pl 
LDAP server listening on port 1389

Čudan depdendency koji ne bi trebao postojati (kako radi na produkciji?)

koha-upgrade:/srv/virtual-ldap# apt-get install libnet-ldap-server-perl