You should save mysql databases this way. The best way is to use a pre-dump script whcih dump tha database you want. For exemple: mysqldump mysqldump --add-drop-table -A -Q > /home/backup/mysql.sql
This command will dump all the mysql databases and save them as a mysql script in /home/backup. Then you can include this file as a standard file in backuppc configuration Le Wed, 8 Nov 2006 12:49:42 +0200, "Mikael Lammentausta" <[EMAIL PROTECTED]> a écrit : > Backups of the host below (backup_client) works fine for the two > first folders, but not for /var/lib/mysql. I tried to manually rsync > this folder to /tmp/backup as the user backuppc, and it worked. I > wonder why it doesn't when the backupPC daemon does it. Any ideas? > > Ps. mysql is started, and backuppc doesn't and shouldn't have rights > to shut it down. > > The Xfer error log: > > Running: /usr/bin/ssh -q -x -l backuppc > backup_client /usr/bin/sudo /usr/bin/rsync --server --sender > --numeric-ids --perms --owner --group --devices --links --times > --block-size=2048 --recursive . /etc/ Xfer PIDs are now 12914 Got > remote protocol 29 Xfer PIDs are now 12914,12917 [ skipped 199 lines ] > Done: 0 files, 0 bytes > Running: /usr/bin/ssh -q -x -l backuppc > backup_client /usr/bin/sudo /usr/bin/rsync --server --sender > --numeric-ids --perms --owner --group --devices --links --times > --block-size=2048 --recursive . /var/www/ Xfer PIDs are now 12918 Got > remote protocol 29 Xfer PIDs are now 12918,12925 [ skipped 199251 > lines ] Done: 23 files, 38187 bytes > Running: /usr/bin/ssh -q -x -l backuppc > backup_client /usr/bin/sudo /usr/bin/rsync --server --sender > --numeric-ids --perms --owner --group --devices --links --times > --block-size=2048 --recursive . /var/lib/mysql/ Xfer PIDs are now > 13065 Got remote protocol 29 fileListReceive() failed Done: 0 files, > 0 bytes Got fatal error during xfer (fileListReceive failed) > Backup aborted (fileListReceive failed) -- Daniel Berteaud FIREWALL-SERVICES SARL. Société de Services en Logiciels Libres Technopôle Montesquieu 33650 MARTILLAC Tel : 05 56 64 15 32 Fax : 05 56 64 82 05 Mail: [EMAIL PROTECTED] Web : http://www.firewall-services.com ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ BackupPC-users mailing list BackupPC-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/backuppc-users http://backuppc.sourceforge.net/
