Years ago, there was a couple of batch files that were floating around the Internet that were designed to defrag and shrink virtual machines created and used by VMware Workstation or VMware Server. Over time, the scripts became a little obsolete in that some of the command line functionality was lost from the removal of a utility, vmware-mount, from newer…
Read More »A MySql database needed to be removed and upon deletion of that single database, the extremely large three gigabite ibdata1 (data) file remained. Here are the steps I took to reduce or shrink the file once the database was removed. Since there was no other use for this MySql installation, there remained the MySql system databases. Show Databases Backup Databases…
Read More »I recently encountered a database that was 4 MB in size with it’s respective transaction log at 460 MB. The transaction log is used in a recovery model to restore the database to a point in time. I wanted to reduce the size of the transaction log. More importantly, I wasn’t exactly clear as to why a transaction log of…
Read More »