From CUBRID Documentation

Home < Absolute Beginners' Guide to CUBRID

Welcome to CUBRID, an Open Source Database Management System highly optimized for Web Applications!

If you know very little about CUBRID but want to learn more, and... learn it quickly, this is the right place for you to get started! The Absolute Beginner's Guide to CUBRID is just for you. Here you will learn the very basic information of how to get started with CUBRID. As a result you will be able to quickly install, configure, and start executing your SQL queries without much of special technical skills.

Contents 1 General Information 2 Getting Started with CUBRID 2.1 Download CUBRID 2.2 Install CUBRID 2.3 First Steps in CUBRID 2.3.1 Before You Start CUBRID 2.3.2 Starting CUBRID 2.4 Running Web Applications with CUBRID 2.4.1 Install PHP & PHP Library 2.4.2 Install Wordpress 2.4.3 Install Ruby Gem 2.4.4 Migrating Data to CUBRID 2.5 Getting Help in CUBRID 3 More Advanced Topics 3.1 CUBRID Security Configurations 3.2 How to Backup and Restore CUBRID Database

General Information

You can read About CUBRID on our http://www.cubrid.org home page. There you can find answers for:

• What is CUBRID?
• Why use CUBRID?
• Who else uses CUBRID?

Getting Started with CUBRID

Download CUBRID

Visit CUBRID Downloads page to get the full access to the latest CUBRID releases. You can download the installation packages for both 32 bit and 64 bit Linux or Windows).

Install CUBRID

Once you have downloaded CUBRID for your particular system, you can proceed with the installation.

NOTE for Windows users: make sure you have read Software Requirements for CUBRID Manager.

Now choose below CUBRID Installation Guide created specifically for your operating system.

CUBRID Installation Guide for Windows users

CUBRID Installation Guide for Linux users

First Steps in CUBRID

Before You Start CUBRID

• When CUBRID is installed, it automatically sets the platform-specific environment variables like the PATH to CUBRID Directory or to the Directory of Databases. To get acquainted with CUBRID environment variables, see Configuring the Environment Variables.
• You might also need to familiarize yourself with the basics of CUBRID Language Settings.

Starting CUBRID

Windows Users: You are recommended to read two articles given below:

1. How to Start CUBRID Manager
2. CUBRID Tutorial for Windows Users

Linux Users: You are recommended to read the following article:

1. CUBRID Tutorial for Linux Users

At this stage you should have enough knowledge and skills to start using CUBRID database.

Running Web Applications with CUBRID

In order to successfully install and use most Web applications like Wordpress, it is required to install PHP. Therefore, let's get PHP working.

Install PHP & PHP Library

First, Download and Install PHP. Make sure you Install PHP Library for CUBRID as well. It is necessary to connect to CUBRID using PHP.

Install Wordpress

In CUBRID Apps&Tools you will find a list of other web applications you can use with CUBRID. As an example, we will show you how to install and use Wordpress blogging system for CUBRID.

• For this purpose we have prepared a tutorial How to Install Wordpress for CUBRID

Install Ruby Gem

We have pushed Ruby Gem, the driver to connect to CUBRID, to RubyGems.org, the main and official repository for third party extensions written in Ruby. Follow the link below to get Ruby driver installed on Linux and Windows.

• Ruby Programming with CUBRID

Migrating Data to CUBRID

If you already have your data in other databases like MySQL, you might want to move it to CUBRID database. Right for this purpose we have recorded a video lesson along with the tutorial how to move you data from other database to CUBRID. Watch the video below.

• Video Tutorial: How to use Apache DdlUtils & Scriptella to migrate databases to CUBRID
• Migrating MySQL data to CUBRID using PHP

Getting Help in CUBRID

At this point you might have come up with certain questions.

• Make sure your questions are not already answered at our F.A.Q.
• If not, register at our CUBRID Forum. Find the related topic and post your question, request or proposal. Our forum moderators will get back to you quickly.
• See All Pages we already have here at CUBRID Documentation. You may find them very useful.

More Advanced Topics

CUBRID Security Configurations

Here are the General Security Configurations for CUBRID that you can refer to.

How to Backup and Restore CUBRID Database

DBAs must regularly perform backups of their databases so that they can be successfully restored later to a state at a certain point in time in case of the system failure.

• Refer to Database Backup
• Read Database Restore
• Then see How to Use CUBRID Backup and Restore Utilities (Syntax).
• Also refer to Backup Strategy and Method
• And to Restore Strategy and Procedure
• Here is also another document you might find interesting Managing a Backup File