服务器 Gind.cn
  1. 服务器 Gind.cn
  3. 如何恢复我的MySQL 5.1在Ubuntu 10.4？
Intereting Posts
需要在2010年交换所有交换箱大量出口到个别PST 热插拔与非热插拔磁盘 当快照处于待处理状态时，我可以重新附加EBS吗？ 惠普Proliant ML350 G6风扇1失踪 在没有端口的FreeBSD 8.2上安装MySQL 为什么EBS一直在等待被终止的实例？ 在linux cli中排列输出 我如何根据延迟和带宽来确定最快的内存？ SDERR和STDOUT用于logging的BASH脚本中的文件描述符 最好的方法来复制服务器？ 在Verizon DSL服务器上托pipe一大堆网站？ 错误的PID：带软件集合Python的supervisord程序 经典的ASP iis7 CPU使用率上升，修正了ASP设置的变化 使用GPO运行一次batch file Ping等效于检查端口是否打开

如何恢复我的MySQL 5.1在Ubuntu 10.4？

我很大麻烦，无法访问我的MySQL服务器..重新启动后

grep mysql / var / log / syslog正在显示 

Jul 30 14:30:23 of-desktop kernel: [ 4763.427066] type=1505 audit(1280480423.517:20): operation="profile_replace" pid=11282 name="/usr/sbin/mysqld" Jul 30 14:34:22 of-desktop kernel: [ 8.780926] type=1505 audit(1280480662.866:5): operation="profile_load" pid=803 name="/usr/sbin/mysqld" Jul 30 14:34:24 of-desktop init: mysql main process (813) terminated with status 1 Jul 30 14:34:24 of-desktop init: mysql main process ended, respawning

同时给予指挥 

 sudo service mysql start

它挂着。

CTRL + C将结束它。 再次给出相同的命令是 

 start: Job is already running: mysql

grep -v'^＃“/etc/mysql/my.cnf 

 [client] port = 3306 socket = /var/run/mysqld/mysqld.sock [mysqld] port = 3306 socket = /var/run/mysqld/mysqld.sock skip-locking key_buffer_size = 384M max_allowed_packet = 1M table_open_cache = 512 sort_buffer_size = 2M read_buffer_size = 2M read_rnd_buffer_size = 8M myisam_sort_buffer_size = 64M thread_cache_size = 8 query_cache_size = 32M thread_concurrency = 8 log-bin=mysql-bin server-id = 1 [mysqldump] quick max_allowed_packet = 16M [mysql] no-auto-rehash [myisamchk] key_buffer_size = 256M sort_buffer_size = 256M read_buffer = 2M write_buffer = 2M [mysqlhotcopy] interactive-timeout

dpkg -l | grep mysql给出 

 ii libdbd-mysql-perl 4.012-1ubuntu1 A Perl5 database interface to the MySQL data ii libmysqlclient16 5.1.41-3ubuntu12.3 MySQL database client library ii libqt4-sql-mysql 4:4.6.2-0ubuntu5 Qt 4 MySQL database driver ii mysql-client 5.1.41-3ubuntu12.3 MySQL database client (metapackage depending ii mysql-client-5.1 5.1.41-3ubuntu12.3 MySQL database client binaries ii mysql-client-core-5.1 5.1.41-3ubuntu12.3 MySQL database core client binaries ii mysql-common 5.1.41-3ubuntu12.3 MySQL database common files (eg /etc/mysql ii mysql-server 5.1.41-3ubuntu12.3 MySQL database server (metapackage depending ii mysql-server-5.1 5.1.41-3ubuntu12.3 MySQL database server binaries ii mysql-server-core-5.1 5.1.41-3ubuntu12.3 MySQL database core server files ii php5-mysql 5.3.2-1ubuntu4.2 MySQL module for php5

grep mysql /var/log/daemon.log 

 Jul 30 14:30:23 of-desktop mysqld[11230]: Jul 30 14:30:23 of-desktop mysqld[11230]: PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! Jul 30 14:30:23 of-desktop mysqld[11230]: To do so, start the server, then issue the following commands: Jul 30 14:30:23 of-desktop mysqld[11230]: Jul 30 14:30:23 of-desktop mysqld[11230]: /usr/bin/mysqladmin -u root password 'new-password' Jul 30 14:30:23 of-desktop mysqld[11230]: /usr/bin/mysqladmin -u root -h of-desktop password 'new-password' Jul 30 14:30:23 of-desktop mysqld[11230]: Jul 30 14:30:23 of-desktop mysqld[11230]: Alternatively you can run: Jul 30 14:30:23 of-desktop mysqld[11230]: /usr/bin/mysql_secure_installation Jul 30 14:30:23 of-desktop mysqld[11230]: Jul 30 14:30:23 of-desktop mysqld[11230]: which will also give you the option of removing the test Jul 30 14:30:23 of-desktop mysqld[11230]: databases and anonymous user created by default. This is Jul 30 14:30:23 of-desktop mysqld[11230]: strongly recommended for production servers. Jul 30 14:30:23 of-desktop mysqld[11230]: Jul 30 14:30:23 of-desktop mysqld[11230]: See the manual for more instructions. Jul 30 14:30:23 of-desktop mysqld[11230]: Jul 30 14:30:23 of-desktop mysqld[11230]: Please report any problems with the /usr/bin/mysqlbug script! Jul 30 14:30:23 of-desktop mysqld[11230]: Jul 30 14:30:23 of-desktop mysqld[11230]: The latest information about MySQL is available at http://www.mysql.com/ Jul 30 14:30:23 of-desktop mysqld[11230]: Support MySQL by buying support/licenses from http://shop.mysql.com/ Jul 30 14:30:23 of-desktop mysqld[11230]: Jul 30 14:30:23 of-desktop mysqld[11263]: #007/usr/sbin/mysqld: File './mysql-bin.index' not found (Errcode: 13) Jul 30 14:30:23 of-desktop mysqld[11263]: 100730 14:30:23 [ERROR] Aborting Jul 30 14:30:23 of-desktop mysqld[11263]: Jul 30 14:30:23 of-desktop mysqld[11263]: 100730 14:30:23 [Note] /usr/sbin/mysqld: Shutdown complete Jul 30 14:30:23 of-desktop mysqld[11263]: Jul 30 14:30:23 of-desktop mysqld[11271]: #007/usr/sbin/mysqld: File './mysql-bin.index' not found (Errcode: 13) Jul 30 14:30:23 of-desktop mysqld[11271]: 100730 14:30:23 [ERROR] Aborting Jul 30 14:30:23 of-desktop mysqld[11271]: Jul 30 14:30:23 of-desktop mysqld[11271]: 100730 14:30:23 [Note] /usr/sbin/mysqld: Shutdown complete Jul 30 14:30:23 of-desktop mysqld[11271]: Jul 30 14:30:23 of-desktop mysqld[11275]: #007/usr/sbin/mysqld: File './mysql-bin.index' not found (Errcode: 13) Jul 30 14:30:23 of-desktop mysqld[11275]: 100730 14:30:23 [ERROR] Aborting Jul 30 14:30:23 of-desktop mysqld[11275]: Jul 30 14:30:23 of-desktop mysqld[11275]: 100730 14:30:23 [Note] /usr/sbin/mysqld: Shutdown complete Jul 30 14:30:23 of-desktop mysqld[11275]: Jul 30 14:30:23 of-desktop mysqld[11279]: #007/usr/sbin/mysqld: File './mysql-bin.index' not found (Errcode: 13) Jul 30 14:30:23 of-desktop mysqld[11279]: 100730 14:30:23 [ERROR] Aborting Jul 30 14:30:23 of-desktop mysqld[11279]: Jul 30 14:30:23 of-desktop mysqld[11279]: 100730 14:30:23 [Note] /usr/sbin/mysqld: Shutdown complete Jul 30 14:30:23 of-desktop mysqld[11279]: Jul 30 14:34:24 of-desktop init: mysql main process (813) terminated with status 1 Jul 30 14:34:24 of-desktop init: mysql main process ended, respawning

可能是什么问题？ 谢谢 …

你有没有检查/var/log/daemon.log ？ 也许正在忙于重build/检查损坏的表，如果最近崩溃可能需要一段时间。

你也可以试试top ，看看mysql进程是不是僵尸，或者正在等待I / O（符号D，而不是S），在这种情况下，你可能有一个硬盘的问题。

你重新启动之前是否更改MySQL设置？ 通过重新启动，你的意思是“糟糕，我的服务器崩溃了，在重新启动MySQL无法启动”或“我只是试图重新启动MySQL”。

有两件事你可能要检查：

  • / var / lib / mysql下的文件权限可以吗？ MySQL用户能够到达那里吗？ 这是我在Ubuntu 10.04中的/ var / lib / mysql： 

     drwx------ 4 mysql mysql 4.0K 2010-07-28 20:42 . drwxr-xr-x 68 root root 4.0K 2010-07-28 15:13 .. -rw-r--r-- 1 root root 0 2010-07-28 13:04 debian-5.1.flag -rw-rw---- 1 mysql mysql 10M 2010-07-28 20:42 ibdata1 -rw-rw---- 1 mysql mysql 5.0M 2010-07-28 20:42 ib_logfile0 -rw-rw---- 1 mysql mysql 5.0M 2010-07-28 13:04 ib_logfile1 drwx------ 2 mysql root 4.0K 2010-07-28 13:04 mysql

  • 你在/etc/mysql/my.cnf下修改path吗？ 也许MySQL正在从错误的地方寻找mysql-bin.index？

尝试在my.cnf中设置datadir，通常是datadir = / var / lib / mysql。

我发现了这个问题。 昨天我安装了鱿鱼后，我禁用它，所以没问题。 当我重新启动鱿鱼自动启用，并阻止MySQL（我认为）。 现在我完全删除它，现在MySQL工作。 我不知道为什么。 但问题是由于鱿鱼。 谢谢你帮助我 与爱kumar。