MySQL

January 22, 2016
Published by ndzadmpanel on January 22, 2016
Categories

SQL syntax or access violation error while running joomla xmlImport.php file

Error: SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED […]
Do you like it?0
0 Read more
August 16, 2014
Published by ndzadmpanel on August 16, 2014
Categories

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 “sandbox” instance  using the innodb files and the […]
Do you like it?0
0 Read more
August 16, 2014
Published by ndzadmpanel on August 16, 2014
Categories

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 performance. Optimizing the database will essentially defragment […]
Do you like it?0
0 Read more
September 25, 2013
Published by ndzadmpanel on September 25, 2013
Categories

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 can reset the root password for […]
Do you like it?0
0 Read more
August 22, 2013
Published by ndzadmpanel on August 22, 2013
Categories

Performance Tuning Scripts for Mysql

  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 […]
Do you like it?0
0 Read more
August 17, 2013
Published by ndzadmpanel on August 17, 2013
Categories

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 password in an […]
Do you like it?0
0 Read more
July 25, 2013
Published by ndzadmpanel on July 25, 2013
Categories

InnoDB

  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 […]
Do you like it?0
0 Read more
July 21, 2013
Published by ndzadmpanel on July 21, 2013
Categories

Enable Innodb in cPanel server

To Enable innodb in cpanel server♦ First check if Innodb is enabled or not. # mysqladmin variables | grep have_innodb ( To check Innodb enabled or not ) […]
Do you like it?0
0 Read more
July 20, 2013
Published by ndzadmpanel on July 20, 2013
Categories

MySQL optimization

  MySQL OPTIMIZATION MySQL is a popular choice of database for use in web applications. Fully optimizing MySQL takes both time and effort since every application […]
Do you like it?0
0 Read more
12
Next page
ENQUIRE NOW
[]
1 Step 1
reCaptcha v3
keyboard_arrow_leftPrevious
Nextkeyboard_arrow_right