Viewing 1 to 3 of 3 items
Tag Archives: innoDB

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 fil ebased backups of  the database and create a mysql dump of the database. 1. restore these files to a temporary directory  /dbrestore  /var/lib/mysql/ibdata1  /var/lib/mysql/ib_logfile0  /var/lib/mysql/ib_logfile1  (restore to “alternate  Full Article…



  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 creating a new table. The default engine is MyISAM which is very fast but does not support higher level functionality such as foreign keys or transactions. # mysql> SHOW  Full Article…


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 ) | have_innodb | No OR mysql> show engines; ♦ Edit the configuration file # vi /etc/my.cnf #skip-inndob ( comment the line to activate Innodb) ♦ Restart Mysql # /etc/init.d/mysql restart Set  Full Article…