CUBRID Study Notes 8 copy database, cubrid Study Notes

CUBRID Study Notes 8 copy database, cubrid Study Notes

1 export database is similar to the SQL Server detached database

 

Cubrid unloaddb demodb
The three files demodb_objects, demodb_indexes and demodb_schema are generated after the separation. One stores data, one Stores indexes, and the other stores standard definitions.

2. Create a new database

Cubrid createdb testdb

Because the created database will be in the current directory, make sure that the path for running the command line is the path for storing the database.

3. Load separated database files

cubrid loaddb testdb -d demodb_objects -i demodb_indexes -s demodb_schema -u dba

First, confirm that the new testdb database is not running.
If you are running the linux version, pay attention to the file permission.
Linux I do not understand the original http://www.cubrid.org/wiki_tutorials/entry/copy-clone-database

4. Start the database

cubrid server start testdb

You are welcome to reprint it. Please keep the author's information during reprinting. This article copyright belongs to me, if you have any questions, please contact me wang2650@sohu.com. Fault

This method does not guarantee data validity, but is very fast, isn't it?

 

This is a discussion of the problem. http://www.cubrid.org/forum/425888

 

Some junk data may occur during migration. This is caused by sorting. If it is a single database, it should not be the case.

The sorting problem can be solved by sorting. You know.

 

The following figure shows how to download the database in the Manager.