Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

Versions available for this page: CUBRID 8.3.1 |  CUBRID 8.4.0 |  CUBRID 8.4.1 |  CUBRID 8.4.3 |  CUBRID 9.0.0 | 

Migrating Database

To use a newer version of CUBRID database, you might migrate an existing data to a new one. For this purpose, you can use the "Export to a ASCII text file" and "Import from a ASCII text file" features provided by CUBRID. The following section explains migration steps using the cubrid unloaddb and cubrid loaddb utilities.

Recommended scenario and procedures

The following is an explanation of a migration scenario that can be applied while the existing version of CUBRID is running. For database migration, the cubrid unloaddb and cubrid loaddb utilities are used. For more information, see Unloading Database and Loading Database.

  1. Back up the existing database
    1. Back up the existing version of the database by using the cubrid backupdb utility. The purpose of this step is to safeguard against failures that might occur during the database unload/load operations. For more information about the database backup, see Database Backup.
  2. Unload the existing database
    1. Unload the database created for the existing version of CUBRID by using the cubrid unloaddb utility. For more information about the database unload, see Unloading Database.
  3. Storing the existing CUBRIDG configuration files
    1. Save configurations files such as cubrid.conf, cubrid_broker.conf and cm.conf located in the CUBRID/conf directory. The purpose of this step is to conveniently apply parameter values for the existing CUBRID database environment to the new one.
  4. Install a new version of CUBRID
    1. Once backing up and unloading of the data created by the existing version of CUBRID have been completed, delete the existing version of CUBRID and its databases and then install the new version of CUBRID. For more information about installing CUBRID, see Installing and Running on Linux in "Getting Started."
  5. Configure the new CUBRID
    1. You can configure the new version of CUBRID by referring to configuration files of the existing database saved in the step 3, "Save configuration files of the existing version of CUBRID." For more information about configuration, see Installing and Running on Windows in "Getting Started."
  6. Load the new database
    1. Create a database by using the cubrid createdb utility and then use the cubrid loaddb utility to load into the new database the data which had previously been unloaded. For more information about creating a database, see Creating Database in "Administrator's Guide." For more information about database loading, see Loading Database.
  7. Back up the new database
    1. Once the data has been successfully loaded into the new database, back up the database created for the new version of CUBRID by using the cubrid backupdb utility. The reason for this step is because you cannot restore the data backed up in the existing version of CUBRID when using the new version. For more information about backing up the database, see Database Backup.