How to repair all MySQL databases on a server in one go

		SA WebHosting Talk - Web Hosting Discussions > SA WebHostingTalk > Content
How to repair all MySQL databases on a server in one go

Recent blog posts
Using GIMPPortable as alternative to PhotoShop How to encrypt & protect your portable data, on a USB HDD or memory stick Improving search engine ranking with Google Our blog is online! more

Navigation
Content Blogs Submit Blog Posts

Syndicate

How to repair all MySQL databases on a server in one go

By SoftDux at 04/22/2009 - 22:33

Here's a quick & ditry trick to repair all MySQL databases on a server, in one go.

Run the following commands on your server, in the console as root.

mysqlcheck --all-databases -r #repair
mysqlcheck --all-databases -a #analyze
mysqlcheck --all-databases -o #optimize

2 comments

by OmniPrint on Thu, 04/30/2009 - 06:35

thank you this is helpful

by Rudi on Tue, 05/05/2009 - 10:43

These commands are rather useful, and I'm sure one could even add it to a crontjob to run once per week? Or how about adding it to the servers start up scripts?

Read full thread
Login or register to post comments

Latest Forum post
Apache & C# ASP.Net pages how can we improve SA WebHostingTalk? Terms of Use / Policies is that a brilliant idea additional bandwidth Formula For Affiliate Marketing Success Magento Warning: cooking healthy meals ... be aware - new scam Graphic Design and SEO Expert volunteers needed for 16 Days of Activism Campaign What neutral carbon hosting providers do you know?

Forum
Apache & C# ASP.Net pages how can we improve SA WebHostingTalk? Terms of Use / Policies is that a brilliant idea additional bandwidth Formula For Affiliate Marketing Success Magento

All times are GMT +2. The time now is 10:45 PM.