MySQL Forums
Forum List  »  Newbie

Re: Need Help - Troubleshoot Connection Problems
Posted by: Jay Friedman
Date: August 30, 2015 07:31PM

Here's the error message I get when trying to do a mysqldump:
Got error: 1286: Unknown table engine 'InnoDB' when using LOCK TABLES

Here's the error/warning message from the mysql.log:
InnoDB: Warning: difficult to find free blocks from
InnoDB: the buffer pool (52968 search iterations)! Consider
InnoDB: increasing the buffer pool size.

The VPS has 2GB, right now there is 1.4GB free. I don't know how mysql allocates memory.

Versions: Ver 14.14 Distrib 5.1.73, for redhat-linux-gnu (x86_64) using readline 5.1

Note: in show variables:
| have_innodb | NO |
but it was running fine before.

Options: ReplyQuote


Subject
Written By
Posted
Re: Need Help - Troubleshoot Connection Problems
August 30, 2015 07:31PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.