The suggestion below which is essentially to run "update_mysql_tables"
manually instead of within the
"apt-get install bacula-mysql"
runs into the same issue. Specifically
Update of Bacula MySQL tables from 16 to 1017 succeeded.
Update of Bacula MySQL tables from 1017 to 1018 succeeded.
Update of Bacula MySQL tables 1018 to 1019 succeeded. (From 16)
Update of Bacula MySQL tables 1019 to 1020 succeeded.
Update of Bacula MySQL tables 1020 to 1021 succeeded.
ERROR 1050 (42S01) at line 3: Table 'TagJob' already exists
Update of Bacula MySQL tables 1021 to 1022 failed.
I also tried deleting TagJob and starting again, and then it just moves
on to the next table that already exists. In fact I deleted all the Tag*
tables, and that it complains about the Object table. I suspect it won't
like any.
Any ideas?
On 7/4/23 19:48, Ken Mandelberg wrote:
> Another followup. One thing I learned, I need to remove all the Ubuntu
> bundled bacula 9 packages before doing? the apt-get install bacula-mysql
> for the Community 13 release, otherwise there are package conflicts.
>
> So after removing the old packages, apt-get install bacula-mysql tires
> to install the mysql bacula database. It gets caught at
>
> mysql said: ERROR 1050 (42S01) at line 9: Table 'TagJob' already exists
>
> I imagine if I removed that table it would just get caught at the
next one.
>
> Its not really clear on how to proceed preserving the current database 9
> info and letting 13 do the update job.
OK, try this.
- DUMP the bacula schema using mysqldump or your database dump tool of
choice. (Personally I prefer mydumper.)
- Then DROP the bacula DB.
- Then run apt-get install bacula-mysql.
- You MIGHT need to drop the bacula schema *again* at this point. to be
safe.
- Then RESTORE the bacula schema from your dump.
- Then run update_mysql_tables to update your v9 Bacula DB to v13.
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
