Softaculous

Topic : All my MySQL tables lost?

Posted By: thokkalodi on July 18, 2014, 11:04 pm

Hi,
After restarting my Mac yesterday night, all my MYSQL tables seem to be gone.
I'm getting an error similar to the following on all my sites

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'fadruptest.tstb_semaphore' doesn't exist: SELECT expire, value FROM {semaphore} WHERE name = :name; Array ( [:name] => variable_init ) in lock_may_be_available() (line 167 of /Applications/AMPPS/www/fadruptests/includes/lock.inc).

Also when I open PHPMyAdmin, I can see the table names on the right hand side column but on clicking on any of them, I get the fololowing error

#1146 - Table 'fadruptest.tstb_actions' doesn't exist

There are about ten sites that are present and it would be an aweful amount of work to restore them :(

I'm using Mac OS X 10.9.4 and AMPPS 2.4.

I'm including the mysql error log as an attachment.

Posted By: thokkalodi on July 18, 2014, 11:09 pm | Post: 1

My attachment of the log didn't work so posting the log here

Posted By: thokkalodi on July 22, 2014, 7:11 pm | Post: 2

Can someone please reply and tell me if there is a way to recover from this?

Posted By: tidus on July 23, 2014, 7:13 am | Post: 3

Hi,

Please refer this:
http://dba.stackexchange.com/a/16911

-----------------------
Follow AMPPS on,
Twitter : https://twitter.com/AMPPS_Stack
Facebook : http://www.facebook.com/softaculousampps
Google+ : https://plus.google.com/+AmppsStack