Convert MySQL MyISAM tables to InnoDB
Since MySQL 5.5, InnoDB is the default storage engine due to its reliability, performance, and feature set. Switching from MyISAM to InnoDB…
MySQL
How to Backup Large MySQL Database Table by Table
Backing up and restoring large databases can be challenging at times. Recently, when I had to back up and restore a large…
How to Recover MySQL Table Structure from .frm File
To recover MySQL table structure from .frm file, you can use dbsake. You can find dbsake documentation at http://dbsake.readthedocs.org/en/latest/. To install dbsake,…
Free MySQL Database Hosting
Looking for a free MySQL hosting solution? In this blog post, I will list some of the MySQL hosting providers that offer…
mysqldump Lost connection to MySQL server during query when dumping table
When taking backup of a MySQL database, i got error root@server1:~# mysqldump –opt serverok_wp > serverok_wp.sql mysqldump: Error 2013: Lost connection to…
How to Migrate MySQL Users to Another Server
I wanted to Migrate MySQL from one server to another. Usually, I could just copy over the MySQL data directory (/var/lib/mysql) to…
How to disable MySQL X Protocol (mysqlx_port)
After installing MySQL 8 and checking listening ports with “netstat -lntp”, you will see MySQL is listening on ports 3306 and 33060.…
Limit disk used by MySQL binary log files
You can use following config to keep 2 days bin log After modifying the configuration file, you will need to restart the…
How to Install MySQL 5.7 on Ubuntu 22.04
MySQL 5.7 is not supported on Ubuntu 22.04, but you can download MySQL 5.7 for Ubuntu 18.04 and install it on Ubuntu…
How to create MySQL data directory with mysql_install_db
On a Debian 7 server, the MySQL database got corrupted, which caused the MySQL database to keep crashing. I was able to…
How to Repair MyISAM Tables
MyISAM tables (.MYI and .MYD) can be repaired using myisamchk command. To find list of corrupted tables myisamchk /var/lib/mysql/DB_NAME/*.MYI >> /root/1.txt To…
mysqldump errno: 24 Can’t open file when using LOCK TABLES
When backing up a MySQL database using mysqldump command, I got the following error. root@server12:~# mysqldump –opt DB_NAME > DB_NAME.sql mysqldump: Got…