Re: Lost .frm files

2005-10-11 Thread Gleb Paharenko
Hello. Maybe this will help, if you're using MyISAM tables. Create a table with the same definition as a table from the backup has. Remove a new data file, and put a data file from the backup instead of it. Then use REPAIR. >I have changed the OS on my database server. At that time, I

Lost .frm files

2005-10-10 Thread Sujay Koduri
I have changed the OS on my database server. At that time, I forgot to take the backup of the .frm files in /var/lib/mysql. I have taken all the backup of all the data files. I can recreate all the tables. How can I map these tables to existing data files. Is this possible. Please help me out as th