Hi,
one of my disks crashed and now i need to recover a mysqldump of the
bareos table (catalog). When i try that i get the following error:
ERROR 1071 (42000) at line 115331: Specified key was too long; max key
length is 255 bytes
It looks like this is the result of an update to mysql 5.7 (see also
https://bugs.bareos.org/view.php?id=705)
My system config:
Ubuntu 16.04
bareos 15.2.2-37.1
The dumpfile is about 112 GB (!) in size. It is a secondary catalog,
i.e. i have two catalogs integrated in my bareos-dir.conf file, my
current catalog works with postgresql. But i still need to have the old
mysql catalog at hand.
I see that this bug has been fixed in bareos 17.2.4. But how do i
recover existing mysqldumps from older bareos/mysql versions? Is there a
script available to fix the dump file? Or should i try to recover the
dump in an older version of mysql first?
Best,
Kai
--
You received this message because you are subscribed to the Google Groups
"bareos-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/bareos-users/ec8927f5-7196-4a93-29fa-154249ddd09f%40bbaw.de.
For more options, visit https://groups.google.com/d/optout.
