|Project Name||Stars||Downloads||Repos Using This||Packages Using This||Most Recent Commit||Total Releases||Latest Release||Open Issues||License||Language|
|Shrink Ibdata1||19||4 years ago||5||gpl-3.0||Shell|
|Bash shell script to shrink /var/lib/mysql/ibdata1 and restore disk space|
|Zerofill||7||7 years ago||Java|
|Android Application will fill your empty disk space with random data to prevent restoring the data.|
|B17r||5||a year ago||4||mit||Python|
Bash shell script to shrink the MySQL metadata file and restore disk space. This script should work with all MySQL variants such as Percona and MariaDB.
Over time, MySQL databases are added and tables are populated which can cause the /var/lib/mysql/ibdata1 metadata file to grow. This script makes it easy to shrink this file and recover valuable disk space. The script is based loosely on the steps outlined here: http://dba.stackexchange.com/questions/8982/what-is-the-best-way-to-reduce-the-size-of-ibdata-in-mysql.
$ git clone https://github.com/uberhacker/shrink-ibdata1.git $ sudo mv shrink-ibdata1/shrink /usr/local/bin
$ shrink [-k]
Use the -k switch to keep backups instead of restoring the databases
To shrink the MySQL metadata file and restore the databases:
To shrink the MySQL metadata file and keep the backups instead of restoring the databases:
$ shrink -k
You might want to do this if you wish to clear out MySQL of any existing databases.
Although this script will perform a backup and restore of the databases, it is still advisable to make your own backup of /var/lib/mysql and all the databases prior to using.