[MDEV-30807] allow renaming databases Created: 2023-03-07 Updated: 2023-03-07 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | None |
| Fix Version/s: | None |
| Type: | Task | Priority: | Minor |
| Reporter: | Sylvain ARBAUDIE | Assignee: | Unassigned |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | None | ||
| Description |
|
demand is simply adding an ALTER DATABASE <old.dbname> RENAME TO <new.oldname>; |
| Comments |
| Comment by Sergei Golubchik [ 2023-03-07 ] |
|
This is very complex. The problem is not the rename as such, but properly locking the database and all affected tables during the operation. Was attempted once back in MySQL times (2007? 2008?) and was removed, as we couldn't make it work. The locking subsystem has changed much since then, so it's possible that the second attempt will succeed. But it won't be simple. |