MySQL

MyISAM tables (.MYI and .MYD) can be repaired using myisamchk command. To find list of corrupted … How to Repair MyISAM TablesRead more

On a Debian 7 server, the MySQL database got corrupted, which caused the MySQL database to … How to create MySQL data directory with mysql_install_dbRead more

MySQL 5.7 is not supported on Ubuntu 22.04, but you can download MySQL 5.7 for Ubuntu … How to Install MySQL 5.7 on Ubuntu 22.04Read more

You can use following config to keep 7 days bin log [mysqld] log_bin = /var/log/mysql/mysql-bin.log binlog_format … Limit disk used by MySQL binary log filesRead more

After installing MySQL 8 and checking listening ports with “netstat -lntp”, you will see MySQL is … How to disable MySQL X Protocol (mysqlx_port)Read more

I wanted to Migrate MySQL from one server to another. Usually, I could just copy over … How to Migrate MySQL Users to Another ServerRead more

When taking backup of a MySQL database, i got error root@server1:~# mysqldump –opt serverok_wp > serverok_wp.sql … mysqldump Lost connection to MySQL server during query when dumping tableRead more

Looking for a free MySQL hosting solution? In this blog post, I will list some of … Free MySQL Database HostingRead more

To recover MySQL table structure from .frm file, you can use dbsake. You can find dbsake … How to Recover MySQL Table Structure from .frm FileRead more

Backing up and restoring large databases can be challenging at times. Recently, when I had to … How to Backup Large MySQL Database Table by TableRead more