On 11/8/2012 09:29, Paul J Stevens wrote:
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.
thanks for your reply paul ;-)
so i did have a look at what you suggested but i only end up being more
confused.
dumped my original 1.2 database with all the migration scripts done
setup another test database with a fresh create_tables.mysql
dumped the structure of both db's and did a diff ...
.... only to find out that the freshly created test db doesn't contain
the table dbmail_messageblks, where all the messages are stored.
which is sort of really strange with a fresh database create from the
newest 3.0.2 package
in folder /sql/mysql/create_tables.mysql
or is there another script I need to run to get the complete database
structure?
getting really confused ...
but did send a few testmail to the migrated database and dbmail didn't
throw an error
also used the dbmail-pop3d without any problems ...
does this mean my migrated database is ready to go, though it still
shows a few differences when comparing with diff
any help would be really great ;;-)
thanks a million & all the best
greetings
becki
_______________________________________________
DBmail mailing list
[email protected]
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
