An SQL Injection is a method in which the attacker intentionally gains access to all the information containing in the...
How do I find mysql root password in Ensim server?
Ensim was a popular control panel usually installed on linux servers as well as windows servers. Here is the command...
Steps to restore an innodb database
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...
Mysql database size not showing in cpanel
You may see the mysql database size is zero in cPanel >> Mysql Databases, though the databases contains tables...
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...
Databases missing in cPanel
In some cases cPanel will not show the databases in cPanel>>Databases>>MySQL database; though the...
InnoDB
MyISAM and InnoDB are two most commonly used storage engines of MySQL database. However, MyISAM is the default...
Remove e-mail accounts in plesk server
There might be instances when the removal of email accounts from frontend fails in plesk control panel. One of the...
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...