How to enable INNODB in mysql

by

I faced a similar situation where InnoDB got disabled after a mysql-server upgrade. The query “show engines” didn’t display Innodb. Following this link fixed the issue for me.

    /etc/init.d/mysql stop

    cd /var/lib/mysql/

    ls ib_logfile*
    mv ib_logfile0 ib_logfile0.bak
    mv ib_logfile1 ib_logfile1.bak

    /etc/init.d/mysql restart

More Related Contents:

  1. How to debug Lock wait timeout exceeded on MySQL?
  2. MySQL AUTO_INCREMENT does not ROLLBACK
  3. Restore table structure from frm and ibd files
  4. How to convert all tables from MyISAM into InnoDB?
  5. MySQL : transaction within a stored procedure
  6. When to use SELECT … FOR UPDATE?
  7. Difference between SET autocommit=1 and START TRANSACTION in mysql (Have I missed something?)
  8. How to regex in a MySQL query
  9. “Unknown column in ‘field list'”, but column does exist
  10. Which DB technology is sued to solve the following search issue? [closed]
  11. MySQL pivot row into dynamic number of columns
  12. Delete all Duplicate Rows except for One in MySQL? [duplicate]
  13. MySQL – Operand should contain 1 column(s)
  14. How to get the difference in years from two different dates?
  15. What’s the difference between MyISAM and InnoDB? [duplicate]
  16. mysql pivot/crosstab query
  17. MySQL: Split comma separated list into multiple rows
  18. UNION query with codeigniter’s active record pattern
  19. Remove Primary Key in MySQL
  20. Get most recent row for given ID
  21. Is merge statement available in MySQL
  22. Mysql covering vs composite vs column index
  23. MYSQL syntax not evaluating not equal to in presence of NULL
  24. Mysql insert random datetime in a given datetime range
  25. Storing IPv6 Addresses in MySQL
  26. Insert/ Update random date in MySQL
  27. Replace null with 0 in MySQL
  28. Get total hours worked in a day mysql
  29. Should I always prefer MySQL InnoDB over MyISAM?
  30. mySQL query to search all tables within a database for a string?

Leave a Comment