first, search if you have bin files in apache folder somewhere, and use a bin tool
mysql\bin\mysqlbinlog.exe with a parameter:
mysqlbinlog.exe the_logfile_name_here >query.sql
that make an export that file.
Something you might probe:
lets go to the apache\mysql\data folder, and use a revovery tool (search for it on internet)
becouse you file and content after dropping a table does not deleted (mybe you cant see that, but the data could revovarable.)
these the files you must search. but evry command on the drive cuts the chance to recovery your datas..
.frm
.MYD
.MYI
With those file you could do a data recovery into your database.
djjjozsi;10890327 wrote://from the internet//
ye there is two way of restoration:
backup files from your database
binary logs, which files are in form of <host_name>-bin.00001
by every update on your database the extension will be incremented
by 1. then the greatest value is the latest one.
binary logs save the all statements that have effect on change of
database like insert, delete, etc. but you should be careful in executing
binary log and delete the drop statements in case of existent.
binary logs are accessible only in case of active status, its means is it
must be active before dropped database.
the command for database recovery with using binary log is:
mysqlbinlog the_log_file > update.sql
