hi
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,t ablename.myd and
tablename.frm
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.
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,t ablename.myd and
tablename.frm
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.