Debian配置导入数据库-lnxserver2

赛题

2.2.5、数据库的双机热备（MariaDB）Slave端

· lnxserver2 上导入lnxserver1 上的数据库WordPress ，验证双机热备功能；

lnxserver2和1题目内容一样，只做这个不同的

1.导入数据库

lnxserver1拷贝到2

root@lnxserver1:/var/www/backup# scp 20230216100327.sql root@172.0.10.121:/20230216100327.sql
root@172.0.10.121's password: 
20230216100327.sql     100%   45KB   8.3MB/s   00:00    

创建database，导入sql文件

root@lnxserver2:~# mysql
MariaDB [(none)]> create database wordpress;
Query OK, 1 row affected (0.013 sec)

MariaDB [(none)]> use wordpress;
Database changed
MariaDB [wordpress]> source /20230216100327.sql

查看验证

MariaDB [wordpress]> show tables;
+-----------------------+
| Tables_in_wordpress   |
+-----------------------+
| wp_commentmeta        |
| wp_comments           |
| wp_links              |
| wp_options            |
| wp_postmeta           |
| wp_posts              |
| wp_term_relationships |
| wp_term_taxonomy      |
| wp_termmeta           |
| wp_terms              |
| wp_usermeta           |
| wp_users              |
+-----------------------+
12 rows in set (0.001 sec)

MariaDB [wordpress]> select * from wp_users;
+----+------------+------------------------------------+---------------+------------+----------+---------------------+---------------------+-------------+--------------+
| ID | user_login | user_pass                          | user_nicename | user_email | user_url | user_registered     | user_activation_key | user_status | display_name |
+----+------------+------------------------------------+---------------+------------+----------+---------------------+---------------------+-------------+--------------+
|  1 | root       | $P$Bowbh2vjjh4zo3fJ.KKhsF.CBu.3s1. | root          | 1@qq.com   |          | 2023-02-16 02:46:45 |                     |           0 | root         |
+----+------------+------------------------------------+---------------+------------+----------+---------------------+---------------------+-------------+--------------+
1 row in set (0.001 sec)