mysqldump is a utility program used for making a logical backup by generating a set of SQL statements that can be executed to reproduce the original database table data and object definition. It dumps one or more database for backup or may transfer to another SQL server. It can also generate data output in different […]
MariaDB
/var/tmp file system getting full due to Mariadb
By default MariaDB will create temporary table structure in /var/tmp and this fills up space of root file system(/). We can change default setting by assigning a custom temp directory in ‘[mysqld]‘ section in my.cnf file. MariaDB creates temporary table structure in tmpdir(/var/tmp) directory when there are huge/bulk inserts into table. By default, MariaDB will […]
How to install and configure MariaDB in CentOS / RHEL 7
MariaDB is the default implementation of MySQL in Red Hat Enterprise Linux 7. MariaDB is a community-developed fork of the MySQL database project, and provides a replacement for MySQL. Installing MariaDB 1. As the MariaDB Database Management System (DBMS) is not installed by default on RHEL/CentOS 7, we will start this recipe by installing the […]