RE: migrate data from myisam to innoDB

2003-09-18 Thread Hsiu-Hui Tseng
, September 18, 2003 10:05 PM To: Hsiu-Hui Tseng; [EMAIL PROTECTED] Subject: Re: migrate data from myisam to innoDB Hsiu-Hui Tseng wrote: >Hello, > >I migrated all my tables to innoDB from MyIsam. After migrated, I ran "Show >TAble Status". Why the row count is chan

Re: migrate data from myisam to innoDB

2003-09-18 Thread Daniel Kasak
Hsiu-Hui Tseng wrote: Hello, I migrated all my tables to innoDB from MyIsam. After migrated, I ran "Show TAble Status". Why the row count is change. In MyIsam table status.rows = 316202 the new InnoDB table status.rows = 287341 When doing select count(*) from TABLE. I go 316202 rows. Why this hap

migrate data from myisam to innoDB

2003-09-18 Thread Hsiu-Hui Tseng
Hello, I migrated all my tables to innoDB from MyIsam. After migrated, I ran "Show TAble Status". Why the row count is change. In MyIsam table status.rows = 316202 the new InnoDB table status.rows = 287341 When doing select count(*) from TABLE. I go 316202 rows. Why this happening? Is there any