frm

How do you deal with visual basic 6 frm and frx files in source control?

This is always a pain no matter what source control system I have used (source safe, cvs, clearcase...) the binary .frx files always cause a problem when merging visual basic forms. I know...I know...why are you using Visual Basic...because there are lots of legacy apps still written using it and although I hate to admit it I actually l...

InnoDb doesn't create .frm file, error 1005, errno 150

Create table returns error Can't create table './Identity/Roles.frm, however it does create Roles.ibd file. CREATE TABLE IF NOT EXISTS `Roles` (`role` VARCHAR(25) NOT NULL , PRIMARY KEY (`role`) ) ENGINE = InnoDB DEFAULT CHARACTER SET = utf8 I can create table using MyISAM but not innodb. I also tryed to copy frm+ibd files from anoth...

MySQL table recovery from crashed server

I managed to wipe a server by mistake but PhotoRec was kind enough to recover the .frm and .myi files from the hard drive. I now have a desktop set up with the same version of MySQL to recover the data but my question is: what do I do? I have about 160 of these files. I haven't yet reinstalled the server in case I need anything else. Al...

How can I recover MySQL tables from data files?

Hi All, I've got a database (all MyISAM tables) and the machine where MySQL was running is no longer bootable. However, we have all the MySQL data files from the data directory. How can I restore the data from the MYD and FRM files, or whatever other files I should be looking at in the data directory? I've been doing some searching o...