Topic: Customizing backup on E-Smith V5.6

[Franco Lee]

Hello,

I was wondering how do you modify what the backup "backs up" via the server-manager backup module.

I know it backs up virtually everything in the /home, parts of /etc, /root.  However, I would like it include certain folders that reside elsewhere (ie. /usr).  How do I set this up as something that is included in the backup and restore?

The reason is that I have installed a content management website package on E-Smith and the mysql database is stored in the /var/lib/mysql directory.  Since this isn't being backed up, a backup and restore of this website is virtually useless.

Your help is greatly appreciated.

flee

[Kevin Tollison]

Purchase the custom backup and rsync panel from dungog.net.  It has a function for backing up MySQL databases with the regular backup.  The best $33 you can spend.

[Franco Lee]

Thanks,

I'll definitely look into that...

Can mysql databases be backed up by just backing up the mysql directory that holds the databases?

flee

[Charlie Brady]

Franco Lee wrote:

> I was wondering how do you modify what the backup "backs up"
> via the server-manager backup module.

You  modify the source code, which is readily available.

> I know it backs up virtually everything in the /home, parts
> of /etc, /root.  However, I would like it include certain
> folders that reside elsewhere (ie. /usr).  How do I set this
> up as something that is included in the backup and restore?
>
> The reason is that I have installed a content management
> website package on E-Smith and the mysql database is stored
> in the /var/lib/mysql directory.

The databases are all dumped into /home/e-smith/db/mysql before backup, and automatically restored from there on restore. Hence what you say here isn't true:

> Since this isn't being
> backed up, a backup and restore of this website is virtually
> useless.

MySQL databases *are* included in the regular backup.

Charlie

[Franco Lee]

I have looked in /home/e-smith/db/mysql and it is empty.  Could the content management software somehow changed the directory it is generally stored in???  Currently the mysql databases are in /var/lib/mysql.

I was able to locate the backup file that is called via the http: server-manager.

/etc/e-smith/web/panels/manager/cgi-bin/backup

I modified the backup to include the desired directories I wish to backup.  I will test the restore and keep you posted...

Thanks for your help so far!!

Flee

[Bob King]

Flee,

Look closely at the backup script. At about line 409 you will see a section beginning with "# Dump the current mysql tables so they are part of the image." This is the routine that dumps the mysql data base for backup purposes. Later in the script you will find the routine that deletes the dump files.

You should be able to verify that the database is being backed up by looking at the backup archive file on your desktop machine.


Hope this helps

[Bjarke Koefoed]

Hi

Maybe this is usefull to some you.

I have created a script that makes a "desktop backup" to a dir on a remote machine.Just edit it to make it fit your needs.

The backup can be restored using the server-manager (restore from desktop.)

I use crontab to run this script every once a week.


You can download the script here: http://www.bk-data.dk/backupdump.zip

[Kelvin]

Franco,

If you are backing up to tape drive, give Shad Lords arkeia backup contrib a try. The Java GUI which can be run from a Windows PC can be used to create custom backup sets (backup or exclude anything you want). It also makes restores a lot easier as well.

You could even modify the /sbin/e-smith/backup script after installing arkeia to customise it to run the backup with your own save pack.

Kelvin

[Klaus Eckert]

where can i download the arkeia-contrib?

cheers klaus

[Bob King]

try here http://lordsfam.net/