Save HDD space removing the old logs

If your HDD is almost full, delete (or export) the old logs data and optimize the MySQL disk utilization.

Introduction

This guide include some suggestions in order to keep safe and clean your xCally database.

We strongly recommend you to refer to your DBA before doing any operations on the database.

First of all, backup the data!

Perform a database dump is not a complex operation, but you need to know which is exactly the database size because you will need enough space to save the dump file.

You can get the DB size by running the following query

SELECT table_schema "Data Base Name", 
SUM( data_length + index_length ) / 1024 / 
1024 "Data Base Size in MB"
FROM information_schema.TABLES 
GROUP BY table_schema ;