Topic: MySQL backups..!

[Brandon Friedman]

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

[Charlie Brady]

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

[Darrell May]

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

[Charlie Brady]

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

[Darrell May]

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

[Brandon Freidman]

>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