Re: [BackupPC-users] mysql files

Rob Morin wrote:

Nils Breunese (Lemonbit) wrote:

Op 11 apr 2008, om 14:27 heeft Rob Morin het volgende geschreven:

Is it possible that backuppc can mulch mysql files while doing a  
backup?

Should i be excluding mysql files from the backup, mind i do night
mysqldumps anyways...

Any suggestions?

See the example here: http://backuppc.sourceforge.net/faq/BackupPC.html#item__conf_dumppreusercmd_

Nils Breunese.

-------------------------------------------------------------------------
This SF.net email is sponsored by the 2008 JavaOne(SM) Conference 
Don't miss this year's exciting event. There's still time to save $100. 
Use priority code J8TL2D2. 
http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
_______________________________________________
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/

Thanks for that link, but i wanted to know if it is possible that just 
backuppc performing the backup of mysql files, if that can cause an 
issue with teh files while the server is running, IE like corrupting  
.myd files or stuff like that?

Thanks...

Rob Morin
Dido Internet Inc.
Montreal,Canada
http://www.dido.ca
514-990-4444





-------------------------------------------------------------------------
This SF.net email is sponsored by the 2008 JavaOne(SM) Conference 
Don't miss this year's exciting event. There's still time to save $100. 
Use priority code J8TL2D2. 
http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
_______________________________________________
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/

Rob,

Since you are just creating a copy of the files and not writing to them you should be safe in terms of corrupting the live files. However, you have no guaranty on the integrity of the database files; meaning that the server may be in the middle of a transaction or commit and the files will not contain complete records. This can cause you problems such as a loss of a database, table or missing rows upon restoration of the backup from BackupPC.

In short: it's possible, but not recommended.

Thanks,

Ronnie Gilkey
ronnie AT puryear-it DOT com

--
Puryear Information Technology, LLC
Baton Rouge, LA * 225-706-8414
http://www.puryear-it.com

Visit http://www.puryear-it.com/publications.htm to download your free
copies of:

"Best Practices for Managing Linux and UNIX Servers"
"Spam Fighting and Email Security in the 21st Century"

-------------------------------------------------------------------------
This SF.net email is sponsored by the 2008 JavaOne(SM) Conference 
Don't miss this year's exciting event. There's still time to save $100. 
Use priority code J8TL2D2. 
http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone

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