size of ibdata1 not decreased even all tables are of MY ISAM type

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!


here is vishal.

i am using mysql as a backend for my web site and php as front-end.
i have created my tables of INNODB type previously and size of file
ibdata1 increased to 2 GB as my data is so much.

now i transfered all tables from INNODB type to MY ISAM type. so for
each table three files are created tablename.myi,tablename.myd and

but the size of file ibdata1 is not decreased from 2 GB which should be
decreased logically.

so what should i do to solve this problem. i mean to decrease size of
file ibdata1

thxs for your reply in advance.

Site Timeline