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

Moving Retain Data to New Disk

My current disk that holds my retain data and database is filling up and cannot be expanded, so I created a new larger disk that can be expanded if needed later.  I stopped retain and copied the data (took several days) from the smaller disk to the new larger disk, but the mysql.sock file won’t copy since linux says it is a “special file”.  The mysql.sock.lock file did copy.

Do i need this file? If not, can i just change the location of the data and reboot?  I have a ticket with support, but wanted a faster opinion.

Thanks in advance.

  • 0  

    Did you stopped DB ?

    David

  • 0 in reply to   

    Support just said to stop Retain using stop tomcat command.  I am guessing mysql needs tob be stopped and then copied?

  • 0   in reply to 

    Sure, DB need to stopped.

    David

  • 0 in reply to   

    Even with mysql stopped the mysql.sock "special file" is there and will not copy.  Is it needed for me to point retain to the new location of data files?

  • 0   in reply to 

    Which directories do you copy?

    Usually I use rsync to copy files to the new location. So you can start in an early state. In between you just rsync differential data. On your  final day you stop all involved services, do your final rsync and rename original directories (in case of trouble shooting).

    If you do not use default directories then maybe you have used symbolic links to pretend default directories; in this case you have to change these links to the new location. So your question is answered here - yes, Retain has to know where to find and store its data.


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

  • 0 in reply to   

    Ok, so I successfully moved the data to the new drive (except for the mysql.sock file) and changed all the data locations in the ASConfig file after backing up the file).  Then restarted the server with the retain installation pointing to the new location.  The web console is ow a loading screen with the last line being "EDT 2021: Stage (turnOnIndexing) Type (begin ) Info (Launch Indexing)".

    I am guessing it is re-indexing?

  • 0   in reply to 

    So you moved your index files too ... and your index location directory is /var/opt/beginfinite/retain/index (default location)?


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

  • 0 in reply to   

    I did not move anything that was not in the data location.  That was two directories:  mysql and retain

    I did not move server host, just added a bigger expandable drive and copied the /data contents which was the archive data.

  • 0  

    as you are doing a partial server move, perhaps the server move document may be of some assistance as it has helped me on a couple moves already

    support.microfocus.com/.../doc.php

    ________________________

    Andy of KonecnyConsulting.ca in Toronto
    Please use the "Like" and/or "Verified Answers" as appropriate as that helps us all.

  • 0 in reply to   

    i saw that and used part of it for the retain file locations, but this seems to be the mysql db.  i am assuming it is in the same data folder as the retain archives.  Micro Focus support isnt being much help. Just sending me tids and telling to call Microsoft for mysql issue.?????