HTTPS
AMH 社区首页
AMH社区 - 开放自由有价值的社区
|
|
|---|---|
|
xiaomayi2012 |
xiaomayi2012 发表于 2014-12-07 10:35:08
我现在VPS用的面板是4.2，系统CentOS release 6.5 (Final) - 64BIT 搭建环境是LNMP，我网站在恢复数据库后（因为数据文件 都是.frm .MYD .MYI 文件 我直接把这些文件放到MySQL的data目录，并且数据文件的权限都给到660）现在问题是 数据库放上了。。但是前台网站就是不显示数据库中存储的内容 并且进入网站后台添加数据时提示添加成功，但是没有添加到数据库中，我在网上查了查说是权限问题，但是我已经把数据库文件的权限都设置成660了。还是没有起作用，现将日志文件发出来请大大们给分析分析，，希望大大们能给予一些解决建议，谢谢：（就发这些吧，后面的日志文件内容都差不多。就不发了）
141206 2:31:45 [ERROR] /usr/local/mysql/bin/mysqld: Can't find file: './kan520/wp_comments.frm' (errno: 13) 141206 2:31:45 [ERROR] /usr/local/mysql/bin/mysqld: Can't find file: './kan520/wp_comments.frm' (errno: 13) 141206 2:31:45 [ERROR] /usr/local/mysql/bin/mysqld: Can't find file: './kan520/wp_comments.frm' (errno: 13) 141206 2:31:45 [ERROR] /usr/local/mysql/bin/mysqld: Can't find file: './kan520/wp_comments.frm' (errno: 13) 141206 2:31:45 [ERROR] /usr/local/mysql/bin/mysqld: Can't find file: './kan520/wp_comments.frm' (errno: 13) 141206 2:46:13 [Note] /usr/local/mysql/bin/mysqld: Normal shutdown 141206 2:46:13 [Note] Event Scheduler: Purging the queue. 0 events 141206 2:46:16 [Warning] /usr/local/mysql/bin/mysqld: Forcing close of thread 248027 user: 'root' 141206 2:46:16 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete 141206 02:46:16 mysqld_safe mysqld from pid file /usr/local/mysql/data/li637-186.pid ended 141206 02:46:17 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data 141206 2:46:17 [Note] Plugin 'InnoDB' is disabled. 141206 2:46:17 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 141206 2:46:17 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 141206 2:46:17 [Note] Server socket created on IP: '0.0.0.0'. 141206 2:46:17 [Note] Event Scheduler: Loaded 0 events 141206 2:46:17 [Note] /usr/local/mysql/bin/mysqld: ready for connections. Version: '5.5.34-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution 141206 2:46:18 [ERROR] /usr/local/mysql/bin/mysqld: Can't find file: './kan520/bt_class.frm' (errno: 13) 141206 2:46:32 [ERROR] /usr/local/mysql/bin/mysqld: Can't find file: './kan520/bt_class.frm' (errno: 13) 141206 2:46:35 [ERROR] /usr/local/mysql/bin/mysqld: Can't find file: './kan520/bt_class.frm' (errno: 13) 141206 2:46:37 [ERROR] /usr/local/mysql/bin/mysqld: Can't find file: './kan520/bt_class.frm' (errno: 13) 141206 2:46:47 [ERROR] /usr/local/mysql/bin/mysqld: Can't find file: './kan520/users.frm' (errno: 13) 141206 2:46:48 [ERROR] /usr/local/mysql/bin/mysqld: Can't find file: './kan520/users.frm' (errno: 13) 141206 2:46:56 [ERROR] /usr/local/mysql/bin/mysqld: Can't find file: './kan520/bt_class.frm' (errno: 13) 141206 2:46:59 [ERROR] /usr/local/mysql/bin/mysqld: Can't find file: './kan520/users.frm' (errno: 13) 141206 2:47:00 [ERROR] /usr/local/mysql/bin/mysqld: Can't find file: './kan520/bt_class.frm' (errno: 13) 141206 2:47:02 [ERROR] /usr/local/mysql/bin/mysqld: Can't find file: './kan520/bt_tracker.frm' (errno: 13) 141206 2:47:05 [ERROR] /usr/local/mysql/bin/mysqld: Can't find file: './kan520/bt_hotkey.frm' (errno: 13) 141206 2:47:09 [ERROR] /usr/local/mysql/bin/mysqld: Can't find file: './kan520/users.frm' (errno: 13) 141206 2:47:11 [ERROR] /usr/local/mysql/bin/mysqld: Can't find file: './kan520/bt_class.frm' (errno: 13) 141206 2:47:12 [ERROR] /usr/local/mysql/bin/mysqld: Can't find file: './kan520/bt_tracker.frm' (errno: 13) 141206 2:47:14 [ERROR] /usr/local/mysql/bin/mysqld: Can't find file: './kan520/bt_hotkey.frm' (errno: 13) 141206 2:47:15 [ERROR] /usr/local/mysql/bin/mysqld: Can't find file: './kan520/bt_ad.frm' (errno: 13) 141206 2:47:15 [ERROR] /usr/local/mysql/bin/mysqld: Can't find file: './kan520/bt_class.frm' (errno: 13) 141206 2:47:17 [ERROR] /usr/local/mysql/bin/mysqld: Can't find file: './kan520/users.frm' (errno: 13) 141206 2:47:17 [ERROR] /usr/local/mysql/bin/mysqld: Can't find file: './kan520/bt_class.frm' (errno: 13) 141206 2:47:19 [ERROR] /usr/local/mysql/bin/mysqld: Can't find file: './kan520/bt_tracker.frm' (errno: 13) 141206 2:47:20 [ERROR] /usr/local/mysql/bin/mysqld: Can't find file: './kan520/bt_hotkey.frm' (errno: 13) 141206 2:47:33 [ERROR] /usr/local/mysql/bin/mysqld: Can't find file: './kan520/bt_class.frm' (errno: 13) 141206 2:47:33 [ERROR] /usr/local/mysql/bin/mysqld: Can't find file: './kan520/bt_class.frm' (errno: 13) 141206 2:47:34 [ERROR] /usr/local/mysql/bin/mysqld: Can't find file: './kan520/bt_class.frm' (errno: 13) 141206 2:47:36 [ERROR] /usr/local/mysql/bin/mysqld: Can't find file: './kan520/users.frm' (errno: 13) 141206 2:47:37 [ERROR] /usr/local/mysql/bin/mysqld: Can't find file: './kan520/bt_class.frm' (errno: 13) 141206 2:47:38 [ERROR] /usr/local/mysql/bin/mysqld: Can't find file: './kan520/bt_tracker.frm' (errno: 13) 141206 2:47:40 [ERROR] /usr/local/mysql/bin/mysqld: Can't find file: './kan520/bt_hotkey.frm' (errno: 13) 141206 2:47:40 [ERROR] /usr/local/mysql/bin/mysqld: Can't find file: './kan520/bt_ad.frm' (errno: 13) 141206 2:47:53 [ERROR] /usr/local/mysql/bin/mysqld: Can't find file: './kan520/bt_class.frm' (errno: 13) 141206 2:48:12 [ERROR] /usr/local/mysql/bin/mysqld: Can't find file: './kan520/bt_class.frm' (errno: 13) 141206 2:48:21 [ERROR] /usr/local/mysql/bin/mysqld: Can't find file: './kan520/bt_class.frm' (errno: 13) 141206 2:48:21 [ERROR] /usr/local/mysql/bin/mysqld: Can't find file: './kan520/bt_class.frm' (errno: 13) 141206 2:48:31 [ERROR] /usr/local/mysql/bin/mysqld: Can't find file: './kan520/bt_class.frm' (errno: 13) 141206 2:48:50 [ERROR] /usr/local/mysql/bin/mysqld: Can't find file: './kan520/bt_class.frm' (errno: 13) 141206 2:49:08 [ERROR] /usr/local/mysql/bin/mysqld: Can't find file: './kan520/bt_class.frm' (errno: 13) 141206 2:49:08 [ERROR] /usr/local/mysql/bin/mysqld: Can't find file: './kan520/bt_class.frm' (errno: 13) 141206 2:49:09 [ERROR] /usr/local/mysql/bin/mysqld: Can't find file: './kan520/bt_class.frm' (errno: 13) 141206 2:49:28 [ERROR] /usr/local/mysql/bin/mysqld: Can't find file: './kan520/bt_class.frm' (errno: 13) 141206 2:49:49 [ERROR] /usr/local/mysql/bin/mysqld: Can't find file: './kan520/bt_class.frm' (errno: 13) 141206 2:50:11 [ERROR] /usr/local/mysql/bin/mysqld: Can't find file: './kan520/bt_class.frm' (errno: 13) 141206 2:50:33 [ERROR] /usr/local/mysql/bin/mysqld: Can't find file: './kan520/bt_class.frm' (errno: 13) 141206 2:50:34 [ERROR] /usr/local/mysql/bin/mysqld: Can't find file: './kan520/bt_class.frm' (errno: 13) 141206 2:50:34 [ERROR] /usr/local/mysql/bin/mysqld: Can't find file: './kan520/bt_class.frm' (errno: 13) 141206 2:51:21 [ERROR] /usr/local/mysql/bin/mysqld: Can't find file: './kan520/bt_class.frm' (errno: 13) 141206 2:51:21 [ERROR] /usr/local/mysql/bin/mysqld: Can't find file: './kan520/bt_class.frm' (errno: 13) 141206 2:52:08 [ERROR] /usr/local/mysql/bin/mysqld: Can't find file: './kan520/bt_class.frm' (errno: 13) 141206 2:52:08 [ERROR] /usr/local/mysql/bin/mysqld: Can't find file: './kan520/bt_class.frm' (errno: 13) 141206 2:53:34 [ERROR] /usr/local/mysql/bin/mysqld: Can't find file: './kan520/bt_class.frm' (errno: 13) 141206 2:53:34 [ERROR] /usr/local/mysql/bin/mysqld: Can't find file: './kan520/bt_class.frm' (errno: 13) 141206 2:54:21 [ERROR] /usr/local/mysql/bin/mysqld: Can't find file: './kan520/bt_class.frm' (errno: 13) 141206 2:54:21 [ERROR] /usr/local/mysql/bin/mysqld: Can't find file: './kan520/bt_class.frm' (errno: 13) 141206 2:55:08 [ERROR] /usr/local/mysql/bin/mysqld: Can't find file: './kan520/bt_class.frm' (errno: 13) 141206 2:55:08 [ERROR] /usr/local/mysql/bin/mysqld: Can't find file: './kan520/bt_class.frm' (errno: 13) 141206 2:56:34 [ERROR] /usr/local/mysql/bin/mysqld: Can't find file: './kan520/bt_class.frm' (errno: 13) 141206 2:56:34 [ERROR] /usr/local/mysql/bin/mysqld: Can't find file: './kan520/bt_class.frm' (errno: 13) 141206 2:57:21 [ERROR] /usr/local/mysql/bin/mysqld: Can't find file: './kan520/bt_class.frm' (errno: 13) 141206 2:57:21 [ERROR] /usr/local/mysql/bin/mysqld: Can't find file: './kan520/bt_class.frm' (errno: 13) 141206 2:58:09 [ERROR] /usr/local/mysql/bin/mysqld: Can't find file: './kan520/bt_class.frm' (errno: 13) 141206 2:58:09 [ERROR] /usr/local/mysql/bin/mysqld: Can't find file: './kan520/bt_class.frm' (errno: 13) 141206 2:59:35 [ERROR] /usr/local/mysql/bin/mysqld: Can't find file: './kan520/bt_class.frm' (errno: 13) 141206 2:59:35 [ERROR] /usr/local/mysql/bin/mysqld: Can't find file: './kan520/bt_class.frm' (errno: 13) 141206 3:00:22 [ERROR] /usr/local/mysql/bin/mysqld: Can't find file: './kan520/bt_class.frm' (errno: 13) 141206 3:00:22 [ERROR] /usr/local/mysql/bin/mysqld: Can't find file: './kan520/bt_class.frm' (errno: 13) 141206 3:01:09 [ERROR] /usr/local/mysql/bin/mysqld: Can't find file: './kan520/bt_class.frm' (errno: 13) 141206 3:01:09 [ERROR] /usr/local/mysql/bin/mysqld: Can't find file: './kan520/bt_class.frm' (errno: 13)  点赞，加油！ (0分)
2014-12-07 10:35:08 1
|
|
amysql |
你需要更改成mysql用户
chown mysql:mysql -R mysql的data数据目录
回复
2014-12-08 15:30:00 2
AMH面板 - 好用高效低占用、安全可靠极稳定 |
|
xiaomayi2012 |
引用: amysql 发表于 2014-12-8 15:30  你需要更改成mysql用户 chown mysql:mysql -R mysql的data数据目录 我这样写 chown mysql:mysql -r /usr/local/mysql/data/ 提示 chown: invalid option -- 'r' Try `chown --help' for more information. 求教老大 谢谢~！
回复
2014-12-08 16:11:11 3
|
|
xiaomayi2012 |
引用: amysql 发表于 2014-12-8 15:30 你需要更改成mysql用户 chown mysql:mysql -R mysql的data数据目录 解决 谢谢老大 chown -R mysql:mysql /usr/local/mysql/data 这样写的
回复
2014-12-08 16:14:13 4
|
[求助帖]
求各位大大们给分析下mysql日志文件。
