Re: Need help in recreating .MYD files

2006-05-11 Thread Pradeep Chandru
hi, 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

Re: Need help in recreating .MYD files

2006-05-10 Thread balaraju mandala
*Ok Daniel,* ** * Thank you.* ** *regards,* *bala* **

Re: Need help in recreating .MYD files

2006-05-09 Thread Dilipkumar
Hi, please tell me the server uptime and also the master logs as show master logs; in mysql prompt. Yes u can restore data from the binlog if you have the binlogs. balaraju mandala wrote: Hi Dilip, it means i loosed the data, correct Dilip. is there any other way to gain that data, any

Re: Need help in recreating .MYD files

2006-05-09 Thread balaraju mandala
Hi Dilip, I got two binary logs in Server. I don't know how to find server uptime? mysql show master logs; +--+ | Log_name | +--+ | localhost-bin.08 | | localhost-bin.09 | +--+ 2 rows in set (0.00 sec) if i ask for

Re: Need help in recreating .MYD files

2006-05-09 Thread Daniel da Veiga
On 5/9/06, balaraju mandala [EMAIL PROTECTED] wrote: Hi Dilip, I got two binary logs in Server. I don't know how to find server uptime? mysql show master logs; +--+ | Log_name | +--+ | localhost-bin.08 | | localhost-bin.09 |

Re: Need help in recreating .MYD files

2006-05-09 Thread balaraju mandala
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. regards, bala

Re: Need help in recreating .MYD files

2006-05-09 Thread Daniel da Veiga
On 5/9/06, balaraju mandala [EMAIL PROTECTED] 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

Need help in recreating .MYD files

2006-05-08 Thread balaraju mandala
Dear Comunity, I need your help. I accidently deleted some '.MYD' files. I want to restore them, without stopping the running server. how i can do this. i am using Linux OS, i tried to create file using --- vi tablename.MYD(a blank file) but it is not accepted by MySql. regards, bala

Re: Need help in recreating .MYD files

2006-05-08 Thread Dilipkumar
Hi, If you have deleted .MYD files then truncate the table and restore it from the backup if yu have. MYD means your precious data which contains. balaraju mandala wrote: Dear Comunity, I need your help. I accidently deleted some '.MYD' files. I want to restore them, without stopping

Re: Need help in recreating .MYD files

2006-05-08 Thread balaraju mandala
Hi Dilip, it means i loosed the data, correct Dilip. is there any other way to gain that data, any binary logs etc? regards, bala