You can't actually move innodb tables around until 5.6 where you have transpotable tablespaces.
I suggest having a good hard look at pt-online-schema-change or whatsitcalled. Jay Ess <li...@netrogenic.com> wrote: >On 2013-06-26 18:31, nixofortune wrote: >> What would be the best way to convert BIG MyISAM table into InnoDB? >We do not >> have SLAVE. > >I would do it on another computer. Then copy the table to the server >and then >add the data that has been added from the original table. > >And/or i would experiment with TokuDB. I havent had the time to do it >myself but >will probably soon. I am too looking for a lengthy 1 billion+ row >conversion. -- Sent from Kaiten Mail. Please excuse my brevity. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql