Hi all
I exported the database of my backdrop cms using "Backup-migrate". Everything okay, no error.
Now I import this database to the destination cms, also using the "back-up-migrate" tool. I do not receive any error, everything okay.
Both installations on version 1.30.2 all caches cleared.
When I log in as an admin I have an error in the status report:
Using the link I have this message:
And pushing the button I get the following error message:
I tried to convert the database with a php/SQL script, imported the database in a newly created utf8mb4 format database - it did NOT help.
My questions:
Why is a conversion mandatory? As I understood the formats are downwards compatible - so no reason to convert.
What is the SQL error and where can I fix it?
What is the best solution / work around to get my site up and running?
Many thanks for your help!
Cheers, Rolf
And here the info of the exporting cms:
And the importing CMS:
Comments
I believe the issue relates to a compatibility issue with MariaDB exports:
https://mariadb.org/mariadb-dump-file-compatibility-change/
I don't know if Backup and Migrate addresses this but the command line tool,
bee, does handle this. See the final example under db-import:bee db-import db.sql.gz --mariadb-compatibilityHi
Thanks for the quick answer. Looks interesting and hope I can verify that this solves the issue. Not yet sure how I can use the bee tool in my MAMP environment.
Cheers, Rolf
I think people have used bee in MAMP. I've posted in our chat channel to see if anyone can jump in here and help:
#Backdrop > Bee @ 💬
It is possible to remove that line manually from the SQL file and it should then import to MySQL fine.