Continuing my previous article on Backup Entire MySQL Database to Separate Files Automatically. This time I will write how to Backup All MySQL Tables to Separate Files Automatically. Again, a database administrator is often asked to take data from all/some tables separately for certain analysis or processing. In order not Read more…
For a Database Administrator, backing up the database must be a normal thing to do and become a routine. Either manually or automatically, it is very important to back up the database you manage. Then, if in 1 database server there are a lot of databases and you need to Read more…
MySQL is one of the open-source RDBMS (Relational DataBase Management System) software which is included in the top 3 most popular and most widely used worldwide. Currently, the most recent version of MySQL is MySQL 8, with a minor version 8.0.18 as of this writing. I will share information about Read more…
Binary Log in MySQL serves to store the entire series of queries that run on MySQL. Whether it’s a DDL, DML or DCL query, it will be stored in the mysql binary log. This Binary Log can gradually fill the storage capacity on your server if it is not managed Read more…
Hello everyone, have you ever experienced a condition on a MySQL server where there were lots of processes that went to sleep? If so, that means we are the same: lol:. A few days ago, I experienced this condition which hampered web application operations. sleeping process that stacks can increase Read more…
If you have an application that uses MySQL or MariaDB databases, then over time the users of the application are increasing, maybe you will encounter an error SQLSTATE[HY000] [1040] Too many connections . The error is because your maximum number of database connections has been exceeded. By default MySQL provides Read more…
Hello, how to import database in MySQL Docker ?. Yes, that’s the question I encountered some time ago when I wanted to migrate a database from a MySQL Server (non-docker) that I have to a MySQL Server that I installed in Docker. Since I’m new to Docker, I was confused Read more…
What is INFORMATION SCHEMA database? INFORMATION_SCHEMA is a database contained in MySQL / MariaDB where it has provided access to the metadata database, all information about the MySQL / MariaDB Server such as database names, tables, columns, data types, access rights and so on are contained therein. INFORMATION_SCHEMA is very Read more…
Hello everyone, I want to share some tips regarding MySQL / MariaDB user privileges settings. If you have read my post about Tips for Creating MySQL / MariaDB Database Users, there I have explained a little about the importance of managing database user privileges. Why is privilege setting important? because Read more…
In this post I will give a few tips to create a good mysql or mariadb database user. For a developer, of course, you need a user to access the database on the server. So, as a SysAdmin, my job is to make user database access for developers. In order Read more…