Hello,
I need fast help. My .frm-files are deleted on MyIsam MySQL. The other two files types (myd and myi) of each table are still there but the frm-files are deleted. The database does not work any more.
How can i reconstruct the database with the two types to save everything.
I assume you don't have the .frm files in a backup somewhere?
1. Determine why the .frm files got clobbered, so you can prevent it from happening again. 2. Make a backup of the .MYD and .MYI files, in case of a mistake during the following steps. 3. For each table to be restored, follow this procedure: a. In the shell, rename the .MYD and .MYI files. For example: mv x.MYD x.MYD.orig mv x.MYI x.MYI.orig b. In the mysql program, issue the *exact* CREATE TABLE statement that will create a table with the same structure as the to-be-restored table. If you don't know what this statement is, you're out of luck. c. In the mysql program, issue a FLUSH TABLES statement. d. In the shell, rename the file from a. back to their original names: mv x.MYD.orig x.MYD mv x.MYI.orig x.MYI Table x should now be restored. Repeat for the other tables.
-- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]