Examining this I tried to run the mysqldump that tries to copy the
database from SOURCE to TARGET. Seems it does not dump the contents of
the database, just some SET lines. Example below with usernames and
passwords edited out. This command was run on the TARGET. I did not
see error messages in logs.
root@ispc6:~# mysqldump -cCQ --triggers --routines --quote-names
--hex-blob -h <ip-number -u <username> -p'password' alfamat_db
-- MySQL dump 10.16 Distrib 10.1.26-MariaDB, for debian-linux-gnu
(x86_64)
--
-- Host: 999.999.999.999 Database: alfamat_db
-- ------------------------------------------------------
-- Server version 5.1.73-1+deb6u1-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 */;
root@ispc6:~#