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://video2.skills-academy.com/en-us/azure/mysql/concepts-migrate-dump-restore Thanks,

Azure Database for MariaDB
Azure Database for MariaDB
An Azure managed MariaDB database service for app development and deployment.
55 questions
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
824 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

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.