Merge multiple databases into one

[chstoltz]

I am running ejabberd with multiple vhosts, each using its own MySQL database in the "Default Schema".
My plan is to migrate each database to the "New Schema" and then merge them into a single database.

I have identified so far six tables (archive, privacy_list, privacy_list_data, pubsub_item, pubsub_node, pubsub_state) that use auto-increment indexes. When merging, there is a risk of collisions.

One approach I considered is offsetting the IDs before merging. For example, if the IDs are currently all four digits, adding 100,000 to the IDs in the first database, 200,000 to the second, and so on. Would this work, or is there a better way to do this?

[badlop]

I was about to propose using export_piefxis_host and then import_piefxis.

But if you have many many accounts, maybe your idea runs faster.

[chstoltz]

Thank you very much. I think I'll take your approach, even though MAM isn't part of the export (and doesn't have to be, according to XEP 0227).