Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | 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
Page info
viewed 3951 times
translations en
posted 4 years ago by
updated 4 years ago by
View revisions
Share this article