Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Recover deleted MySQL records?
Message
De
23/01/2007 12:10:08
Mike Yearwood
Toronto, Ontario, Canada
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MySQL
Divers
Thread ID:
01188180
Message ID:
01188191
Vues:
28
>>>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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform