Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register


2
(click on this box to dismiss)

Is it possible to resize a database volume?

Suppose I created a 20M volume, is it possible to resize it? I notice that if I my data exceeds the volume size some other volumes are created automatically. But I want to know if I can avoid this by manually resizing the initial volume.

link comment (0)
asked 3 years ago
sqlcopter
284
7 Answers
0

There is no way to "resize" the existing database volume. There are two solutions for this situation:

  1. Add new volume using cubrid addvoldb utility.
  2. Unloaddb this 20M database, delete it, create the same database with bigger volume, then loaddb the unloaded data into this new database.

Normally unloaddb/loaddb utilities are used:

  • When migrating a previous CUBRID database version to a new version.
  • When migrating a database of third-party DBMS to a CUBRID database.
  • When entering mass data faster than executing the INSERT statement.

So, using addvoldb is a more correct solution.

Also, you always need to backup your data before applying any major change to your database.

link comment (0)
answered 2 years ago
dba
558




You are either using a very old browser or a browser that is not supported.
In order to browse cubrid.org you need to have one of the following browsers:



Internet Explorer: Mozilla Firefox: Google Chrome: