Nowadays, many people store their data in databases and one of the most widely used databases is MySQL/MariaDB database. One feature that is widely used… Read More »How to Export MySQL/MariaDB to Get a CSV File From CLI?
It is very unpleasant if a sysadmin forgets the password to the application or server for which he is responsible. In the previous article, we… Read More »How to Reset MySQL/MariaDB Database Root Password?
As a system administrator, we have to know the applications we use in our daily work. Especially if we use applications whose features and appearance… Read More »How to Know If Our Database Uses MySQL or MariaDB?
Displaying the table size in the MySQL/MariaDB database allows us to find out which table has the largest size in the database. In the previous… Read More »How to Display Table Size in MySQL/MariaDB?
Moving a MySQL/MariaDB database using rsync is an alternative method other than using the mysqldump command and the over-the-network method to move the database. … Read More »How to Move MySQL/MariaDB Database to Another Server? (Part III)
In the previous article, we already explained how to back up and restore a database using the mysqldump command. But to use the method, we… Read More »How to Move MySQL/MariaDB Database to Another Server? (Part II)
The mysqldump command is a built-in command of the MySQL/MariaDB database used to perform the backup of the database. It is originally written by Igor… Read More »How to Move MySQL/MariaDB Database to Another Server? (Part I)
Displaying the database size is needed by a system administrator to estimate when the hard disk on the database server will be full. Problem… Read More »How to Display Database Size in MySQL/MariaDB?
Storage engines are components that handle the SQL operations for different table types to create, read, update data from a database. There are many existing… Read More »How to Find Out What Type of Storage Engine on MySQL/MariaDB?
MySQL data directory is a directory used to store MySQL/MariaDB database data. By default, both databases use the /var/lib/mysql or as known as datadir. If… Read More »How to Move MySQL Data Directory to Another Folder on CentOS?