WampServer

yesterday my computer crushed(blue screen of death) and when i tried to use wamp today it didnt work.

where do i get the wamp errors?

i can get into localhoast main page,php work but mysql dosnt seem to work well.

i tried using backup and reinstall but that only worked for a few minuts.
in phpmyadmin i get " #2002 Cannot log in to the MySQL server ".

can you please help me i had importent stuff on that db.

In order to make it simpler to suggest answers to your problems:
Before asking a question please answer these.

1. Version of Operating system?
2. Version of Wamp Server installed?
3. Version(s) of Apache you have installed with WAMPServer?
4. Version(s) of MySQL you have installed with WAMPServer?
5. Version(s) of PHP you have installed with WAMPServer?

6. What colour is your WampManager icon? ( the in the system tray )
It could be Green, Orange or Red

7. Do you have a HOSTS file? [c:\windows\system32\drivers\etc\hosts]
Paste any entries relating to the domain [localhost] and any relating to your Virtual Hosts if that is relevant to your question.

8 . Have you tried to install Apache or MySQL or PHP some other way before trying WAMPServer?

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>
Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

ok i will give you all the information you ask for.

1.operating system is windows professional
2.Wampserver2.4-x64
3.Apache Version :2.4.4
4.MySQL Version :5.6.12
5.PHP Version :5.4.12
6.yellow
7.yes a 2kegbite file named hoasts
8.no thats why i use wamp.

the only thing i did once is to change the my.ini of mysql,is there a way to return to defult?
i fixd it once but maybe it returnd as beckup after the crush i have no idea what happend.

all i know is that i have to fix it, it happend in my office pc i cant format it, i dont know what happend.

will my error files help? where is wamps error files?


edit: also i fount this:

ERROR] InnoDB: Attempted to open a previously opened tablespace. Previous tablespace new/wp_ylinks uses space ID: 24 at filepath: .\new\wp_ylinks.ibd. Cannot open tablespace site_e/wp_y_bla which uses space ID: 24 at filepath: .\site_e\wp_y_bla.ibd
InnoDB: Error: could not open single-table tablespace file .\site_e\wp_y_bla.ibd
InnoDB: We do not continue the crash recovery, because the table may become
InnoDB: corrupt if we cannot apply the log records in the InnoDB log to it.
InnoDB: To fix the problem and start mysqld:
InnoDB: 1) If there is a permission problem in the file and mysqld cannot
InnoDB: open the file, you should modify the permissions.
InnoDB: 2) If the table is not needed, or you can restore it from a backup,
InnoDB: then you can remove the .ibd file, and InnoDB will do a normal
InnoDB: crash recovery and ignore that table.
InnoDB: 3) If the file system or the disk is broken, and you cannot remove
InnoDB: the .ibd file, you can set innodb_force_recovery > 0 in my.cnf
InnoDB: and force InnoDB to continue crash recovery here.



last edit:
solved!!!!!!!!!!!!!!!!

if anyone runs into the same thing.

go to
wamp icon->mysql->my.ini
open my,ini
and add this line.

innodb_force_recovery = 1

and then save restart services.



Edited 4 time(s). Last edit at 11/27/2013 06:29PM by adamrain.

Once its done the recovery you need to remove that setting.

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>
Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

thank you again.you dont know how much you helped me.

i ran into another problem and that solved it.