Re: ibdata1 and *.ibd. Do I need both?

2005-12-14 Thread Paul DuBois
At 15:12 -0500 12/14/05, Nathan Gross wrote: Hi; A while ago, I changed most of my myisam based tables over to innodb. Fine. A while later, I noticed and implemented the option to keep the files separate. Now, weeks later, I still have a huge, 7 gig ibdata1, plus many *.ibd files. Can I delete

ibdata1 and *.ibd. Do I need both?

2005-12-14 Thread Nathan Gross
Hi; A while ago, I changed most of my myisam based tables over to innodb. Fine. A while later, I noticed and implemented the option to keep the files separate. Now, weeks later, I still have a huge, 7 gig ibdata1, plus many *.ibd files. Can I delete ibdata1? What worries me is that when I have new