Page 1 of 1

How to update table timestamps without closing programme

Posted: Wed 31 Mar 2010 09:03
by NoComprende
Hi, within my application I've written code to back up only those tables in my database that have been changed. I'm only using MyISAM tables and I'm not using any cached updates on the TMyQuery or TMyTable components I'm using to make the changes. I've found I've got to close down the programme and restart it for the backup code to work as otherwise the timestamps don't change. In fact, after deleting some records, I had to reboot the machine to update the table timestamps.

I'm aware this may be nothing to do with the MyDAC components but can anyone tell me how to get MySQL to update the timestamps on any changed tables?

Posted: Wed 31 Mar 2010 10:19
by Dimon
MySQL server updates timestamp fields on every record updating.
Please give a more detailed description of the problem.

Posted: Wed 31 Mar 2010 15:13
by NoComprende
Sorry Dimon, I mean the windows file timestamp;

Posted: Thu 01 Apr 2010 14:04
by Dimon
This behaviour is connected with the specificity of work of MySQL server and it does not depend on MyDAC.

Re: How to update table timestamps without closing programme

Posted: Thu 01 Apr 2010 15:06
by NoComprende
NoComprende wrote:I'm aware this may be nothing to do with the MyDAC components but can anyone tell me how to get MySQL to update the window timestamps on any changed tables?

Posted: Sun 04 Apr 2010 15:42
by NoComprende
For anyone that's interested I think 'flush tables' solves the problem.