There are two linux tuning scripts I would recommend to anyone who wants to tweak MySQL installation for the best possible performance. One of them is MySQL Tuner Primer with...

Following is a batch file I've created to backup my MySQL database. It compresses the backup to a passworded WinRar file. Which is then uploaded by the same batch file...

If you need to auto restart Apache and MySQL in case one or both are crashed, just schedule this SH script on Centos (RHEL) in your cron section. Save the...

This is a simple one liner to automatically check, repair and optimize all MySQL tables and all databases: mysqlcheck -u root -p --auto-repair --check --optimize --all-databases or mysqlcheck -uda_admin -p`grep...

This is very simple: Just run this command on your MYSQL: ALTER TABLE table_name AUTO_INCREMENT=1 It'll fix auto increment starting at record 1.

It just came to me that it shouldn't very hard to write an application, which would create pretty large online hard drive. Ok, ok, I know this is pretty far...