
Sometimes you may need to run MySQL queries from terminal or shell script. Here is how to run MySQL query from command line.
Sometimes you may need to run MySQL queries from terminal or shell script. Here is how to run MySQL query from command line.
Sometimes you may need to extract database from MySQL dump file. Here are the steps to restore or import single database in MySQL.
Sometimes you may need to restore specific tables from MySQL dump file. Here are the steps to extract table from MySQL dump file.
mysql_secure_installation allows you to make your MySQL installation secure. Here is how to automate mysql_secure_installation script in Linux.
It can be time-consuming to take full database backup every time in MySQL. Here is how to do incremental backup in MySQL using binary log.
MySQL Datetime & Timestamp are two useful data types. Here are the key differences between the two data types in MySQL.
Python allows you to load data into databases and run SQL queries. Here is the python script to load data in MySQL.