[Postfixadmin-devel] Question re: changing db engine and character set...

[Tanstaafl <tan...@li...>]

Hello all,

I have a question regarding converting the database engine used to 
InnoDB (currently MyISAM) and the character set to utk8 (currently 
latin1)...

Can I simply edit the dump file prior to restoring it? Ie, change the 
Engine in each of the table definitions from MyISAM to InnoDB?

Also - why does the engine keep getting reset to MyISAM? I have changed 
the tables to InnoDB before, but updates always change it back...

As for changing the character set from latin1 to utf8... can I do it the 
same way as described above (simply edit the dump file before restoring)?

Lastly, how to make sure that from now on, all databases default to 
InnoDB and utf8?

Thanks...