ok, i use volume shadow so i dont need to dump.
what does it do for the backup after you have dumped the DB?
does it only take what has changed since the
last dump or does it take the entire dump?

On Fri, Feb 6, 2009 at 10:26 PM,  <mark AT ehle.homelinux DOT org> wrote:
> I make my mysql servers dump their DB's to a file before running BackupPC.
>
> Quoting "Nick Smith" <nick.smith79 AT gmail DOT com>:
>
>> On Fri, Feb 6, 2009 at 9:09 PM, Nick Smith <nick.smith79 AT gmail DOT com> 
>> wrote:
>>> I have a couple clients backup nightly over the internet.
>>> I seem to be doubting if the backups are actually being completed
>>> successfully.
>>> Backuppc tells me they are, but the reason im questioning is because
>>> it is suppose
>>> to backup 10gigs a night (their sql db changes daily) and backup
>>> completes in 40mins
>>> over a max connection of 600kb.  The backup results do say its getting
>>> about 50%
>>> compression and the backup is only 5gigs when it complete.
>>>
>>> How does backuppc handle databases? does it take just whats changed
>>> or if the DB
>>> changes does it have to backup the entire thing again?
>>>
>>> ive gotten 14 complete full backups (one a day) and they all have the
>>> same results
>>> completed successfully and are about 10gigs before compression and pooling.
>>>
>>> its there a way i can make sure that things are working as planned?
>>>
>>> i mean without doing a restore and testing what its backing up.
>>>
>>> i just dont want to think im getting good backups when im really not.
>>>
>>> im using scripts that use volume shadow to get backups of their
>>> windows servers
>>> after hours.
>>>
>>> it just seems like the backups are going way to fast with the speed of
>>> the connection
>>> and the size of the data.
>>>
>>> thanks for any light you can shed on the subject.
>>>
>> and to add to my own post im doing these backups over a pfsense
>> firewall on both sides and the stats for the last 4 hours
>> (when the 10gig backup was supposedly preformed), the output
>> transmitted on the WAN was only 50megs. so something
>> isnt working correctly here.
>>
>> ------------------------------------------------------------------------------
>> Create and Deploy Rich Internet Apps outside the browser with Adobe(R)AIR(TM)
>> software. With Adobe AIR, Ajax developers can use existing skills and code to
>> build responsive, highly engaging applications that combine the
>> power of local
>> resources and data with the reach of the web. Download the Adobe AIR SDK and
>> Ajax docs to start building applications today-http://p.sf.net/sfu/adobe-com
>> _______________________________________________
>> BackupPC-users mailing list
>> BackupPC-users AT lists.sourceforge DOT net
>> List:    https://lists.sourceforge.net/lists/listinfo/backuppc-users
>> Wiki:    http://backuppc.wiki.sourceforge.net
>> Project: http://backuppc.sourceforge.net/
>>
>
>
>
>
> ------------------------------------------------------------------------------
> Create and Deploy Rich Internet Apps outside the browser with Adobe(R)AIR(TM)
> software. With Adobe AIR, Ajax developers can use existing skills and code to
> build responsive, highly engaging applications that combine the power of local
> resources and data with the reach of the web. Download the Adobe AIR SDK and
> Ajax docs to start building applications today-http://p.sf.net/sfu/adobe-com
> _______________________________________________
> BackupPC-users mailing list
> BackupPC-users AT lists.sourceforge DOT net
> List:    https://lists.sourceforge.net/lists/listinfo/backuppc-users
> Wiki:    http://backuppc.wiki.sourceforge.net
> Project: http://backuppc.sourceforge.net/
>

------------------------------------------------------------------------------
Create and Deploy Rich Internet Apps outside the browser with Adobe(R)AIR(TM)
software. With Adobe AIR, Ajax developers can use existing skills and code to
build responsive, highly engaging applications that combine the power of local
resources and data with the reach of the web. Download the Adobe AIR SDK and
Ajax docs to start building applications today-http://p.sf.net/sfu/adobe-com
_______________________________________________
BackupPC-users mailing list
BackupPC-users AT lists.sourceforge DOT net
List:    https://lists.sourceforge.net/lists/listinfo/backuppc-users
Wiki:    http://backuppc.wiki.sourceforge.net
Project: http://backuppc.sourceforge.net/