Start MySQL/MariaDB in recovery mode due to InnoDB coruption on cPanel
Start MySQL/MariaDB in recovery mode due to InnoDB coruption on a cPanel server InnoDB tables don’t get corrupted easily,
Continue reading >Tag Archives for " MySQL "
Changing your MySQL storage engine – MyISAM and InnoDB
I’ve been looking into many ways of converting my database tables from MyISAM to InnoDB and the other way around
Continue reading >Check the storage engine for a MySQL table via terminal
Check the storage engine for a MySQL database via terminal Here’s an easy way to check the storage engine for one
Continue reading >MySQL how to delete old binary logs
You should not just delete your MySQL old binary logs. You need to let mysqld do that for you. The file mysql-bin. --> and
Continue reading >Galera Cluster & MariaDB 10.1+ On CentOS 7 Server
Some overall info about the Galera Cluster solution. Galera Cluster for MySQL is a true Multimaster Cluster based on synchronous
Continue reading >CentOS MySQL Master-Slave Replication – Step by Step
MySQL replication is a process that enables data from one MySQL database server (the master) to be copied automatically
Continue reading >Importing a Large Number of .sql Files to MySQL in One Go!
Here’s a script that would import all of the .sql files in your current directory. I usually use that in case there
Continue reading >How to Manually Install phpMyAdmin and Link it to an External Server
Sometimes you might need to install a second instance of phpMyAdmin and link it with an external server for example. Here’s
Continue reading >MySQL Backup Script
As you all know, the information stored in your database is very important, so backing it up regularly is an essential task. Most
Continue reading >Monitor MySQL Processlist in (almost) Real-Time
This is a pretty easy way to monitor your MySQL processlist in real-time even on shared hosting platforms. Please note
Continue reading >