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.
![[Level:5]](http://www.cubrid.org/modules/point/icons/default/5.gif "Rank: 5/30, reputation score 284 (84% completed for the next level)"){kind=icon}
sqlcopter
1
Answer
0
There is no way to "resize" the existing database volume. There are two solutions for this situation:
- Add new volume using cubrid addvoldb utility.
- 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.
![[Level:8]](http://www.cubrid.org/modules/point/icons/default/8.gif "Rank: 8/30, reputation score 558 (28% completed for the next level)"){kind=icon}
dbaasked 2 years ago
viewed 652 times