Re: Converting table types
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 technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Converting table types
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 with this. -- Greg Macek | Senior IT Manager Marketing Resources, Inc. Email: [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Converting table types
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 type is still showing MyISAM. 1. Is my syntax correct on this? 2. Is there a way to list table types installed in a system? I do have php installed , there, if that helps. Carl - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Converting table types
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| | have_ssl | NO| +---+---+ 6 rows in set (0.00 sec) mysql Looks to pretty clear like it ain't there. Carl On Sun, 7 Apr 2002, Paul DuBois wrote: At 20:23 -0400 4/7/02, Carl Schmidt wrote: 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 type is still showing MyISAM. 1. Is my syntax correct on this? Yes, but MySQL won't complain if you alter a table to a type that isn't available. 2. Is there a way to list table types installed in a system? I do have php installed , there, if that helps. SHOW VARIABLES LIKE 'have\_%' will show many of them. MyISAM doesn't show up in the list; it's always available, from MySQL 3.23 on. Carl - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php