Search code examples
mysqlselectubuntu-server

Can't access table in mysql even though it exists

I'm having trouble while trying to select anything on my database. If I try:

SELECT * FROM wp_options;

it even autocompletes wp_options if I hit tab while writing it, but then I get the following error:

ERROR 1146 (42S02): Table 'foo.wp_options' doesn't exist.

The table even shows when I do "show tables". All other databases are working fine. This is the only one I'm having trouble with.

I'm currently running the mysql-server on Ubuntu Server 14.04.

Solution

  • I managed to fix it. The database was using InnoDB as the engine. Copying the old ib_logfile and ibdata files to /var/lib/mysql fixed it.