migration from 1.8.1 to 1.8.3 with mysqldump

[hipikll]

Hi,
does enyone use the mysqldump utility to migrate all the configuration data from one installation to another?

On old server - run mysqldump to a file file.dump
Copy the file to another server.
On new zabbix server run mysql -u<user> -p<pswd> zabbix < file.dump

Via this way, it is possible to migrate also the maps with images, so it can reduce the time of full migration.

If anyone use it (migrate from older version to newer), please gimme any response, if it is fully working way and no problems can occure.

thanks

[whisky]

Hi,
does enyone use the mysqldump utility to migrate all the configuration data from one installation to another?

...

Via this way, it is possible to migrate also the maps with images, so it can reduce the time of full migration.

If anyone use it (migrate from older version to newer), please gimme any response, if it is fully working way and no problems can occure.

thanks

I will be intersted too as I'm planning the exact same migration and change
and as the file are say - BIG- having first hands experiments is nice ;-)

[hipikll]

do not migrate all of the tables from zabbix database. Then the file will be smaller.

Use mysqldump with the exact names of tables you want to dump (omit historical data tables).
mysqldump -u<user> -p<pswd> --hex-blob -r dump.file zabbix `cat tables.txt`

The migration is fine, but 1.8.3 version seems to be buged - export/import does not work at all.
I'd rather prefer to stay at 1.8.1 or will test 1.8.2.