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]