In {T269513} we discovered that the enwp10 has a legacy database on the ToolsDB servers that only has a single underscore rather than the expected double underscore between the db username and the dbname suffix.
There are other dbs with legacy naming, and they should be fixed.
---
Below you can find a list of the databases and db user names, as well as the owners/tool&maintainers.
We will reach out by email and send warnings until **March 31, 2021**, at which point the DBs will be dropped.
After the list you can find instructions on how to migrate your tables to a DB with a valid name.
If you have any concerns, problems, or special needs please reach out.
---
==List of DBs with their owners/maintainers==
Legend:
* Should delete: (Y/N) based on owners' answers
* Fixed/deleted: (Fixed/Deleted) based on actions taken on the DB
| Should delete | Fixed/Deleted | DB user | DB name | User | Maintainers |
| --- | --- | --- | --- | --- | --- |
| | | s51067 | s51067_cerabot | cerabot | Ceradon |
| | | s51081 | s51081_limes | render-tests | Daniel Kinzler, Jkroll, Kai Nissen (WMDE) |
| | | s51092 | s51092_count | iluvatarbot | 1997kB, Iluvatar |
| | | s51092 | s51092_rsources | iluvatarbot | 1997kB, Iluvatar |
| | | s51092 | s51092_raports | iluvatarbot | 1997kB, Iluvatar |
| Y | | s51100 | s51100_mass_translate_p | dexbot | Ladsgroup |
| | | s51114 | s51114_enwp10 | enwp10 | Audiodude, Kelson |
| | Deleted | s51154 | s51154_hkmphotos | fiwiki-tools | Zache-tool |
| | Deleted | s51174 | s51174_main | tusc | Magnus Manske |
| | Deleted | s51187 | s51187_xtools | xtools | Cyberpower678, Matthewrbowker, MusikAnimal, Samwilson |
| | | s51201 | s51201_wiki | yifeibot | Eatcha, Multichill, Steinsplitter, Zhuyifei1999 |
| | Deleted | s51223 | s51223_db | lists | Alessio, Candalua, Fale, Incola, Mess |
| | | s51270 | s51270_wikidatastats | audetools | Aude |
| Y | | s51375 | s51375_wiki | gabrielchihonglee-bot | Gabrielchihonglee, Zhuyifei1999 |
| | | s51381 | s51381_cropbot | cropbot | Luxo |
| Y | | s51441 | s51441_krdbot | krdbot | Krd |
| | Deleted | s51541 | s51541_stewardbot | stewardbots | BryanDavis, DerHexer, HakanIST, Hoo man, Jyothis, Linedwell, Matanya, Mat, Melos, Revi, Rxy, Shanmugamp7, Urbanecm |
| | Deleted | s51541 | s51541_sulwatcher | stewardbots | BryanDavis, DerHexer, HakanIST, Hoo man, Jyothis, Linedwell, Matanya, Mat, Melos, Revi, Rxy, Shanmugamp7, Urbanecm |
| | | s51780 | s51780_supercount | supercount | Cyberpower678, Ladsgroup |
| N | Fixed | s51835 | s51835_usagestats | awb | Magioladitis, Reedy |
| N | Fixed | s51835 | s51835_typoscan | awb | Magioladitis, Reedy |
| | | s51884 | s51884_wikibot | citing-bot | Karibekov Vladislav Y. |
| | | s51892 | s51892_toolserverdb_p | toolserverdb | Jkroll, Nosy, Tobias Gritschacher |
| | | s51892 | s51892_toolserverdb | toolserverdb | Jkroll, Nosy, Tobias Gritschacher |
| | | s51922 | s51922_wle | wle | Base, RLuts |
| | | s51964 | s51964_denkmalliste | denkmalliste | AleXXw, Braveheart, Jean-Frédéric, Ruben Demus, Thomas Ledl |
| | | s52082 | s52082_limes | limesmap | Jkroll |
| Y | | s52452 | s52452_wikijourney | wikijourney | Pyguerder |
| | | s52462 | s52462_ps | wikidata-primary-sources | Addshore, Denny Vrandecic, Hjfocs, SebastianSchaffert, Tpt |
| Should delete | Fixed/Deleted | DB user | DB name | User |
| --- | --- | --- | --- | --- |
| | | u10570 | u10570_gapfindertools | Bmansurov |
| | Deleted | u1092 | u1092_epsg_p | Merlijn van Deen |
| | Deleted | u1092 | u1092_test | Merlijn van Deen |
| | | u2138 | u2138_wiki | Coren |
| | | u2264 | u2264_cx_db | Ryuch |
| | | u2264 | u2264_contenttranslation | Ryuch |
| Y | | u4529 | u4529_srwiki | Dungodung |
==How do I rename my database?==
=== Approach 1: rename your tables into a new DB ===
# SSH to toolforge, `become tool` if necessary
# [Make a backup of the DB in case something goes wrong](https://wikitech.wikimedia.org/wiki/Help:Toolforge/Database#ToolsDB_Backups_and_Replication)
# `cat replica.my.cnf` to look at your user id
# `sql tools` to connect to ToolsDB
# `CREATE TABLE MYUSERORTOOLID__MYDBNAME;` make your new DB with the new name
# `USE MYUSERORTOOLID_MYOLDDBNAME;` select the old DB
# `SHOW TABLES;` to see the tables and data you have in the old DB
# `RENAME TABLE MYUSERORTOOLID_MYOLDDBNAME.table_name to MYUSERORTOOLID__MYDBNAME.table_name;` rename each table form the old DB to the new one
# Finally feel free to use the new DB and poke around, all your data should be there.
# Update your tool / code to use the right DB name
# Once everything is working, download or remove the backup if you put it in Toolforge
=== Aproach n : ___ ===
//If you know of other safe correct ways of doing this please edit here.//