rename database

Pierre-Adrien Coustillas

15 Jan 2015 15 Jan '15

4:37 p.m.

Hi, Is it possible to rename a database ? I thought to do like this: monetdb stop database mv /var/lib/monetdb/database /var/lib/monetdb/new_database monetdb start new_database it's okay ? Thank Pierre -- 1G6 52 route de bischwiller 67300 Schiltigheim Société de Services et de Formations en Logiciels Libres http://1g6.biz Tél : 06 64 63 70 35

Attachments:

attachment.html (text/html — 2.9 KB)

Show replies by date

Dimitar Nedev

15 Jan 15 Jan

5:23 p.m.

Hi Pierre, Yes, you can rename a database like that. As long as the new/renamed database is in the same dbfarm directory (in this case /var/lib/monetdb), the monetdb-daemon that runs from that dbfarm will be able to find new database. If you want to be safe and have the disk space, copy the database (after stopping it first), instead of renaming it. Best regards, Dimitar

...

On 2015-Jan-15, at 16:37 , Pierre-Adrien Coustillas wrote:

Hi,

Is it possible to rename a database ?

I thought to do like this:

monetdb stop database mv /var/lib/monetdb/database /var/lib/monetdb/new_database monetdb start new_database

it's okay ?

Thank

Pierre

-- 1G6 52 route de bischwiller 67300 Schiltigheim Société de Services et de Formations en Logiciels Libres http://1g6.biz Tél : 06 64 63 70 35

_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list

Fabian Groffen

9:09 p.m.

On 15-01-2015 17:23:31 +0100, Dimitar Nedev wrote:

...

Hi Pierre,

Yes, you can rename a database like that. As long as the new/renamed database is in the same dbfarm directory (in this case /var/lib/monetdb), the monetdb-daemon that runs from that dbfarm will be able to find new database.

If you want to be safe and have the disk space, copy the database (after stopping it first), instead of renaming it.

Or: % monetdb set name=newname oldname Fabian

Brian Hood

9:24 p.m.

that's interesting Fabian however the schemas inside the database must stay the same so if you have to rename a schema is that possible? Regards, Brian Hood On Jan 15, 2015 8:10 PM, "Fabian Groffen" wrote:

...

...
Hi Pierre,

Yes, you can rename a database like that. As long as the new/renamed database is in the same dbfarm directory (in this case /var/lib/monetdb),

On 15-01-2015 17:23:31 +0100, Dimitar Nedev wrote: the monetdb-daemon that runs from that dbfarm will be able to find new database.

...
If you want to be safe and have the disk space, copy the database (after

stopping it first), instead of renaming it.

Or:

% monetdb set name=newname oldname

Fabian _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list

3642

Age (days ago)

3642

Last active (days ago)

List overview

Download

3 comments

4 participants

participants (4)