>> I get the following error message "ibdata1: md4 doesn't match: will >> retry in phase 1; file removed" for this file in my Xfer Log. Its file >> size is about 50GB and it could be that the file is modified while the >> backup is running. My version of BackupPC is a Ubuntu package which says >> 3.0.0-2 (is this the final version or beta2 ?). > >>> My BackupPC Version is "Version 3.0.0, released 28 Jan 2007". If the >> backuped file is changing is it not possible to back it up? > > The file you are referring to, "ibdata1", is an InnoDB database for > MySQL. If you wanted to back up a MySQL database, running a backup of > live data is absolutely not the proper way of doing it, precisely > because the information changes all the time and you will _never_ have > a proper backup of it that can be restored to a good state. The better > way to back up a MySQL database is described here: > > http://dev.mysql.com/tech-resources/articles/recovering-from-crashes.html > (take a look at the the Backup Policy section). > > Cheers, > > -j > > yes I know. I'm making also DB Dumps of the Database. But I will have also a binary backup, too. Without stopping the database or lock tables. I know that the database could be inconsistent then.
------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ BackupPC-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/backuppc-users http://backuppc.sourceforge.net/
