MySQL & MariaDB
Get help with MySQL and MariaDB Database Servers. AGIX Linux staff have the know-how and experience to help your organization with Database Server best-practices, current technology in various Cloud environments including Amazon AWS.
This page shows examples of our work that AGIX Linux shares freely with you. For a fully supported compute environment, contact our team to find out how we can help your organization move forward in the right way.
See Our Blogs on MySQL & MariaDB
Get MySQL Database Sizes
All HowTo's
MySQL & MariaDB
Log into MySQL and issue the following command as it is: SELECT table_schema AS "Database name", SUM(data_length + index_length) / 1024 / 1024 AS "Size (MB)" FROM information_schema.TABLES GROUP BY table_schema; And you’ll get something like the following: +--------------------+--------------+ | Database name | Size (MB) | +--------------------+--------------+ | my_db1 |
Read More
Backup all MySQL databases into their own backup file
All HowTo's
MySQL & MariaDB
This is an example Bash script that will backup the MySQL databases on the local system. It will backup all databases except those called “Database”, “information_schema” and “mysql”. In other words, it will backup ‘your’ databases. Just remove those from the “egrep” command if you want all databases (including the
Read More
MySQL Database Replication Example
All HowTo's
Linux
MySQL & MariaDB
Redhat, Fedora and CentOS Linux
Ubuntu, Mint & Debian Linux
This article explains how to install MySQL 5.1 on Redhat/CentOS and configure replication to a slave MySQL server. In this article, the master host has the IP address “192.168.122.7” and the slave has IP address “192.168.122.6”. Remember to restart the MySQL server if and when you make changes to the
Read More
Need Help?
Click Here