influxdb icon indicating copy to clipboard operation
influxdb copied to clipboard

[feature request] RENAME DATABASE

Open beckettsean opened this issue 10 years ago • 21 comments

From https://github.com/influxdb/influxdb/issues/828#issuecomment-83224779

e.g. RENAME DATABASE foo TO bar

Would also need to update all relevant CQs.

beckettsean avatar Sep 17 '15 21:09 beckettsean

From discussion on https://github.com/influxdb/influxdb/pull/4291, will use this syntax: ALTER DATABASE name RENAME TO new_name

linearb avatar Oct 02 '15 22:10 linearb

Looks like this is now merged. Closing.

jackzampolin avatar Nov 03 '15 19:11 jackzampolin

Jack, I believe the merge was reverted. @otoolep what's the status of ALTER DATABASE?

beckettsean avatar Nov 03 '15 20:11 beckettsean

I believe we decided that we may add an alias method, but likely not an alter or rename.

corylanou avatar Nov 03 '15 20:11 corylanou

The feature was reverted, a person in the community may submit a new patch at a later date, but no work planned by us right now.

otoolep avatar Nov 03 '15 20:11 otoolep

Sorry about that! Thanks for the catch @beckettsean

jackzampolin avatar Nov 03 '15 20:11 jackzampolin

Is there a workaround for this? Such as:

  • Stop Influx DB
  • Rename database and wal folder to reflect the new name of the database
  • Start Influx DB

I guess it will not work, as it looks like meta/meta.db contains some references to my database?

hpbieker avatar Mar 19 '17 07:03 hpbieker

@hpbieker do you find some command for rename a database?

houming818 avatar Mar 21 '17 00:03 houming818

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.

stale[bot] avatar Jul 23 '19 19:07 stale[bot]

Still interested in this.

mitar avatar Jul 23 '19 19:07 mitar

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.

stale[bot] avatar Oct 21 '19 20:10 stale[bot]

Still interested in this.

mitar avatar Oct 21 '19 21:10 mitar

Yeah, would love and need this feature for db migrations we do quite often.

svanscho avatar Oct 24 '19 08:10 svanscho

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.

stale[bot] avatar Jan 22 '20 09:01 stale[bot]

Still interested in this.

mitar avatar Jan 22 '20 09:01 mitar

I'm also interested in this

stephenrs avatar Feb 23 '20 02:02 stephenrs

I am also interested in this feature. Rename comes in handy for migration

sultanksh avatar Sep 29 '20 19:09 sultanksh

I am also interested in this

argyris-gardelakos avatar Jan 21 '22 14:01 argyris-gardelakos

This would be great!

nvolker avatar Jun 01 '22 09:06 nvolker

This would be great for us too

akki-akshat avatar May 24 '23 11:05 akki-akshat

Another vote for this feature from me :-)

lsitzmann avatar Jun 06 '24 10:06 lsitzmann