mrperl
Joined: 06 Mar 2010
Posts: 35
|
 Posted: Mar 06, 2010 12:40 pm Post subject: Script to convert XFS Pro MyISAM tables to Innodb |
 |
|
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: |
-- 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;
|
|
|
Register
Search
Profile
Log in to check your private messages
Log in
