Reclaim disk space ibdata1 file in /var/lib/mysql is huge

[billsimon]

Ibdata1 filling up disk space

Appreciate it. Dumping the asteriskcdrdb database after having deleted CEL data older than 6 months was only 740 mb. If it grows really quick again I’ll look into storing it remotely. In the interest of having it fully documented for anyone else like me that isnt as versed in mysql as maybe they could be First create copies of the databases from the CLI. If you want to trim down the CEL table you can do that first. cd /var/lib/mysql mysqldump asteriskcdrdb > asteriskcdrdb.sql; mysqldump ast…