need help with CREATE TABLE [newtbl] SELECT * FROM [oldtbl]

[Chris Newman]

Hi,

I am having trouble trying to create a new table that is a duplicate of an old table.

I executed the command "create table t2 select * from t1;" The t1 table is ~150Mb. In addition to the mysql> window, I had an xterm open so I could watch the t2 table in the filesystem as it was being built. Over the course of about 3 minutes the new t2 table grew to exceed 1.8 Gb at which point I had to abort the process to keep it from filling up the partition. Why is mysql creating a table that is over an order of magnitude greater in size than the original?

Any help would be appreciated.

Thanks,

Chris