Welcome Guest. Please Login or Register  


You are here: Index > AMPPS > General Support > Topic : MySQL doesn't start on PC



Threaded Mode | Print  

 MySQL doesn't start on PC (10 Replies, Read 30584 times)
Nexus
Group: Member
Post Group: Newbie
Posts: 7
Status:
Hi,
I've been having a problem with my AMPPS since yesterday. While the Apache starts as normal, Mysql refuses to start up.
Can't think of anything that might have caused this.
I'd very much appreciate your help.
IP: --   

MySQL doesn't start on PC
ketan
Group: Member
Post Group: Working Member
Posts: 241
Status:
Hi,

Which OS you are using?


-----------------------
Follow AMPPS on,
Twitter
Facebook
Google+
IP: --   

MySQL doesn't start on PC
Nexus
Group: Member
Post Group: Newbie
Posts: 7
Status:
Hi Ketan,
I'm using XP pro. with AMPPS 2.3.
IP: --   

MySQL doesn't start on PC
ketan
Group: Member
Post Group: Working Member
Posts: 241
Status:
Hi,

Please attach the MySQL error logs(path\to\Ampps\mysql\data\"your-hostname".err) here.

Note: "path\to\Ampps" here means Ampps installation directory,
for eg: "C:\Ampps"

-----------------------
Follow AMPPS on,
Twitter
Facebook
Google+
IP: --   

MySQL doesn't start on PC
Nexus
Group: Member
Post Group: Newbie
Posts: 7
Status:
Hi Ketan,
Please find the file attached.
The last entry is for way back in July though.
IP: --   

MySQL doesn't start on PC
Nexus
Group: Member
Post Group: Newbie
Posts: 7
Status:
Ketan,
The forum didn't accept the .err file so please find it in .txt form.
I was wrong about the last entry date in my previous psot. It is up to date.
IP: --   

MySQL doesn't start on PC
Nexus
Group: Member
Post Group: Newbie
Posts: 7
Status:
Here is the file!
IP: --   

MySQL doesn't start on PC
tidus
Group: Member
Post Group: Super Member
Posts: 1121
Status:
Hi,

First take a backup for Ampps\mysql\data folder.

Now in Ampps\mysql\data folder remove the files :
mysql-bin.index
mysql-bin.000001
mysql-bin.000002
and so on...

Delete only these files. And try starting MySQL server then.

Let us know if you are still facing the issue.


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

MySQL doesn't start on PC
Nexus
Group: Member
Post Group: Newbie
Posts: 7
Status:
Brilliant!
Thanks a million tidus. It worked.
Is it likely to see the files I deleted, generated again? Should I regularly delete these files?
Best wishes.
IP: --   

MySQL doesn't start on PC
tidus
Group: Member
Post Group: Super Member
Posts: 1121
Status:
Hi,

No. Don't delete them.

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

MySQL doesn't start on PC
Nexus
Group: Member
Post Group: Newbie
Posts: 7
Status:
Thanks again.
IP: --   

« Previous    Next »

Threaded Mode | Print  



Jump To :


Users viewing this topic
1 guests, 0 users.


All times are GMT. The time now is May 16, 2024, 9:07 am.

  Powered By AEF 1.0.8 © 2007-2008 Electron Inc.Queries: 10  |  Page Created In:0.035