Greg Macek [EMAIL PROTECTED] wrote:
I was wondering what happens when you change table types. Does MySQL
automatically get rid of the old table files?
Yes, MyISAM files are deleted. As for converting InnoDB - MyISAM, then
of course, InnoDB tablespace is not deleted, but freed.
--
For
Hello,
I was wondering what happens when you change table types. Does MySQL
automatically get rid of the old table files? I'm looking into changing
out some tables from MyISAM to InnoDB. I'm not tight on space, but I
wasn't sure how it handled the conversion, since the storage location
changes
I don't believe my web host has either InnoDB or BDB installed on their
system so I ran some tests here:
mysql alter table Development_EventType TYPE=INNODB;
Query OK, 3 rows affected (0.00 sec)
Records: 3 Duplicates: 0 Warnings: 0
That's the result I get, but when I do a table dump, the
Excellent, thanks much, that solved the problem:
mysql SHOW VARIABLES LIKE 'have\_%';
+---+---+
| Variable_name | Value |
+---+---+
| have_bdb | NO|
| have_gemini | NO|
| have_innodb | NO|
| have_isam | YES |
| have_raid | NO|
|