Some of MySQL databeses has no MID and MIY

[FarshidG]

Hi,

I had a problem with my MySQL Server on my Windows Server 2008. after fixing the issue, Some of my databases has just .frm files and no .MID and .MIY!!!

my questions is:

1. Is there a special folder that I should look for them?
2. What is the C:\Program Files\Parallels\Plesk\MySQL\Backup\sql-DATE.zip files? Is it a daily backup folder for MySQL databases? and if so, how can I use it for restore my databases files?

Regards,

[rackset]

It maybe those db's use InnoDB engine, which have it's own structure. (default is all in one file)

[FarshidG]

No, They are all MySQL. I'm sure.

[BrunoMiguel]

FarshidG, you have two major engines within MySQL: MyISAM and InnoDB. Is a table is InnoDB, you will just have .FRM files.

[FarshidG]

Unfortunately it is MyISAM.

[BrunoMiguel]

In that case, you can try to repair all data databases:

> %plesk_dir%\Databases\MySQL\bin\mysqladmin.exe -u admin -p --repair --all-databases