mysqldump --force -ubn_reportserver -pxxxxx bitnami_reportserver > d:\install\report_server_dump_20220110.dmp
]]>pls note we updated the Bitnami stack upgrade guide here: https://reportserver.net/en/tutorials/u … 0-bitnami/ for future upgrades
Regards,
Eduardo
where exactly are you using --force ? can you pls post the complete command?
Regards,
Eduardo
we tried with --force option when exporting. It works fine.
Thank you.
Kind regards, Nikolaj.
]]>in our case, with a fresh 3.7.1 installation, the dump works, so we are not able to reproduce the problem.
Nevertheless, I am asking the Bitnami team, maybe they have some idea why you may be getting this error.
Regards,
Eduardo
we will double-check after a fresh installation if we get this error too.
Regards,
Eduardo
"after installation" and after import of your previously exported reports, or just after a fresh 3.7.1 installation?
Regards,
Eduardo
D:\Bitnami\reportserver-3.7.1.6050-0\mariadb\bin>mysqldump -ubn_reportserver -p6e5ee8d66c bitnami_reportserver > d:\install\report_server_dump_20220110.dmp
mysqldump: Error: 'Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '='' when trying to dump tablespaces
mysqldump: Couldn't execute 'SELECT table_name FROM INFORMATION_SCHEMA.TABLES WHERE table_schema = DATABASE() AND table_name = 'á'': Illegal mix of collations (
utf8_general_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '=' (1267)
ok, pls just keep in mind that the rs export-import functionality is not guaranteed to work for different-version export/import, only for same versions. But as you had a relatively new version (RS3.6.0-6040) and you are installing RS3.7.1, if this works for you, fine
But pls make sure you can dump the data in the new version 3.7.1 so you can upgrade by the upgrade guide in the future.
Regading your issues with Saiku I will take a look at the separate entry.
Regards,
Eduardo
Kind regards, Nikolaj.
]]>"We will load the data from export and try dump again." ->
if you are able to export the complete database of your old installation and import it into the new bitnami installation, that's all you need, as this is what we are doing with a database dump. So if this works by any other backup/restore way, it will do the job instead of a database dump
Pls let us know how this works. Always pls refer to the blog entry for the other steps of the upgrade.
Regards,
Eduardo
We will load the data from export and try dump again.
]]>It looks, the problem is, that tables in different schemas of the bitnami_reportserver database have different table_collation setting. We did not change that manually.
We will try a new installation of latest bitnami stack and check the table_collation settings there.
Kind regards, Nikolaj.
]]>we tested these scenarios:
1. install bitnami 3.6.0 and create a dump -> it works
2. install bitnami 3.1.0, upgrade rs to 3.6.0 and create a dump -> it works
so we cannot reproduce the problem you got.
Did you change anything on your tables manually, or create/change something on your tables? In our test environment it works as described in the blog entry.
Regards,
Eduardo