> You can set the default storage engine on each of the servers and then > don't declare it explicitly in any CREATE TABLE statements.
This seems like the most viable option. Since almost all of the remote tables are created with INNODB it should work fine. I do have one table that isn't but we will convert that before we slave the data to this box. The big problem is test existing dataset is more than 10gb (across several tables/databases). So other suggestions to just recreate the tables by not specifying the engine type isn't particle at this time (but if done at initial design time, we would have been fine). -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
