Mike Yearwood
Toronto, Ontario, Canada
General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Network:
Windows 2003 Server
>>>Does anyone know if it's possible to recover deleted records from a mySQL table - and if so, how do ya do it?
>>>
>>>Thanks!
>>
>>If MySQL is like SQL Server - No.
>
>That's what I thought...thanks.
Hi Victor
Please don't be offended if you already know this, but you may consider taking a similar approach in vfp and remote databases. When a record is deleted by a user, stamp it with a date/time. Then have a purging routine dump or even archive records that are older than x days.
In vfp, I so stamp "deleted" records and then I physically delete and pack them later. This empowers the users to recover things on their own.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only