Re: [Postfixadmin-devel] Question re: changing db engine and character set...
Brought to you by:
christian_boltz,
gingerdog
From: David G. <da...@co...> - 2012-01-13 12:47:33
|
On 13 Jan 2012, at 12:37, Tanstaafl wrote: > 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? Yes. We don't use any full text indexes so there is no dependency on MyISAM. You probably can't just change the encoding type though (i.e. edit the dump file and push it back in). > > 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)? > No. Any utf-8 characters already in there will be stored in a weird encoding. If you have no existing UTF8 characters in your data then it would work. > Lastly, how to make sure that from now on, all databases default to > InnoDB and utf8? > Unknown. If you created your database from being empty then I could see it possibly being set to MyISAM. The normal upgrade.php routine should not change an existing table format - unless (for instance) we added functionality in which required a specific table format. David. |