An SQL Injection is a method in which the attacker intentionally gains access to all the information containing in the database through a set of SQL […]
Below are the steps to restore mysql database with innodb tables , without contacting r1soft. Set up a temporary mysql “sandbox” instance using the innodb files and the […]
Over a time as your website add contents to it’s database, the files/tables will become fragmented resulting in slower performance. Optimizing the database will essentially defragment […]
One of the common issue encountered by server admins while manging mysql is that, the root passwords are unknown. We can reset the root password for […]
Performance Tuning Primer Script is the shell script which gets performance related information from MySQL engine and produce some recommendations for tuning of MySQL server […]
In some cases cPanel will not show the databases in cPanel>>Databases>>MySQL database; though the database is present in /var/lib/mysql/ folder with the contents in it, […]
MyISAM and InnoDB are two most commonly used storage engines of MySQL database. However, MyISAM is the default storage engine chosen by MySQL database, when […]