Re: Re: Big Problem...Need Help Quick

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" <kelvin_y@decode-ent.com> wrote in message news:20020103162443.63476.qmail@pb1.pair.com... 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: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net