DB import error

Question

Hi, I created a MariaDB server and I am able to connect it using commandline. I created a database and few empty tables from mysql cli without any issues. I am unable to import a database dump in the server. I get below error, root@Serdf2 [~]# mysql -h servicename.mariadb.database.azure.com -P 3306 -u user@servicename -p wp_db102 < /root/db.sql Enter password: ERROR 1005 (HY000) at line 25: Can't create table wp_db102.wp_actionscheduler_actions (errno: 1 "Operation not permitted") I referred this article for the steps, https://learn.microsoft.com/en-us/azure/mysql/concepts-migrate-dump-restore Thanks,

Answer 1

Hi, I was importing wordpress MariaDB database from 3rd party hosting:

Azure database for MySQL v5.7 - 1005 (HY000) (errno: 1 "Operation not permitted")
Azure database for MariaDB - 1005 (HY000) (errno: 1 "Operation not permitted")
Azure database for MySQL v8.0 - SUCCESS