By default, in most installation binary log files are located in MySQL default director...
Category - Database
Restore MySQL Database From Dump File
As a System Administrator the main key task is to take backup on daily or weekly basis. Backup is...
MySQL Database Backup From The Command Line
On the off chance that you have utilized MySQL for some time, you have likely utilized mysqldump to...
MySQL Database Backup Automatic Script
MySQL is an open source relational database management system (DBMS) which is much of the time...
Steps To Configure Master Slave MySQL Replication
MySQL Replication is a procedure that permits to duplicated or exchanged information starting with...
How To Extract Tables From MySQL Dump File
Mysqldump is used to dump MySQL/MariaDB databases and tables. It is an utility which takes a full...
How To Recover MySQL Root Password
In this article I will explain how to recover MySQL root password. If you have forgotten the MySQL...
How To Connect MySQL Server Without Password Prompt
There are lots of questions like, how do I use MySQL command without prompting password? How can I...
Unable To Connect MySQL Database Server From PHP
Question: I have configured LAMP ( Linux Apache MySQL PHP ). I am able to connect MySQL server from...
Steps Before Shutting Down MySQL Server
MySQL shutdown/restart is required when you applying non dynamic config changes, database...
How To Reinstall MySQL Server v5.x On Linux
Question: I would like to delete my old MySQL server because its database has been corrupted due to...
Automated Installation and Configurations – Apache/Nginx...
In this tutorial I am going to explain how we can install Apache/Nginx, MySQL , PHP or PHP-FPM...
How to Find Table & Database Size in MySQL
As a database administrator you need to know the size of each MySQL table to optimise them. To make...
How To Install Only MySQL Client On CentOS/Redhat 6/7/8 or Ubuntu
Question :- I have MySQL database server running on CentOS and I would like to install only MySQL...