DB import error

Ajin Prasad 6 Reputation points
2020-08-21T12:26:41.07+00:00

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,

Azure Database for MariaDB
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
709 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Miroslav Adamec 1 Reputation point
    2020-10-28T19:55:25.18+00:00

    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

    0 comments