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
Free MySQL Database Hosting
Looking for a free MySQL hosting solution? In this blog post, I will list some of the MySQL hosting providers
mysqldump Lost connection to MySQL server during query when dumping table
When taking backup of a MySQL database, i got error This error happens when connection between your MySQL client and
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
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
Limit disk used by MySQL binary log files
On a server, the disk was almost full. On checking most of the disk space is used in “/var/lib/mysql” folder,
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
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
How to Repair MyISAM Tables
MyISAM tables (.MYI and .MYD) can be repaired using myisamchk command. To find list of corrupted tables To rapier a
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. The error is due to open_files_limit
How to fix InnoDB: ERROR: the age of the last checkpoint
On a MySQL server, the error log keeps getting the following error message The error is because you are trying
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