On Thursday, 23 December 2021 18:04:13 GMT 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.
Thanks for the tip Phil, which I will bear in mind if I ever get Bacula working again as it should (and has done for the past 10 years or more). Up until about a year ago my workstation would boot itself up when woken by the motherboard timer and Bacula would start running as a service and do the necessary backups. The first thing that stopped working was the service. There seemed to be some problem with timing between Bacula and mysql. I got around it by dropping the service and using crontab to start mysql and Bacula in that order. Then a few months ago that started failing due to some disagreement between akonadi, Bacula and mysql as to where the mysql socket was and which port was to be used. I solved that by total surrender to akonadi and told Bacula to use the socket created by akonadi. Now I don't know what's gone wrong. KMail behaviour has also changed in the last few day also; I have to click on it twice to make it start up. I think OpenSuse 15.3 must have had some dodgy updates recently. _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
