![](https://serverok.in/wp-content/uploads/2021/12/mysql.webp)
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
![](https://serverok.in/wp-content/uploads/2021/12/mysql.webp)
Free MySQL Database Hosting
Looking for a free MySQL hosting solution? In this blog post, I will list some of the MySQL hosting providers
![](https://serverok.in/wp-content/uploads/2021/12/mysql.webp)
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
![](https://serverok.in/wp-content/uploads/2021/12/mysql.webp)
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
![](https://serverok.in/wp-content/uploads/2021/12/mysql.webp)
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
![](https://serverok.in/wp-content/uploads/2021/12/mysql.webp)
Limit disk used by MySQL binary log files
You can use following config to keep 7 days bin log [mysqld] log_bin = /var/log/mysql/mysql-bin.log binlog_format = ROW expire_logs_days =
![](https://serverok.in/wp-content/uploads/2021/12/mysql.webp)
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
![](https://serverok.in/wp-content/uploads/2021/12/mysql.webp)
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
![](https://serverok.in/wp-content/uploads/2021/12/mysql.webp)
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 >>
![](https://serverok.in/wp-content/uploads/2021/12/mysql.webp)
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
![](https://serverok.in/wp-content/uploads/2021/12/mysql.webp)
How to fix InnoDB: ERROR: the age of the last checkpoint
On a MySQL server, the error log keeps getting the following error message 221024 17:50:03 InnoDB: ERROR: the age of
![](https://serverok.in/wp-content/uploads/2021/12/mysql.webp)
MySQL 8 Your password does not satisfy the current policy requirements
When transferring a website from one Cpanel server to another server running MySQL 8, I got the following error message