Hello.

On Mon 2002-12-09 at 20:35:53 +1100, [EMAIL PROTECTED] wrote:
> Great idea, but everything I think I need was done with POST, and it
> appears my host doesn't have the most detailed logs :)
> 
> I can't see anything I can use in the log file they've given me, but I'll
> keep looking.

I am sure he meant MySQL update logs. But it's questionable if your
provider has enabled them (they make everything a bit slower and need
a lot of space). If the update logs reach back far enough, one can
reconstruct a database with it, by re-running all queries.

There is still (some) data left in the tables, if no other changes
were made afterwards. But trying to recover the data is a cumbersome
way to go and you should only try it if the data was really important
(in that case, I would write MySQL AB support and ask them directly),

How much is left depends on the table handler type and if you used
MYISAM, it depends on the storage type (static vs. dynamic rows). If
you had any VARCHARs, it was dynamic and more data will be lost. If
you forgot the WHERE clause in the DELETE statement, the table file
will have been deleted and nothing is left.

Bye,

        Benjamin.

-- 
[EMAIL PROTECTED]

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to