On 11/07/2012 02:30 PM, Administrator Beckspaced.com wrote:
> hello again ;-)
>
> i'm currently doing a migration / update from dbmail 1.2.x to the most
> recent 3.x
>
> in the folder /sql/mysql i do see lots of migration scripts which sadly
> make me a bit confused ;-(
>
> if i look at all the scripts i perhaps should run in the following order ->
>
> migrate_from_1.x_to_2.0_innodb.mysql
> migrate_from_2.0_to_2.2.mysql
> 2_2-3_0.mysql
>
> to get to the most recent database structure ...
That *should* be enough, but please test to make sure:
dump the schema of your current database.
create two new databases, i.e. test1 and test2
load the 3.0 schema into test1
load the 1.2 schema into test2
load the migration scripts into test2
dump the schema of both in separate files and run a diff on them.
That should tell you if there are additional changes needed.
All the other migration scripts were for fixes in point releases, but
you might want to cherry pick them if additional changes are needed,
especially fix_foreign_keys might be necessary since 1.2 didn't use
foreign keys (myisam) whereas 2.2 and 3.0 won't work without them.
--
________________________________________________________________
Paul J Stevens pjstevns @ gmail, twitter, skype, linkedin
* Premium Hosting Services and Web Application Consultancy *
www.nfg.nl/[email protected]/+31.85.877.99.97
________________________________________________________________
_______________________________________________
DBmail mailing list
[email protected]
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
