Kelvin,
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
else
Rollback
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....
>
>Thanks.
>Kelvin.
>
>
>"Kelvn" <[EMAIL PROTECTED]> wrote in message
>[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > 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 (http://www.php.net/)
>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 (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
