Sponsor:

Server and Web Integrator
Link:
Kloxo-MR logo
6.5.0 or 7.0.0
Click for "How to install"
Donation/Sponsorship:
Kloxo-MR is open-source.
Donate and or Sponsorship always welcome.
Click to:
Click Here
Please login or register. 2024-04-29, 01:04:46

Author Topic: MySQL is crashed -- please help fix it  (Read 16565 times)

0 Members and 1 Guest are viewing this topic.

Offline befree22

  • Valuable Member
  • *
  • Posts: 95
  • Karma: +0/-1
    • View Profile
Re: MySQL is crashed -- please help fix it
« Reply #15 on: 2014-10-13, 06:21:51 »
Ran the command but nothing happened. Should I restart the server? How do I switch back to innodb? What should I do to get mysql working and the sites live?

mysql> show engines;
+--------------------+---------+----------------------------------------------------------------+--------------+------+------------+
| Engine             | Support | Comment                                                        | Transactions | XA   | Savepoints |
+--------------------+---------+----------------------------------------------------------------+--------------+------+------------+
| MRG_MYISAM         | YES     | Collection of identical MyISAM tables                          | NO           | NO   | NO         |
| CSV                | YES     | CSV storage engine                                             | NO           | NO   | NO         |
| MEMORY             | YES     | Hash based, stored in memory, useful for temporary tables      | NO           | NO   | NO         |
| BLACKHOLE          | YES     | /dev/null storage engine (anything you write to it disappears) | NO           | NO   | NO         |
| MyISAM             | DEFAULT | MyISAM storage engine                                          | NO           | NO   | NO         |
| FEDERATED          | NO      | Federated MySQL storage engine                                 | NULL         | NULL | NULL       |
| ARCHIVE            | YES     | Archive storage engine                                         | NO           | NO   | NO         |
| PERFORMANCE_SCHEMA | YES     | Performance Schema                                             | NO           | NO   | NO         |
| InnoDB             | NO      | Supports transactions, row-level locking, and foreign keys     | NULL         | NULL | NULL       |
+--------------------+---------+----------------------------------------------------------------+--------------+------+------------+

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: MySQL is crashed -- please help fix it
« Reply #16 on: 2014-10-13, 06:24:14 »
Run 'sh /script/mysql-convert --engine=myisam' because your server not using innodb but this engine already load.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline befree22

  • Valuable Member
  • *
  • Posts: 95
  • Karma: +0/-1
    • View Profile
Re: MySQL is crashed -- please help fix it
« Reply #17 on: 2014-10-13, 06:26:51 »
sh /script/mysql-convert --engine=myisam
/script/mysql-convert: line 42: lxphp.exe: command not found

How do I switch back to innodb? myisam has lots of problems.

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: MySQL is crashed -- please help fix it
« Reply #18 on: 2014-10-13, 06:28:51 »
Look like your server have a trouble. Did you update from Kloxo-MR 6.5.0 to 7.0.0?. If yes, run 'sh /script/upcp -y'.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline befree22

  • Valuable Member
  • *
  • Posts: 95
  • Karma: +0/-1
    • View Profile
Re: MySQL is crashed -- please help fix it
« Reply #19 on: 2014-10-13, 06:34:11 »
No, still using 6.5 -- see sys info on 1st post. And I've been unable to update because of mysql crash.
« Last Edit: 2014-10-13, 06:36:33 by befree22 »

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: MySQL is crashed -- please help fix it
« Reply #20 on: 2014-10-13, 06:35:46 »
So, look like your server missing php52s. Run 'yum install php52s'
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline befree22

  • Valuable Member
  • *
  • Posts: 95
  • Karma: +0/-1
    • View Profile
Re: MySQL is crashed -- please help fix it
« Reply #21 on: 2014-10-13, 06:40:52 »
Still not working.

service nginx restart
Stopping nginx:                                            [  OK  ]
Starting nginx:                                            [  OK  ]
[root@~]# service mysqld restart
Stopping mysqld:                                           [  OK  ]
Starting mysqld:                                           [  OK  ]
[root@~]# mysql -u root -p
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 19
Server version: 5.5.40 Distributed by The IUS Community Project

Copyright (coffee) 2000, 2014, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show engines;
+--------------------+---------+----------------------------------------------------------------+--------------+------+------------+
| Engine             | Support | Comment                                                        | Transactions | XA   | Savepoints |
+--------------------+---------+----------------------------------------------------------------+--------------+------+------------+
| MRG_MYISAM         | YES     | Collection of identical MyISAM tables                          | NO           | NO   | NO         |
| CSV                | YES     | CSV storage engine                                             | NO           | NO   | NO         |
| MEMORY             | YES     | Hash based, stored in memory, useful for temporary tables      | NO           | NO   | NO         |
| BLACKHOLE          | YES     | /dev/null storage engine (anything you write to it disappears) | NO           | NO   | NO         |
| MyISAM             | DEFAULT | MyISAM storage engine                                          | NO           | NO   | NO         |
| FEDERATED          | NO      | Federated MySQL storage engine                                 | NULL         | NULL | NULL       |
| ARCHIVE            | YES     | Archive storage engine                                         | NO           | NO   | NO         |
| PERFORMANCE_SCHEMA | YES     | Performance Schema                                             | NO           | NO   | NO         |
| InnoDB             | NO      | Supports transactions, row-level locking, and foreign keys     | NULL         | NULL | NULL       |
+--------------------+---------+----------------------------------------------------------------+--------------+------+------------+
9 rows in set (0.00 sec)

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: MySQL is crashed -- please help fix it
« Reply #22 on: 2014-10-13, 06:47:28 »
Did you run 'sh /script/mysql-convert --engine=myisam' after install php52s.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline befree22

  • Valuable Member
  • *
  • Posts: 95
  • Karma: +0/-1
    • View Profile
Re: MySQL is crashed -- please help fix it
« Reply #23 on: 2014-10-13, 06:54:22 »
Yes, I did but in phpmyadmin the tables are still not working. Earlier I mentioned that in phpmyadmin, when I click on a database table, I get the following error message:

"1286 Unknown storage engine InnoDB".
« Last Edit: 2014-10-13, 06:56:41 by befree22 »

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: MySQL is crashed -- please help fix it
« Reply #24 on: 2014-10-13, 06:57:18 »
Inform 'yum list installed kloxomr*'.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline befree22

  • Valuable Member
  • *
  • Posts: 95
  • Karma: +0/-1
    • View Profile
Re: MySQL is crashed -- please help fix it
« Reply #25 on: 2014-10-13, 07:02:19 »
yum list installed kloxomr*
Loaded plugins: fastestmirror, priorities, protectbase, replace
Loading mirror speeds from cached hostfile
 * base: mirror.rackspace.com
 * extras: mirror.rackspace.com
 * mratwork-epel: mirror.steadfast.net
 * mratwork-ius-stable: dl.iuscommunity.org
 * updates: centos.chi.host-engine.com
0 packages excluded due to repository protections
Installed Packages
kloxomr.noarch                                                 6.5.0.f-2014040701.mr                        @mratwork-release-neutral-noarch
kloxomr-addon-extjs.noarch                                     1.1-4.mr                                     @mratwork-release-neutral-noarch
kloxomr-addon-yui-dragdrop.noarch                              2.9.0-3.mr                                   @mratwork-release-neutral-noarch
kloxomr-editor-fckeditor.noarch                                2.6.8-8.mr                                   @mratwork-release-neutral-noarch
kloxomr-stats-awstats.noarch                                   7.1-4.mr                                     @mratwork-release-neutral-noarch
kloxomr-thirdparty-jcterm.noarch                               0.0.10-2.mr                                  @mratwork-release-neutral-noarch
kloxomr-thirdparty-phpmyadmin.noarch                           4.0.10-1.mr                                  @mratwork-release-neutral-noarch
kloxomr-thirdparty-sshterm-applet.noarch                       0.2.2-4.mr                                   @mratwork-release-neutral-noarch
kloxomr-webmail-afterlogic.noarch                              7.4.0.7-2.mr                                 @mratwork-release-neutral-noarch
kloxomr-webmail-rainloop.noarch                                1.6.9.164-1.mr                               @mratwork-release-neutral-noarch
kloxomr-webmail-roundcube.noarch                               1.0.3-1.mr                                   @mratwork-release-neutral-noarch
kloxomr-webmail-squirrelmail.noarch                            1.4.22-6.mr                                  @mratwork-release-neutral-noarch
kloxomr-webmail-telaen.noarch                                  1.3.2-2.mr                                   @mratwork-release-neutral-noarch

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: MySQL is crashed -- please help fix it
« Reply #26 on: 2014-10-13, 07:16:19 »
Phpmyadmin already installed. If issue, click 'mysql password reset' before using phpmyadmin.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline befree22

  • Valuable Member
  • *
  • Posts: 95
  • Karma: +0/-1
    • View Profile
Re: MySQL is crashed -- please help fix it
« Reply #27 on: 2014-10-13, 07:36:48 »
There is no problem with phpmyadmin. The problem is that in phpmyadmin, when I click on a database table, I get the following error message:

"1286 Unknown storage engine InnoDB".

You said to switch from innodb to myisam and when I did the problem still existed. There's a conflict with innodb and myisam. I asked you to switch back to innodb but you said the server already loaded myisam.

Please help me get the database tables working again.
« Last Edit: 2014-10-13, 07:41:20 by befree22 »

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: MySQL is crashed -- please help fix it
« Reply #28 on: 2014-10-13, 07:41:24 »
Try running 'sh /script/mysql-convert --engine=myisam' 2 or 3 times. Sometimes need it.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline befree22

  • Valuable Member
  • *
  • Posts: 95
  • Karma: +0/-1
    • View Profile
Re: MySQL is crashed -- please help fix it
« Reply #29 on: 2014-10-13, 12:51:19 »
Still not working. Any solution?

 


MRatWork Affiliates:    BIGRAF(R) Inc.    House of LMAR    EFARgrafix

Page created in 0.065 seconds with 18 queries.

web stats analysis