XFileSharing Pro - Script to convert XFS Pro MyISAM tables to Innodb

Message
Author
mrperl
Posts: 65
Joined: Mar 06, 2010 11:40 am

Script to convert XFS Pro MyISAM tables to Innodb

#1 Postby mrperl » Mar 06, 2010 12:40 pm

Hi folks.

I am doing some testing with XFS Pro and Innodb tables.

Seems to work so far, but more testing is needed.

Please do not use this if you rely on Alex for support or you are not
comfortable as a MySQL DBA.

Enjoy, mrperl.

Code: Select all

-- File: xfspro-convert-1.7.sql.txt
-- Purpose: Convert XFS Pro 1.7 tables to Innodb table type for
-- experimentation and testing
-- Date: 2010-03-06
-- License: Public Domain

-- specify your database name here ...
use xfs;

alter table Comments engine=innodb;
alter table DelReasons engine=innodb;
alter table Files engine=innodb;
alter table Folders engine=innodb;
alter table IP2Files engine=innodb;
alter table IP2RS engine=innodb;
alter table News engine=innodb;
alter table Payments engine=innodb;
alter table Reports engine=innodb;
alter table Servers engine=innodb;
alter table Sessions engine=innodb;
alter table Stats engine=innodb;
alter table Stats2 engine=innodb;
alter table Torrents engine=innodb;
alter table Transactions engine=innodb;
alter table UserData engine=innodb;
alter table Users engine=innodb;