Help - Search - Members - Calendar
Full Version: MySQL help
Neowin Forums > *nix Customization & Support > Linux Server/BSD/Unix
huw
What is the easiest way to convert a table and its contents from myisam to Innodb?

Preferably using the Mysql administrated but the mysql console will do!

Thanks
b0b
ALTER TABLE `database`.`table` TYPE = InnoDB;

^^^ SQL query.
Make sure you have the `` symbols in your query.
huw
Ok thanks
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2009 Invision Power Services, Inc.