Below are the steps to restore mysql database with innodb tables , without contacting r1soft. Set up a temporary mysql...
Optimize database using phpMyAdmin
Over a time as your website add contents to it's database, the files/tables will become fragmented resulting in slower...
Reset mysql password if root password is not known
One of the common issue encountered by server admins while manging mysql is that, the root passwords are unknown. We...
Performance Tuning Scripts for Mysql
Performance Tuning Primer Script is the shell script which gets performance related information from MySQL...
How to find cpanel, ensim, plesk and direct admin mysql root password
Cpanel ♦ You can get the mysql root password in a cpanel password from the file /root/.my.cnf Ensim ♦ To get the mysql...
InnoDB
MyISAM and InnoDB are two most commonly used storage engines of MySQL database. However, MyISAM is the default...
Enable Innodb in cPanel server
To Enable innodb in cpanel server♦ First check if Innodb is enabled or not. # mysqladmin variables | grep have_innodb...
MySQL optimization
MySQL OPTIMIZATION MySQL is a popular choice of database for use in web applications. Fully optimizing MySQL...
Disable port 3306 listening to server
Here goes the steps for disabling inbound MySQL connections to a linux server. ♦ Login to the server as root ♦...
How to backup and restore a mysql table from a database using mysql command
Here we are going to discuss about how to restore a few tables from a database to a new empty database, the key...
MySQL doesnt start
In some cases MySQL will not get restarted even if we run the init script to start/restart it. The issue is due...
How to setup MySQL temp directory on RAM disk?
Follow the below mentioned steps to setup MySQL temp directory on a RAM disk. Create a tmpfs directory : mkdir...