The Ultimate Guide to High Availability with MariaDB

Problems with Export/Import Database on MariaDB 10.6

You are viewing an old version of this question. View the current version here.

Hello everyone, I am a beginner in the area of MariaDB and have to operate a system with various servers and a MariaDB (master/slave in the Linux environment). So far (under 10.2) I was able to import the dump from the master with the command mysql -D DBNAME >Output.file> on the slave. Before the import, I deleted the DB and created a new one.

Since switching to MariaDB 10.6 (on both servers) I now have the problem that the import on the slave no longer works. No matter which tool I try (mariadb, mariadb-dump mysqldump,...) I always get the same error:

Instead of silently dumping the data into the DB (like before) I get the content of the SQL dump file page by page. When I look at the contents of the DB, I can already see that it has created some tables. Then suddenly the error appears: ERROR 1100 (HY000) at line 760: Table 'address_sequence' was not locked with LOCK TABLES and the import aborts...

The dump was created with: mariadb-dump --lock-tables --databases <DBNAME>> /var/tmp/>DBNAME_2024.sql or also other calls...

The SQL file has the following structure (first lines) -- MariaDB dump 10.19 Distrib 10.6.18-MariaDB, for Linux (x86_64) -- -- Host: localhost Database: <DBNAME> -- ------------------------------------------------------ -- Server version 10.6.18-MariaDB-log

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;

/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

-- -- Current Database: `<DBNAME>`

Does anyone have any idea how to fix this?

Greetings Heiner

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.