This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Howto migrate existing data to a fresh install

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  

    Use "Verified Answers" if your problem/issue has been solved!

  • 0 in reply to   
    , 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
  • Verified Answer

    0   in reply to 

     

    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. 


    Use "Verified Answers" if your problem/issue has been solved!

  • 0 in reply to   

     ,

    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   in reply to 

    No, that's my way too,  

    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.


    Use "Verified Answers" if your problem/issue has been solved!

  • 0 in reply to   
    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   in reply to 

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


    Use "Verified Answers" if your problem/issue has been solved!