Posts Tagged “mysql”

Mysql Database Moving Data Directory to New Location.

How to move an existing data directory in mysql to a new location. We were running out of space and had to move the existing data directory to a new drive. Below are the steps to move the data directory to new location.

Written on February 4, 2016
mysql centos linux

Mysql Database Disk Usage.

We were running out of disk space on one of the databases server, we need to get information on what the current table/database usage was. Below are few commands for mysql server tables usages.

Written on February 4, 2016
mysql centos linux

Zabbix Database Backup Script for `postgres` and `mysql`.

After the zabbix setup is done, we would like to take backup of the database. Here we are doing a complete backup. But if we are looking for only configuration backup then we can ignore the history* tables from the database, but for now we are taking complete backup. Backups are taken everyday and last 3 days backups are stored and rest for removed.

Written on January 6, 2016
zabbix snmp trap centos linux backup mysql postgres nagios monitoring

Installing SpagoBI 5.1 on Centos 6.5 -Tomcat 7 with MySQL 5.6.

The SpagoBI project is a free software/open source initiative by the SpagoBI Labs of Engineering Group. It aims to realize the most complete 100% open source business intelligence suite, aggregating developers, integrators, companies, users and passionate people in an open community.

Written on March 4, 2015
linux spagobi bi spago centos tomcat mysql