perfsonar development work

[Maciej Glowiak <>]

Ralf Kleineisel wrote:
> Hi,
>
> Loukik Kudarimoti wrote:
>
> > Can you please increase the backup frequency for our wiki. This will
> > help because the content on our wiki tends to be changed on a daily
> > basis. I suppose a backup frequency as high as once in two-days or even
> > once a day (at midnight) will be helpful for such crashes.
>
> just as an idea: Make the backup using MySQL dumps, not trying to copy
> the database files from the filesystem. The latter will most probably
> corrupt the database if done without a "LOCK TABLES" first.

Hi Ralf,

Backup of DB content was made every day with mysqldump, but due to 
database crash only error message was generated for more than one week. 
Unfortunately I didn't take a look on it during that time.

Now the wiki database is on MySQL 5.0.24 and LOCK TABLES is done 
automatically before each dump.

Maciej

--

 --------------------------------------------------------------------
| Maciej Glowiak        Network Research and Development            ||
| 

     Poznan Supercomputing and Networking Center ||
| (+48 61) 858 2024     http://monstera.man.poznan.pl/              ||
 ====================================================================