bspacer1 bspacer2
webmail hosting forum clients about

Computer Co-op, CornerNET Internet Gateway, and PJR Solutions is owned by PJR Sales & Service. Quality products and online services since 1991. We can be your
Complete Computer Connection

Hosting @ $5.95

Domains @ $16.98
Home PagePortal HomeClient AreaAnnouncementsKnowledgebaseSupport TicketsDownloadsRegister

Knowledgebase
You are here: Portal Home > Knowledgebase > cPanel Related Issues > MySQL management issues > I'm getting a 'Server shutdown in progress' MySQL error

I'm getting a 'Server shutdown in progress' MySQL error

There are two main reasons for this error message to show:

1) The MySQL query you are trying to execute takes too long and the MySQL server times out.

The solution for this issue is to optimize your database for the queries which fail.

2) You have a crashed table in your database.

The solution in this case is to repair and optimize your database.

If a particular table crashes often and repairing/optimizing it does not help, this most probably means that the table's structure is not working properly with our MySQL server setup. In such cases the easiest way to fix a crashed MyISAM table for good is to change its database engine from MyISAM to InnoDB.

More information on how to do this can be found in this article.



Was this answer helpful?

Add to Favourites
Print this Article

Also Read
How can I import a large database to my account? PhpMyAdmin times out. (Views: 11279)
I get an error 'ACCESS DENIED CREATE DATABASE db_name' when I try to import a database (Views: 10054)
I get syntax error when trying to run a MySQL query. (Views: 1061)
I don't have enough privileges for creating/dropping databases in PhpMyAdmin (Views: 2706)
I have problems accessing my MySQL database remotely (Views: 5299)

Powered by WHMCompleteSolution


Copyright © 1994-2021 PJR Sales and Service All Rights Reserved