Thankyou very much it worked!!!
On Thursday, 20 May 2021, 15:47:39 BST, Phil Stracchino <[email protected]> wrote: On 5/20/21 10:20 AM, Bill Damage via Bacula-users wrote: > Wow, sounds just what I need, thanks. > But, I'm a newbie. Could you post the full script please, if its not too long > for here. > > If not, how to apply the patch. Im not lazy, I did rename the orig and try > > [root@tiger bacula]# patch --dry-run < update.patch > checking file update_mysql_tables.orig > patch: **** malformed patch at line 4: ALTER TABLE RestoreObject > > So have to ask for your kindness once more.! You know, actually, what you can do is the following: Go to line 216 of the update_mysql_tables script and look for these two lines: DROP INDEX JobId on File; DROP INDEX JobId_2 on File; ... And just DELETE THEM. They are pointless. They're just dropping indexes from a table that we're about to drop anyway. Then if you want to be really safe, insert the following line: TRUNCATE TABLE file_temp; in between the end of the CREATE TABLE file_temp statement and the INSERT INTO file_temp statement. -- Phil Stracchino Babylon Communications [email protected] [email protected] Landline: +1.603.293.8485 Mobile: +1.603.998.6958 _______________________________________________ Bacula-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/bacula-users _______________________________________________ Bacula-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/bacula-users
