Mairadb数据库基本操作之数据管理

江湖有缘

已于 2023-03-22 17:31:45 修改

阅读量1.3k

点赞数 2

分类专栏： Mysql 文章标签： mariadb

于 2022-04-20 23:24:25 首次发布

本文链接：https://blog.csdn.net/jks212454/article/details/124294277

版权

本文详细介绍了MariaDB数据库的管理，包括检查环境状态，数据库的增删改查，如创建、查看、修改和备份数据库，以及数据库表的创建、查询、更改和删除。此外，还涉及到了数据表字段的增删查改和数据内容的四大操作：插入、修改、查询和删除。

摘要由CSDN通过智能技术生成

一、检查环境状态

[root@mster-k8s ~]# systemctl status mariadb
● mariadb.service - MariaDB 10.6.7 database server
   Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
  Drop-In: /etc/systemd/system/mariadb.service.d
           └─migrated-from-my.cnf-settings.conf
   Active: active (running) since Wed 2022-04-20 11:50:35 CST; 12min ago
     Docs: man:mariadbd(8)
           https://mariadb.com/kb/en/library/systemd/
  Process: 11187 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
  Process: 7810 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ]   && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS)
  Process: 7778 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
 Main PID: 8024 (mariadbd)
   Status: "Taking your SQL requests now..."
    Tasks: 9
   Memory: 90.5M
   CGroup: /system.slice/mariadb.service
           └─8024 /usr/sbin/mariadbd

二、mariadb的数据库增删改查

1.本地进入mariadb

[root@mster-k8s ~]# mysql
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 4
Server version: 10.6.7-MariaDB MariaDB Server
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]>

2.增——创建一个数据库

MariaDB [(none)]> create database huawei;
Query OK, 1 row affected (0.000 sec)

3.查——查看数据库

MariaDB [(none)]> show databases;
+--------------------+
| Database           |
+--------------------+
| huawei             |
| information_schema |
| mysql              |
| performance_schema |
| sys                |
| test               |
+--------------------+
6 rows in set (0.000 sec)

4.改——修改数据库名称

①查看数据库列表

MariaDB [(none)]> show databases;
+--------------------+
| Database           |
+--------------------+
| huawei_reduction   |
| information_schema |
| mysql              |
| performance_schema |
| redhat             |
| sys                |
+--------------------+

②新建空数据库

MariaDB [(none)]> create database mall;
Query OK, 1 row affected (0.000 sec)

③备份数据库

mysqldump -uroot -p123  huawei_reduction  > /backup/mariadb/huawei.sql

④恢复到空数据库

mysqld -uroot -p123  mall  < ./huawei.sql

⑤检查恢复后的数据库

MariaDB [(none)]> use mall
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
MariaDB [mall]> 
MariaDB [mall]> show tables;
+----------------+
| Tables_in_mall |
+----------------+
| student        |
+----------------+
1 row in set