forums › forums › SQLyog › Using SQLyog › Recovering From A Crashed Database
- This topic is empty.
-
AuthorPosts
-
-
August 26, 2014 at 12:34 am #13253TimothyPaulMember
Hi Folks – I had a MYSQL server crash. I do not have any backups that are working, but I do have the FRM files.
Is there a way to import them? Or at the very least see the table structure
Thank you….TP
-
August 26, 2014 at 11:05 am #35027peterlaursenParticipant
First of all, this is a support question for the MySQL server. In principle we support our own programs (SQLyog and MONyog) and not the MySQL server or any other program from Oracle (or any other vendor). We also do not provide any consultacy services for resolving such problems.
The .frm files do not contain any data. The only contain table definitions and similar. How data are stored depends on the storage engine used (MyISAM or InnoDB – find details here http://dev.mysql.com/doc/refman/5.5/en/storage-engines.html).
It is very unlikely you can solve this problem by just copying files around.
First of all you should ensure a copy of the complete ‘datadir’ (MySQL data folder) before doing anything else.
Also the term ‘crash’ can mean a lot of things. InnoDB has automatic crash- recovery (that will work in 99.99% of cases at least). So I assume that you are using MyISAM? In that case please refer mySQL documentation http://dev.mysql.com/doc/refman/5.5/en/myisam-repair.html.
But basically you should ask this another place, such as the MySQL Forums at http://forums.mysql.com/ for instance. And if somebody should be able to help you, you will have to be much more specific about the problem. What exactly hapenned. And what is now the problem? Will the server not start for instance? Also check the MySQL error log (http://dev.mysql.com/doc/refman/5.5/en/error-log.html) for details.
-
-
AuthorPosts
- You must be logged in to reply to this topic.