<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
They're not in the replicas, but under tools.labsdb: see <a
class="moz-txt-link-freetext"
href="https://phabricator.wikimedia.org/T50625"><a class="moz-txt-link-freetext" href="https://phabricator.wikimedia.org/T50625">https://phabricator.wikimedia.org/T50625</a></a>
for details.<br>
<br>
<tt>MariaDB [toolserverdb_p]> SELECT * FROM namespace WHERE
dbname = 'abwiki_p' AND ns_id = 4;<br>
+----------+------------------+-------+----------------------+<br>
| dbname | domain | ns_id | ns_name |<br>
+----------+------------------+-------+----------------------+<br>
| abwiki_p | ab.wikipedia.org | 4 | Авикипедиа |<br>
+----------+------------------+-------+----------------------+<br>
1 row in set (0.00 sec)<br>
<br>
MariaDB [toolserverdb_p]> SELECT * FROM namespacename WHERE
dbname = 'abwiki_p' AND ns_id = 4;<br>
+----------+------------------+-------+----------------------+-----------+----------------+<br>
| dbname | domain | ns_id | ns_name |
ns_type | ns_is_favorite |<br>
+----------+------------------+-------+----------------------+-----------+----------------+<br>
| abwiki_p | ab.wikipedia.org | 4 | Авикипедиа |
primary | 1 |<br>
| abwiki_p | ab.wikipedia.org | 4 | Project |
canonical | 0 |<br>
| abwiki_p | ab.wikipedia.org | 4 | Wikipedia |
alias | 0 |<br>
+----------+------------------+-------+----------------------+-----------+----------------+<br>
3 rows in set (0.10 sec)</tt><br>
<br>
Or simply use the API as suggested by Chad.<br>
<br>
<div class="moz-cite-prefix">Il 19/11/2015 12:26, Yetkin Sakal ha
scritto:<br>
</div>
<blockquote
cite="mid:1157859640.7433986.1447932362922.JavaMail.yahoo@mail.yahoo.com"
type="cite">
<div style="color:#000; background-color:#fff;
font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial,
Lucida Grande, sans-serif;font-size:13px">
<div id="yui_3_16_0_1_1447927211941_24645">Are namespaces stored
in replica databases? How can we link the page_namespae column
in the page table to retrieve the full page name?<br>
</div>
</div>
<br>
</blockquote>
</body>
</html>