[EMAIL PROTECTED] wrote: > Your message cannot be posted because it appears to be either spam or > simply off topic to our filter. To bypass the filter you must include > one of the following words in your message: > > sql,query > > If you just reply to this message, and include the entire text of it in the > reply, your reply will go through. However, you should > first review the text of the message to make sure it has something to do > with MySQL. Just typing the word MySQL once will be sufficient, for example. > > You have written the following: > > Benjamin Pflugmann wrote: > > > I do not think that there is an really "elegant" solution. > > > > Greetings, > > > > Benjamin. > > > > Many thanks Benjamin, this is a helpful addition to my own thoughts. I'm > pleased that I can rule out using the logs. > > I also had the idea for a mirror/archive of each table, so I was pleased > to see it in your suggestion. I think that with this solution, the > process of making the copy does not interfere too much with the process > of updating the master. And, it is a bit more self-documenting than the > other methods, even if it uses more space. > > I'm only likely to have a few thousand records (though each may contain > a lot of text) which will change infrequently. I can leave it to the > module that retrieves old versions to work out exactly what changed and > when. > > Thanks again > > Richard > > / > \ Richard M Davis > / Digital Archives > \ University of London Computer Centre > / Tel: +44 (0) 20 7692 1350 > \ mailto: [EMAIL PROTECTED] > / > > > >
-- / \ Richard M Davis / Digital Archives \ University of London Computer Centre / Tel: +44 (0) 20 7692 1350 \ mailto: [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