[Dan@TT]

Originally Posted by valdet

If I am not wrong, those are raw database backup files, so you cannot restore them from phpmyadmin, but only from SSH.

I think your hosting guys can do that restore pretty easily.

Regards,
Val.

It's a self administered sever. They refused to help.

Originally Posted by bobster65

Well, the first thing that I see that your .frm .MYI and .MYD are not located in its own database directory. Each DB managed by the MySQL Server has its own database directory. This exists as a subdirectory of the data directory. In your case, you have an RPM installed MySQL as the data directory is located at /var/lib/mysql so within that directory, you should have a folder for each database and within that specific DB folder is where those files should be located..

NOW, you mentioned that you "created a new mysql database with the same name like the old one" Is there now a Folder in the var/lib/mysql directory with that database name? if so, move all those .frm .MYI and .MYD files into that directory.

Did exactly this. Got no luck.

the .frm files are called Form Files. They describe the structure of the table (its Columns, column types, indexes and so forth)

the Data Files .MYD (MyISAM) OR .ISD (ISAM) contain the table's data -- that is, its rows

the Index files .MYI (MyISAM) OR .ISM (ISAM) contain the index trees from any indexes on the data file. The index file exists whenther or not the table has any indexes...


Let me know if you have a database sub folder for the new data base you created (or if there are any other sub folders in the /var/lib/mysql folder.

Yes , there is a single subfolder, my new emtpy database where I put the old files.

--------------- Added [DATE]1202759912[/DATE] at [TIME]1202759912[/TIME] ---------------



no, those are the actual files themselves that make up the database. Each table within a database exists as 3 files in the database directory (A Form File ie access.frm , a Data file ie access.MYD and a index file ie access.MYI)