Cadet 1st Class
Cadet 1st Class
378 views

Howto migrate existing data to a fresh install

Jump to solution

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

0 Likes
1 Solution

Accepted Solutions
Knowledge Partner Knowledge Partner
Knowledge Partner

@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. 

Diethmar Rimser
This community is more powerful if you use Likes and Solutions

View solution in original post

0 Likes
7 Replies
Knowledge Partner Knowledge Partner
Knowledge Partner

Did you see this?

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

Diethmar Rimser
This community is more powerful if you use Likes and Solutions
0 Likes
Cadet 1st Class
Cadet 1st Class
@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
0 Likes
Knowledge Partner Knowledge Partner
Knowledge Partner

@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. 

Diethmar Rimser
This community is more powerful if you use Likes and Solutions

View solution in original post

0 Likes
Cadet 1st Class
Cadet 1st Class

@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.

0 Likes
Knowledge Partner Knowledge Partner
Knowledge Partner

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.

Diethmar Rimser
This community is more powerful if you use Likes and Solutions
0 Likes
Cadet 1st Class
Cadet 1st Class
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?
0 Likes
Knowledge Partner Knowledge Partner
Knowledge Partner

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 ...

Diethmar Rimser
This community is more powerful if you use Likes and Solutions
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.