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