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
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 pcoustillas@1g6.biz 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
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
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" fabian@monetdb.org wrote:
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 _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
participants (4)
-
Brian Hood -
Dimitar Nedev -
Fabian Groffen -
Pierre-Adrien Coustillas