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…

0

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 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…

0

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…

0