Influxdb: [feature request] RENAME DATABASE

[beckettsean]

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.

[linearb]

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

[jackzampolin]

Looks like this is now merged. Closing.

[beckettsean]

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

[corylanou]

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

[otoolep]

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.

[jackzampolin]

Sorry about that! Thanks for the catch @beckettsean

[hpbieker]

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?

[stdhi]

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

[stale[bot]]

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.

[mitar]

Still interested in this.

[stale[bot]]

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.

[mitar]

Still interested in this.

[svanscho]

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

[stale[bot]]

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.

[mitar]

Still interested in this.

[stephenrs]

I'm also interested in this

[sultanksh]

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