Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Recover deleted MySQL records?
Message
From
23/01/2007 12:10:08
Mike Yearwood
Toronto, Ontario, Canada
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MySQL
Miscellaneous
Thread ID:
01188180
Message ID:
01188191
Views:
27
>>>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
Map
View

Click here to load this message in the networking platform