Posted By: j1mm1nycr1cket on May 5, 2014, 10:19 pm | Post: 1 |
Hmmm... wouldn't you just know it - I found a solution about 5 minutes after posting this.
OK, this is all within Windows 8.1 (for which I can only apologise) - so: Look for a little, tiny upward-pointing arrow at the right-hand end of the taskbar, the tooltip will say 'Show hidden icons' it should contain an icon for AMPPS. Right-click on that icon and you will see a list of options. From the top, choose Configuration > MySql and this will open Ampps > conf > my.ini (of course you can just browse to this file and open if for yourself but I didn't realise how many options there are hidden in this 'hidden icons' panel on the taskbar and if you didn't either, you just might find a lot of stuff that could prove useful later on) In my.ini, search for this: [mysqld] ...and directly below that, on a new line, put this: innodb_force_recovery = 1 save and close the file. You should find you can relaunch mySQL now. Follow the advice here: http://dev.mysql.com/doc/refman/5.0/en/forcing-innodb-recovery.html ...and start with a value of 1, increasing the value incrementally if it doesn't work straight away. If you can backup your .sql first, you should do so. It's possible that some of your tables could have lost some data so if you get mySQL back up, don't be surprised if you get slightly weird or broken data in some tables but at least you should now have mySQL running again. I think the moral of this story is to shut down AMPPS properly before you reboot your machine. Maybe someone can set me straight on that..? |
Posted By: tidus on July 1, 2014, 7:16 am | Post: 3 |
Hi,
Please open a ticket we will look into it. Also if you have a backup of your database, please try restoring it. ----------------------- Follow AMPPS on, Twitter : https://twitter.com/AMPPS_Stack Facebook : http://www.facebook.com/softaculousampps Google+ : https://plus.google.com/+AmppsStack |
Posted By: ketan on July 15, 2014, 6:36 am | Post: 5 |
Hi,
Below is the solution for the above issue: I hope you have a backup of the database. Add "innodb_force_recovery = 1" instead of "innodb_force_recovery > 0". Let us know if you are still facing the issues. ----------------------- Follow AMPPS on, Google+ |