On Thursday 2021-12-23 13:04:13 Phil Stracchino wrote: > On 12/23/21 11:19, Graham Dicker wrote: > > Thank you for your reply Graham. > > > > I don't think Bacula itself has any problems, it is only the script > > mysqldump that has a problem. The script is just supposed to create a > > dump of the database and (if it is successful) then Bacula goes on to > > first back it up and then delete it. > > I'm gonna be very blunt here. mysqldump is a piece of obsolete garbage > and nobody should be using it any more. It CANNOT, period, CORRECTLY > back up both My ISAM and InnoDB tables in the same dump. CANNOT. > (Nobody should be using the MyISAM storage engine any more either, but > that's another issue.) > > Take a look at mydumper instead. It is better than mysqldump in almost > every imaginable way. It is parallelized, storage engine aware, and > immensely easier to do partial restores with (i.e a single schema or a > handful of tables). It is what mysqldump SHOULD have evolved into > fifteen years ago.
I would suggest XtraBackup in case of MySQL Percona and Mariabackup in case of MariaDB 10.1 and newer. The tool is supported by the Percona and MariaDB software distribution. It produces no downtime and supports incremental backups. Regards! -- Josip Deanovic _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
