Emergency ----- Database Emptied - Loss Everything - What can be done??

[peter.mathews]

First, Off I did post this in the newbie area, however I did not see this backup. So I apologize.

Here is my issue:

I have ran a script in which I created a temporary table and dropped
the table at the end of the script. Unfortuantely not only was this
table dropped but all of the other tables in the database were dropped
as well.


Unfortuantely, the backups are made every day at midnight. So all of
the information for the past 23 hours has been currently destroyed.


What I need to know.


1. Is there anyway of recovering this data.
2. And 2 is this a common occurence with temporary tables. btw - I am
a newbie and more than open to being in the wrong.


Specs are as follows


Linux, Php, Apache, Mysq 4.1.10