Monday, November 22, 2021

Moving mariadb database

 https://www.digitalocean.com/community/tutorials/how-to-import-and-export-databases-in-mysql-or-mariadb


[root@database-rhel79 dmdbmariadbbackup]# mysqldump -p dmdb > dmdb.sql

Enter password:




[root@database-rhel79 dmdbmariadbbackup]# head dmdb.sql
-- MariaDB dump 10.19  Distrib 10.5.9-MariaDB, for Linux (x86_64)
--
-- Host: localhost    Database: dmdb
-- ------------------------------------------------------
-- Server version       10.4.21-MariaDB

/*!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 */;


[root@database-rhel84 data]# mysql -p dmdb < dmdb.sql
Enter password:
[root@database-rhel84 data]#

No comments:

Post a Comment