Crashed table repair

900px Db table crashIt may happen that during a "hard restart" of the server, some of the files containing the system database tables may be damaged (consider using UPS system). As a result of it, links between contacts and their services may occur, or similar problems.

If it happens you will receive error notifications on corrupted tables in the system.

Thus if you encounter the notifications while working in the system, login to the command line environment and enter the following command for repairing the table:

It is obvious from the following message that a database table has been corrupted: Table './ispadmin/visited_pages' is marked as crashed...
Use the corrupted table name visited_pages in the following command to fix it:

  • First stop the database

/etc/init.d/mysql stop

  • Reparation

myisamchk -o /var/lib/mysql/ispadmin/corrupted_table.MYI

Start the database again

/etc/init.d/mysql start

You will be able to rectify possible errors according to the example. However, it may happen that the corruption is non-repairable, and you will need to restore data from last backup. Contact technical support, or follow these instructions to restore system database.

There is a warning message function in the system that warns an administrator about a corrupted table right after login to allow for the soonest rectification possible.

You have to prevent these situations and rectify problems as soon as they arise.

Tips on how to use this documentation

 

Search

Searching required information is possible either via structured menu which is divided into sections, or via full-text search of the entire contents of this on-line documentation.
Breadcrumbs

This aid will make it possible for you to find out where exactly you are at the moment.

If, for example, the following appears beneath the main menu - ISPadmin Wiki / ENG / Client management / Menu - CLIENTS / Clients / Message Board / Groups - it means that you are:

 

  • in the Wiki documentation of the ISPadmin system
  • in its English localization
  • in the Client management section
  • in the Clients tab
  • in the Message board subtab
  • in the Groups sub-subtab

Changelog

It contains newly added functionalities and modifications of the system which are displayed by versions and issue date. Changelog articles are also displayed in individual sections / pages of the documentation which relate to new functionality or modification. 

Basic orientation

You will find a welcoming menu with basic instruction on trying / implementing / using below. 

FAQ

Frequently asked questions along with most important procedures and settings are listed in FAQ section. 

Colours

Items which refer to real system menu are highlighted in corresponding colour, including their graphical background. Eg. Invoicing Settings Templates Reminders. This is also a working reference to an article. 

CONTACT

NET service solution, s.r.o.
Žerotínova 3056/81a
787 01 Šumperk
Czech Republic