(This message is also relevant for the tikiwiki and pmb live
The database sever mysql (and also postgresql in the case of
PaiPix) have to start with the database files in /var/lib/mysql (...).
Most of the files in /var/lib are set as links in the knoppix boot
process. This is reasonable since it reduces the ramdisk consumption.
However the database servers do not work properly this way.
To make the databases read/write without waisting memory when the
servers are not running, I have modified the init scripts such that,
when they start, if they find links instead of files, they actually
rsync the full databases.
When we perform the disk installation the script still works
normally since it finds the proper databases in /var/lib/mysql and not
links. Any update of this for disk installations is also ok since these
features are no longer required. In the case of PaiPix this action is
also included for the installed packages tikiwiki
(http://www.tikiwiki.org) and the library catalog software pmb
(http://www.pizz.net/) that need some read/write files in /var/lib.
This patches are in attachment. Please consider that, in the mysql case,
the patch applies to the mysql version 4.1 server.
The Debian packages for tikiwiki and pmb are included in PaiPix and
available from our site:
(I will discuss these packages in another email).
All patches are available from one single Debian package:
See also http://aamorimsrv.fis.fc.ul.pt/
All the best,