Backup is your friend, I hope you have one.

The only way you can implement a rollback is if you use transactions in 
your code. In general terms it works like this ...

Begin transaction
         SQL processing ,etc.
If no errors
         Commit transaction
End transaction

Transactions are not implicit except in more feature-rich databases such as 
PostgreSQL, DB2, MSFT SQL Server, etc., and then only if there is a system 
crash. When the database is restarted it reads it's system log and reseets 
itself to the state where the crash occurred.

This isn't what you wanted to hear.

How did you delete the database? Is it physically deleted from the disk? 
You may want to look beneath the MySQL ../var directory, in the directory 
containing your database. If it's there you may be able to rescue the 
records by some tricky text file maipulation. But that's a question for a 
MySQL list, not this one.

Very best of luck - Miles Thompson

At 12:54 PM 1/3/2002 -0500, you wrote:
>SomeOne Please Help....
>"Kelvn" <[EMAIL PROTECTED]> wrote in message
> > I have deleted the DB by mistake. Please I don't know how to write the
> > rollback statement.
> >
> > I need complete code from you guys.  Please Help Quick.
> >
> > Thanks
> > Kelvin.       ( I used PHP and MYSQL )
> >
> >
>PHP Database Mailing List (
>To unsubscribe, e-mail: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
>To contact the list administrators, e-mail: [EMAIL PROTECTED]

PHP Database Mailing List (
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to