Koozali.org: home of the SME Server

Contribs.org Forums => General Discussion => Topic started by: toothandnail on November 17, 2011, 09:53:42 PM

Title: Selective restore of a MySQL database dump file
Post by: toothandnail on November 17, 2011, 09:53:42 PM

I've done some searching and haven't managed to find an answer. Maybe I'm not using the right search terms.

I use Synbak (http://www.initzero.it/products/opensource/synbak/) to back up a number of SME servers. Works well - I've done several complete restores from the backups made that way. I have recently hit a problem backing up and restoring eGroupware. The inbuilt backup works, but is pretty untidy. Other than delving into bash date handling, I can't see any easy way to limit the number of generations of backup that are stored.

However, I have a dump of the eGroupware database in my Synbak backups, which are done on a daily basis, and which I have good control over the number of generations saved.

So, my question is, is there any way of selectively restoring the /home/e-smith/db/mysql/egroupware.dump? If I can do that, I can turn of the internal eGroupware backup and tidy up my backup routines quite a bit.

Paul.

Title: Re: Selective restore of a MySQL database dump file
Post by: CharlieBrady on November 18, 2011, 07:21:51 AM

Quote from: toothandnail on November 17, 2011, 09:53:42 PM

So, my question is, is there any way of selectively restoring the /home/e-smith/db/mysql/egroupware.dump?

I think this will do it:

ln -s  /home/e-smith/db/mysql/egroupware.dump /etc/e-smith/sql/init/egw.sql
/etc/rc.d/init.d/mysql.init start

Or you could just do:

mysql <  /home/e-smith/db/mysql/egroupware.dump