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...
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...
Forgot your WordPress admin login details or a previous developer is unwilling to give you the WordPress login details, well the answer is very simple. As long as you have database access you can use the website below to generate a new password hashsum, simply replace the origional password value with the new hashsum and
Continue reading...