How to repair all MySQL databases on a server in one go - SA WebHosting Talk

SoftDux · #1 22 Apr 2009

A new dedcated_server_tutorials entry has been added:

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

Quote:

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

OmniPrint · #2 30 Apr 2009

thank you this is helpful

Rudi · #3 5 May 2009

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?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Choosing The Wrong Server Will Literally Make Or Break You	Willie	Dedicated Server	2	5 Jan 2007 09:02 PM
Clustering Solutions and Zero Downtime Hosting Pitfalls	Willie	Tutorials	0	27 Oct 2006 11:03 AM
Server Firewalls	Willie	Technical & Security Issues	6	10 Sep 2006 09:19 PM
Conserving Disk Space on Your Server	Willie	Web Hosting Forum	1	3 Apr 2006 12:17 PM
What You Need to Know to Run a Dedicated Server - Part II	Willie	Dedicated Server	0	31 Mar 2006 10:56 PM