Came across the need to perform maintenance on a MySQL database which holds millions of records, we needed to remove all data which was 2+ years old which involved deleting around 530 million records from a very large table, hitting nearly 200GB.
Continue reading...
MySQL
Easily backup a windows based MySQL server using a scheduled bat file, including archiving and removal of older backups.
Continue reading...
Damaged or crashed MySQL tables due to an unsafe server shut downs, disk space limits or general MySQL failures? Do a find and find and repair on your damaged MySQL tables.
Continue reading...