Previous Post: Web-safe fonts for linux viewers
Next Post: SKwizard - Linux M4A Converter and file rename tool
Optimize and repair all mysql databases at once
Posted By Scott Klarr on Mar 06, 2008 at 1:27 am
There is a really handy MySql utility called mysqlcheck that allows you to do a number of actions to all databases on your mysql server at once. I am writing this specifically for Linux, but I'm sure windows and Unix versions are very similar if not exactly the same. Run this command as root (super user)
mysqlcheck -Aor
mysqlcheck -Ar
mysqlcheck -Ao
Argument Definitions
-A - Check all Mysql databases
-r - Repair all Mysql databases
-o - Optimize all Mysql databases
To see all of the available options, run mysqlcheck --help
Related Links
- Linux: Automatically backup your mysql databases daily
- Regular Expressions cheat sheets
- Chris Pirillo live stream in Linux without browser
- Linux: How to setup custom shortcuts in KDE
- Linux: First 15 console commands newbies should learn
- How to enable Javascript in any browser
- Mobile devices about to get a little geekier!
Comments (3)
Post Comment
Technology
- Web Development (28)
- Hardware (21)
- Software (14)
- Internet (23)
- Mobile (6)
- Linux (41)
- Cheat Sheets (367)
- Free Tools (2)
Media
Creative
Philosophy
cjk - Sep 04, 2008
No you should not add the mysql root password, because it would potentially be visible when you do `ps aufwwx`. At least when you do it interactively, don't use -pXYZ.
Aaron Moon - Jul 02, 2008
WOW this is a nice tool, I have actually set this to run as a cron job, and post the output to an admin mail I have this run about once per week late sunday to insure low load times.....
Vladimir - May 15, 2008
You should also add mysql root password to this command. In the example shown MySQL password is not set, that seems to be a risky configuration