Koozali.org: home of the SME Server

Legacy Forums => Experienced User Forum => Topic started by: Brandon Friedman on February 24, 2001, 03:37:19 PM

Title: MySQL backups..!
Post by: Brandon Friedman on February 24, 2001, 03:37:19 PM
I have been looking for a utility to backup my database file & tables...
Any suggestions?

Where are the Mysql database & table files stored on e-smith?

BF
Title: Re: MySQL backups..!
Post by: Charlie Brady on February 24, 2001, 07:08:18 PM
Brandon Friedman wrote:
>
> I have been looking for a utility to backup my database file
> & tables...
> Any suggestions?

The standard e-smith (4.1) backup to tape backs up all database tables.

> Where are the Mysql database & table files stored on e-smith?

The "live" databases are stored in /var/lib/mysql. The database tables are dumped into /home/e-smith/db before every tape backup job.

Charlie
Title: Re: MySQL backups..!
Post by: Darrell May on February 24, 2001, 10:26:45 PM
Charlie Brady wrote:
>
> Brandon Friedman wrote:
> >
> > I have been looking for a utility to backup my database file
> > & tables...
> > Any suggestions?
>
> The standard e-smith (4.1) backup to tape backs up all
> database tables.
>
> > Where are the Mysql database & table files stored on e-smith?
>
> The "live" databases are stored in /var/lib/mysql. The
> database tables are dumped into /home/e-smith/db before every
> tape backup job.
>
> Charlie

And if you are not using flexbackup you can take the commands found in /sbin/e-smith/backup re mysql and add them to your current backup script.

Regards,

Darrell
Title: Re: MySQL backups..!
Post by: Charlie Brady on February 24, 2001, 10:48:19 PM
Darrell May wrote:

> And if you are not using flexbackup you can take the commands
> found in /sbin/e-smith/backup re mysql and add them to your
> current backup script.

If you want to use a backup program other than flexbackup, you just need to provide the right template fragment and you can still use /sbin/e-smith/backup, and you then get the mysql backup for "free".

Charlie
Title: Re: MySQL backups..!
Post by: Darrell May on February 25, 2001, 02:00:38 AM
Charlie Brady wrote:
> If you want to use a backup program other than flexbackup,
> you just need to provide the right template fragment and you
> can still use /sbin/e-smith/backup, and you then get the
> mysql backup for "free".
>
> Charlie

Thanks Charlie,

You are of course right as usual :-)  So this means you could create a template fragment:

/etc/e-smith/template-custom/sbin/e-smith/backup/30flexbackup

and place your backup command line in 30flexbackup.  Then either do a:

/sbin/e-smith/expand-template /sbin/e-smith/backup

for testing or

/sbin/e-smith/signal-event console-save.

Is this correct?  Is there anything else?  Maybe a db entry although I don't recall the exact syntax?

Regards,

Darrell
Title: Re: MySQL backups..!
Post by: Brandon Freidman on February 25, 2001, 12:13:05 PM
>The "live" databases are stored in /var/lib/mysql.

Live as in they cannot be backed up if in use??? or can they ?
I don't use flexbackup, so I just want to add the files to my daily backup job..... can I just include that subdirectory?

BF