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