This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
I try to use the Azure MariaDB. While I want to copy a database from local device to the cloud I get the Message
Restore on mariaDB failed Operation not permitted
log_bin_trust_function_creators = ON I have already set
Hi, @Mark Steinhauer Welcome to the Microsoft Q&A Platform, and thanks for your query.
Can you please share the document/steps you followed or a screenshot of the error message? so I can assist you.
Regards
Geetha
Here the output:
SHOW CREATE TABLE goodcompany_merkl_neu.abwesenheitsgruppen;
/* [Azure] SQL Fehler (1005): Can't create table goodcompany_azure.abwesenheitsgruppen (errno: 1 "Operation not permitted") */
@Mark Steinhauer This doesn't look like an issue with MariaDB, something related to a permissions issue I would recommend raising a support case for deeper investigation.
Regards
Geetha
The solution lies in the table engine used. Aria and myisam is not supported. The tables must be InnoDB. After converting the tables to InnoDB, the database could be migrated to the cloud.