Some tips of Auto Recover MyISAM Tables

Enable MyISAM Auto-Repair

MyISAM can be configured to check and repair its tables automatically. By enabling the MyISAM auto repair you let the server check each MyISAM table when it is opened. It checks if the table was closed properly when it was last used, also checks if it needs any repair, if required it repairs the table.

To enable auto check and repair,you can start the server with –myisam-recover with following options.

DEFAULT for the default checking.

BACKUP tells the server to make a backup of any table that it must change.

FORCE causes table recovery to be performed even if it would cause the loss of more than one row of data.

QUICK performs quick recovery: Tables that have no holes resulting from deletes or updates are skipped.

You can also add it to the my.cnf file as shown below.

How to Choose a Repair Shop
What should I look for when choosing a repair shop?
Ask for recommendations from friends, family, and other people you trust. Look for an auto repair shop before you need one to avoid being rushed into a last-minute decision.
Shop around by telephone for the best deal, and compare warranty policies on repairs.
Ask to see current licenses if state or local law requires repair shops to be licensed or registered. Also, your state Attorney General’s office or local consumer protection agency may know whether there’s a record of complaints about a particular repair shop.
Make sure the shop will honor your vehicle’s warranty.
How to Choose a Technician
Is one technician better than another?
Look for shops that display various certifications – like an Automotive Service Excellence seal. Certification indicates that some or all of the technicians meet basic standards of knowledge and competence in specific technical areas. Make sure the certifications are current, but remember that certification alone is no guarantee of good or honest work.
Ask if the technician or shop has experience working on the same make or model vehicle as yours.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s