https://bugs.documentfoundation.org/show_bug.cgi?id=100839
--- Comment #3 from Basil <[email protected]> ---
SOLUTION!
It appears MariaDB can not handle importing .sql files with both tables and
views.
Dump (from the ORIGINAL DB) tables to one .sql file, and views to another.
Import them separately, Tables first.
If you don't, your data will be there, but none of the constraints or keys.
Without those, the data can be viewed, but not modified (Read-Only).
It took a fair amount of fiddling to figure this out, so I'm reporting it here,
even though it turned out not to be a LO issue after all.
Fortunately, i still had access to the original DB. It would probably be
possible to weed out the offending views with kate/gedit, and transfer them
into their own .sql file, but it might be more effort than was pretty, so I
wouldn't try it unless you've already destroyed the original DB. Even then,
use a COPY.
This is also the solution for #100840.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
