Some of MySQL databeses has no MID and MIY
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?
Apr 26, 2012, 06:35 AM
It maybe those db's use InnoDB engine, which have it's own structure. (default is all in one file)
Apr 28, 2012, 06:35 AM
No, They are all MySQL. I'm sure.
Apr 30, 2012, 03:29 AM
FarshidG, you have two major engines within MySQL: MyISAM and InnoDB. Is a table is InnoDB, you will just have .FRM files.
Apr 30, 2012, 04:19 AM
Unfortunately it is MyISAM.
Apr 30, 2012, 04:29 AM
In that case, you can try to repair all data databases:
> %plesk_dir%\Databases\MySQL\bin\mysqladmin.exe -u admin -p --repair --all-databases
Tags for this Thread