Howto migrate existing data to a fresh install

[Benny DeH]

Hi all,

could anybody suggest a procedure how to migrate all data from an existing install to a new system. The configuration will be done from the ground up.

Is it as simple as stopping the current instance, dumping the MySQL database and importing on the new server, copying the archive folder. Starting the new instance, configure, rebuild the index?

Thanks,

Benny

[Rimser]

Did you see this?

https://support.microfocus.com/kb/doc.php?id=7021031

[Benny DeH]

@Rimser, thank you for your reply.

I wasn't aware of that document. It largely covers what I want. But, you knew there was one coming 🙂 , it also copies the configuration. Is there a way to just load the data in a new instance and really configure everything from scratch?

I'm looking more for an export and subsequent import.

I need to document all configuration and want to use it as an test set.

Is there any configuration stored in the same database as the message archive? Or is everything stored in ASconfig? I read through ASconfig but saw no module configuration nor jobs.

Thanks,
Benny

[Rimser · Accepted solution]

@Benny DeH 

you can give it a try. You need a dump of the database (that's easy - even possible to migrate to postgres) and of course the large archive directory.

I did several migrations. In most cases using rsync to copy; therefore I can run synchronization til the final day. And dumping the database - in one case this database has been migrated from local install into a central large mysql environment. In another case Oracle will be used in the background.

Using the configuration directories is not really bad. Otherwise you have to create and upload bootstrap files (=configuration files); maybe even a trusted key if you do not have a copy. So it will be more work and you have to prepare more precisely. 

[Benny DeH]

@Rimser ,

thank you for your help I'll give it a shot and let you know in time. Will be in the new year. I understand this more work but that's intended.

Last question in the current installation retain is placed on a single disk. Some default filesystems and the suretain app, data and mysql is placed in /var/opt/beginfinite/Retain as ext3 fs. I would like to split mysql off into a separate FS as well as the on disk archive. Do you have any suggestions for possible further segmenting as well as mount options? 

Thank you all for the help for the newbie,

Benny.

[Rimser]

No, that's my way too, @Benny DeH 

A disc for data (/data) to hold archives and more. Another disc for /var.

Sometimes I move the database and all other Retain stuff to /data (a single spot easy to migrate to the next server 😊), sometimes databases are on a separate disc or even separate server. It depends on local rules.

[Benny DeH]

Thanks, any special mount options? I always like to turn atime off and relatime off as well if possible. Do you recommend XFS?
Does everything needs to placed in the same hierarchy as the stock install?

[Rimser]

Now I am in the mood to use XFS ...

Turning off atime and so on is smart because you do not use it.

I prefer suggested hierarchies in case of troubles. So it is easier to help support to support you and me ...