On 2022-09-05 4:21 AM, Uwe Schuerkamp wrote:
bacula=# select encode(VolumeName, 'hex') from media;
encode
----------------------------
7a69662d66756c6c2d30303031
7a69662d696e63722d30303032
7a69662d696e63722d30303033
...
Is the "\xss850938sdkl" you posted before an actual value from your
table? -- It's not hex even though it starts with \x.
You should be able to mysqldump just that one table with some
combination of --compatible and maybe --hex-blob, in a decipherable
form. Then you could load it in psql (after truncating the existing table).
FWIW I use python to move databases. Character encodings is one of the
problems that solves. Creating/checking the table/column mappings
between source and destination is a lot of boring work but IME the
alternatives take even longer and don't work half the time -- as you're
finding out.
Dima
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
