Often database administrators need to backup MySQL database. Here is a shell script to backup MySQL database.
MySQL
How to Change Root Password in MySQL
Sometimes database administrators need to reset root password of their MySQL installation. Here is how to change root password in MySQL.
How to Temporarily Disable Foreign Key Constraint in MySQL
How to Uninstall MySQL in Ubuntu
Sometimes you may need to uninstall MySQL from your system. Here are the steps to uninstall MySQL in Ubuntu Linux.
How to Fix ‘Every Derived Table Must Have Its Own Alias’ MySQL Error
How to Fix MySQL Error 1903 – Can’t Specify Target Table
Sometimes you may get MySQL Error 1903 – Can’t Specify Target Table while working with databases. Here is how to fix it.
How to Use Group By With Order By in MySQL
Often you may need to use group by with order by in MySQL. Here are the steps to aggregate data using group by and order by clauses.
How to Check & Repair MySQL Tables Using MySQLCheck
Sometimes database developers need to repair their MySQL tables and databases. Here is how to check & repair MySQL Tables Using MySQLCheck.
How to Drop All Tables in MySQL Database
MySQL Select Rows Where Column is Not Empty
Sometimes you may need to select rows where column is not empty in MySQL. Here are the steps to do it.