56,677
社区成员
发帖
与我相关
我的任务
分享
yes|cp -r /var/www/html/data_bak /var/lib/mysql/
chown -R mysql:mysql /var/lib/mysql/data_bak
sudo chmod -R 0640 /var/lib/mysql/data_bak/
chmod 0750 /var/lib/mysql/data_bak/
mysql> select * from information_schema.`TABLES` where TABLE_SCHEMA='data_bak';
Empty set (0.00 sec)
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| sys |
+--------------------+
4 rows in set (0.00 sec)