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, run To find the structure of a table from the .frm file, run Back to MySQL
If the disk partition that stores MySQL data directory runs out of disk space, you may need to consider moving the MySQL data directory to another partition. Before you do the MySQL data directory change, make sure you take a backup of all your databases using mysqldump. First, disable MySQL monitoring, so MySQL won’t auto … Read more
Looking for a free MySQL hosting solution? In this blog post, I will list some of the MySQL hosting providers that offer free and paid MySQL hosting. These MySQL hosting is useful for smaller database work loads. If you have lot of data, you may need local MySQL server or a MySQL server to your … Read more
I wanted to Migrate MySQL from one server to another. Usually, I could just copy over the MySQL data directory (/var/lib/mysql) to the new server, this will copy over MySQL users and data. On this server, the MySQL data file (ibdata1) was too large, 200 GB approx. If I do a mysqldump, the SQL file … Read more
After installing MySQL 8 and checking listening ports with “netstat -lntp”, you will see MySQL is listening on ports 3306 and 33060. Port 3306 is used by traditional MySQL protocol (MySQL Classic Protocol). MySQL X Protocol uses port 33060. What is MySQL X Protocol? MySQL X Protocol is a network protocol that allows communication between … Read more
You can use following config to keep 2 days bin log After modifying the configuration file, you will need to restart the MySQL server to apply the changes: You can also manually delete old binary log files to free up disk space: Replace ‘2024-02-01 00:00:00’ with the date before which you want to delete the … Read more
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 20.04 or Ubuntu 22.04 First, install libtinfo5, this is available for download from https://launchpad.net/ubuntu/bionic/amd64/libtinfo5/6.1-1ubuntu1.18.04 The files are moved from the Offical MySQL site https://dev.mysql.com/downloads/mysql/5.7.html So we will download it from a mirror site. … Read more
On a Debian 7 server, the MySQL database got corrupted, which caused the MySQL database to keep crashing. I was able to take a backup of the database following InnoDB Recovery instructions at https://dev.mysql.com/doc/refman/5.6/en/forcing-innodb-recovery.html Once I have the Database backup taken, I took a backup of the MySQL data directory /var/lib/mysql and removed it. To … Read more
cPanel server supports MySQL and MariaDB. In most cases MySQL and MariaDB are compatible, you will be fine with either of them. Find current MySQL version Before you upgrade, find out what version of MySQL or MariaDB you are using with the command mysql –version In this server, we have MariaDB 10.3.37. You can note … Read more
On a MySQL server, the error log keeps getting the following error message 221024 17:50:03 InnoDB: ERROR: the age of the last checkpoint is X, InnoDB: which exceeds the log group capacity 9433498. InnoDB: If you are using big BLOB or TEXT rows, you must set the InnoDB: combined size of log files at least … Read more
When transferring a website from one Cpanel server to another server running MySQL 8, I got the following error message Cpanel::Exception::Database::Error/(XID u99as8) The system received an error from the “MySQL” database “mysql”: 1819 (Your password does not satisfy the current policy requirements) The error is due to validate_password component. https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-password-validation.html Method 1 Edit mysql configuration … Read more
Webuzo stores MySQL root password in file /var/webuzo/my.conf If you changed MySQL/MariaDB root password outside of Webuzo, you need to update this file. You may also need to modify the file /root/.my.cnf This is only for command line access. To change the MySQL root password on Webuzo, login to the Webuzo control panel at https://your-server-ip:2005/ … Read more