Run all your tables thru this. Save the script as xinno_convert. As in
xinno_convert < foo.sql | mysql
Suposedly you can also alter a table to innodb. But that never worked
for me it just looped using cpu for days. So I made this script which
worked fine. Other than converting implicit locking is different. With
innodb it assumes your using transactions.
#!/usr/bin/perl
#convert all tables in a mysql dump to innodb
use strict;
while(<>) {
my $aline=$_;
if($aline=~/(\) TYPE=)[A-Za-z]*ISAM(.*)$/) {
$aline="$1INNODB;\n";
# ) TYPE=MyISAM COMMENT='Users and global privileges';
}
print $aline;
}
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
