How To Enable Slow Query Log for MySQL

Install MySQL Server on Ubuntu 16.04

In this tutorial, we will show you how to enable slow query log for MySQL on Linux systems. MySQL has built-in functionality that allows you to log SQL queries to a file, You can enable the full SQL queries logs to a file or only slow running queries log. It is easy for us to troubleshoot/ debug the SQL statement if SQL queries log enable, The slow query log is used to find queries that take a l...

How To Backup and Restore MySQL Database Using Command Line

Install MySQL Server on Ubuntu 16.04

This tutorial guide will show you two easy ways to backup and restore the data in your MySQL database using mysqldump. You can also use this process to move your data to a new web server. We assume that you already have MySQL installed on Linux system with administrative privileges and we assume that you already have a small amount of knowledge on MySQL. The parameters of the said command as fo...