Just to add up i have read some where ( i assume in the mailing list
only) that OS recognizes the file based on few codes added at the
starting / ending of a file. So there are ways to create a MYD file
through vi editor as well (this is not from the angle of restoring the
data in that table). As Daniel said if there is no binlogs/ update /
query logs there is no way of restoring data to the current date.
MySQL DBA, Cricinfo Pvt Ltd.
Daniel da Veiga wrote:
> On 5/9/06, balaraju mandala <balaraju.mandala@stripped> wrote:
>> Thank you Daniel for reply.
>> Just in curiocity i want ask u, how u r taking daily backups, just using
>> 'mysqldump' or using any Tools.
> I'm using mysqldump plus bzip2 to compress data for about 2 years now.
> Tried many tools, mysqldump scripted in bash (linux) or even in .bat
> (windows) was always better than any other tools.
> Daniel da Veiga
> Computer Operator - RS - Brazil
> -----BEGIN GEEK CODE BLOCK-----
> Version: 3.1
> GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
> PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
> ------END GEEK CODE BLOCK------