On Fri, Oct 24, 2014 at 2:25 PM, Moorcroft, Mark (ARC-TS)[ERC, Inc.]
<[email protected]> wrote:
>
> All of my systems are 64 bit CentOS, and all have /var/log/lastlog.
Mine 'have' /var/log/lastlog. Just not the problem with TB+ apparent
sizes. Do you have a uid of -1 - or very, very large uids?
> With
> various pressure from both the private sector and government demanding
> some kind of log archiving, I thought some kind of FAQ or note could save
> countless man hours for people trying to use BackupPC.
Yes, it would be good FAQ material, but not entirely unique to
backuppc. There aren't many good ways to copy huge sparse files.
> I had to go all the way back to 2007
> to find discussion about lastlog.
Maybe that was when everyone else took the -1 uid out...
> As far as database
> files, for some reason those have not killed rsync the way lastlog seems
> to.
They generally aren't sparse with an apparent size in the TB's. But
if the DB is running concurrently with the backup, a restore won't be
consistent.
>. I have not decided on
> the best way to handle mysql with BackupPC yet.
The straightforward approach is to have script on the host that runs
the mysqldump command so you can use a DumpPreUserCmd like:
$sshPath -q -x -l root $host /path/to/script.
and then back up the dump output instead of the live database. Or if
downtime is OK you can stop the database, then copy its files.
--
Les Mikesell
[email protected]
------------------------------------------------------------------------------
_______________________________________________
BackupPC-users mailing list
[email protected]
List: https://lists.sourceforge.net/lists/listinfo/backuppc-users
Wiki: http://backuppc.wiki.sourceforge.net
Project: http://backuppc.sourceforge.net/
