宝塔备份出来了/www/server/data 如何恢复数据库

賽福利斯拉68

直接覆盖会导致无法启动mysql
mariadb.service - MariaDB 10.5.19 database server
     Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
     Active: failed (Result: exit-code) since Fri 2023-06-30 19:59:44 EDT; 6s ago
       Docs: man:mariadbd(8)
             https://mariadb.com/kb/en/library/systemd/
    Process: 414922 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
    Process: 414923 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
    Process: 414924 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ]   && systemctl set-environment _WSRE>
    Process: 415098 ExecStart=/usr/sbin/mariadbd $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=7)
   Main PID: 415098 (code=exited, status=7)
     Status: "MariaDB server is down"
        CPU: 178ms

Jun 30 19:59:44 GreenCloud.1212314513 mariadbd[415098]: 2023-06-30 19:59:44 0 [Note] InnoDB: Setting file '/www/server/data/ibtmp1' size to 12 MB. Physically writing the file full; Please >
Jun 30 19:59:44 GreenCloud.1212314513 mariadbd[415098]: 2023-06-30 19:59:44 0 [Note] InnoDB: File '/www/server/data/ibtmp1' size is now 12 MB.
Jun 30 19:59:44 GreenCloud.1212314513 mariadbd[415098]: 2023-06-30 19:59:44 0 [Note] InnoDB: 10.5.19 started; log sequence number 55786561175; transaction id 4745937
Jun 30 19:59:44 GreenCloud.1212314513 mariadbd[415098]: 2023-06-30 19:59:44 0 [Note] Plugin 'FEEDBACK' is disabled.
Jun 30 19:59:44 GreenCloud.1212314513 mariadbd[415098]: 2023-06-30 19:59:44 0 [ERROR] Could not open mysql.plugin table: "Table 'mysql.plugin' doesn't exist". Some plugins may be not loaded
Jun 30 19:59:44 GreenCloud.1212314513 mariadbd[415098]: 2023-06-30 19:59:44 0 [ERROR] /usr/sbin/mariadbd: unknown variable 'early-plugin-load='
Jun 30 19:59:44 GreenCloud.1212314513 mariadbd[415098]: 2023-06-30 19:59:44 0 [ERROR] Aborting
Jun 30 19:59:44 GreenCloud.1212314513 systemd[1]: mariadb.service: Main process exited, code=exited, status=7/NOTRUNNING
Jun 30 19:59:44 GreenCloud.1212314513 systemd[1]: mariadb.service: Failed with result 'exit-code'.
Jun 30 19:59:44 GreenCloud.1212314513 systemd[1]: Failed to start MariaDB 10.5.19 database server.

sasa516

两条命令的事