[PHP-DB] MySQL table recovery.

2001-12-06 Thread Bruno Gimenes Pereti

Hello,

Is there a way to rollback a 'delete from table;' command in MySQL
3.23.36-1? Yes I did it... I pressed enter instead of backspace.
Did I lost my table content? I have no backup of this especific database.

PS: I didn't close the connection with the database yet.

Thank for any help, even if it's forget it, no way...

Bruno.


-- 
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]




Re: [PHP-DB] MySQL table recovery.

2001-12-06 Thread Jon Farmer

 Is there a way to rollback a 'delete from table;' command in MySQL
 3.23.36-1? Yes I did it... I pressed enter instead of backspace.
 Did I lost my table content? I have no backup of this especific database.
 
 PS: I didn't close the connection with the database yet.
 
 Thank for any help, even if it's forget it, no way...

If this was a transaction then you can rollback if not then forget it

Regards

Jon
--
Jon Farmer
Systems Programmer, Entanet www.enta.net
Tel 01952 428969 Mob 07763 620378
PGP Key available, send email with subject: Send PGP Key

- Original Message - 


-- 
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]




Re: [PHP-DB] MySQL table recovery.

2001-12-06 Thread Bruno Gimenes Pereti

Hi Jon,

Thank you. I don't even know how to work with transaction in mysql. No
problem, just more work. It is a table that store all comments done in my
site. It's also sent to my e-mail.

Thank's again.

Bruno.

- Original Message -
From: Jon Farmer [EMAIL PROTECTED]
To: Bruno Gimenes Pereti [EMAIL PROTECTED]; PHP-DB
[EMAIL PROTECTED]
Sent: Thursday, December 06, 2001 8:41 AM
Subject: Re: [PHP-DB] MySQL table recovery.


  Is there a way to rollback a 'delete from table;' command in MySQL
  3.23.36-1? Yes I did it... I pressed enter instead of backspace.
  Did I lost my table content? I have no backup of this especific
database.
 
  PS: I didn't close the connection with the database yet.
 
  Thank for any help, even if it's forget it, no way...

 If this was a transaction then you can rollback if not then forget it

 Regards

 Jon
 --
 Jon Farmer
 Systems Programmer, Entanet www.enta.net
 Tel 01952 428969 Mob 07763 620378
 PGP Key available, send email with subject: Send PGP Key

 - Original Message -



-- 
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]