Unknown storage engine InnoDB when using LOCK TABLES
Have you ever noticed the error Unknown storage engine InnoDB when using LOCK TABLES
Tag - mysql
Change MySQL Data Directory in Linux This post discussing how to change MySQL Data Directory. As everyone knows the default MySQL data directory is...
Backup and Restore Database in Linux
You can use “mysql” and “mysqldump” utility to backup and restore database in Linux.
Install mytop on cPanel
Mytop is a useful commadline MySQL monitoring tool (TUI) available for linux.
MySQL can log slow queries which take more time to execute. This may due to the bad coding. So, the slow query log will help you to find out the bad codes and...
How to Reset MySQL root password Sometimes we loose or forget the root password of MySQL database. Following steps explain how to reset MySQL root password by...