Details
-
Bug
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
10.8.6
-
None
-
None
-
Virtual machine with RockyLinux 8.6
Description
We have a test installation with three instances of MariaDB Server 10.8.6, where all of them are multi-master replicas.
When backing up a schema and data to the production facility, which is an identical version and also has three instances, we can't load the dump because only the tables are created but no rows are inserted.
And it has not returned a warning and/or error messages.
We are attaching the configuration files of the backup source service and the destination.
The lines we executed were:
FCenter-Central2-testing ~]# mariadb-dump -uroot -p************ -P3306 geoprescriptions > geoprescriptions.dmp
|
srv-central-db ~]# mariadb --socket=/var/lib/mysql/mysqld0.sock geoprescriptions < geoprescriptions.dmp
|
And the workaround we found is:
After many unsuccessful attempts, we found that by commenting out just one line of the backup file, we could solve the problem, that line is:
-- /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; |
and at the end of the file, to avoid error messages:
-- /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
|
Finally, we are attaching the backup file with which it was finally possible to get the data into production.
Thank you very much in advance for your effort.
Hug,
Carlos