Open Source RDBMS - Seamless, Scalable, Stable and Free

English | Login |Register

How to Upgrade CUBRID Safely on Ubuntu

In this tutorial, we will focus on users that have installed CUBRID from apt-get. If this is the case, then the databases should be located in /var/opt/cubrid/databases or /opt/cubrid/databases.

If you upgrade from 8.4.0 to 8.4.1 or 8.4.3 for example, you only need to save the databases folder, uninstall and reinstall CUBRID using the following commands:

mkdir -p /home/user/database_backup
cp -R /var/opt/cubrid/databases /home/user/database_backup
sudo apt-get remove cubrid
sudo apt-get update
sudo apt-get install cubrid
cp -R /home/user/database_backup/* /var/opt/cubrid/databases/

Make sure to adapt "home/user" to your user. You can remove the backup folder database_backup after you start CUBRID and check if the databases are running correctly.

Important! Make sure that /var/opt/cubrid/databases/databases.txt file contains the right paths to the database folders. 

If you want to perform a completely safe upgrade indepent of the CUBRID version, instead of copying the databases folder like in the above approach, you should use cubrid unloaddb to export all databases in a backup folder, then uninstall CUBRID, update repository and install the new CUBRID version. Finally, you must import the databases into the new CUBRID instance by running cubrid loaddb.

comments powered by Disqus
문서 정보
viewed 1253 times
번역 en
posted 작년
마지막 수정시간 작년
변경 내역 보기
Share this article