Unsupported Screen Size: The viewport size is too small for the theme to render properly.

How To Change Multiple Tables From Myisam To Innodb?

forums › forums › SQLyog › Using SQLyog › How To Change Multiple Tables From Myisam To Innodb?

  • This topic is empty.
Viewing 0 reply threads
  • Author
    Posts
    • September 6, 2007 at 4:39 am #10530
      JimZ
      Member

      I'm moving a number of databases from an old 3.23 server to a new MySQL 5.0 server by using SQLYog's 'Copy Database to Different Host/DB'. On the old server, all databases were using MyISAM, but I want to use InnoDB for most things on the new one. The copy operation creates the new tables using MyISAM, preserving the same engine as on the old server.

      Some of the databases have many tables that I need to change them from MyISAM to InnoDB. I can do this through SQLYog, but it's very tedious to do for more than a few tables. Is there some way that I can easily alter the storage engine of all of the tables within a database?

  • Author
    Posts
Viewing 0 reply threads
  • You must be logged in to reply to this topic.