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
-
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
-
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
-
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
-
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
-
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
-
>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