[SOLVED] mysql .MYD .MYI are missing

ilvista · 04-04-2011, 08:58 AM

hi

I've mysql server running ,and i have one single database. everything is working fine but I cant find .MYD and .MYI of one of my tables .and now when i tried to make a backup mysqldump fails because .MYI et .MYI are not found.

I tried locate my_table.MYD my_table.MYI
BUT no chance

any help will be appreciated.
thx

chickenjoy · 04-04-2011, 09:05 AM

try the find command instead

Code:

# find / my_table.MYD my_table.MYI

locate relies on a database itself that (most often) is not updated.

ilvista · 04-05-2011, 05:52 AM

thx for the reply.

I figured it out !!!!!!

I'm using InnoDB engine ,i didn't know that it doesn't need .MYD and .MYI.
in the contrary MyISAM use .MYD and .MYI .

Best regards

chrism01 · 04-05-2011, 08:21 PM

InnoDB is the RRDBMS engine (think Oracle), whereas MyISAM is Indexed Sequential Access Method i.e. indexed flat files; a completely different and non-relational engine.
That's why it uses different files.

ilvista · 04-06-2011, 03:07 AM

thanks for the useful clarification.

Best regards