I was thinking of running a query, temporarily store its output on ToolsDB. Join it with some other query and then throw it away. All in small scale and for short-term.
That said, ToolsDB (Toolforge user DB) is not equipped to handle
becoming an aggregate datamart for the wiki replicas at any
thing close to large (wiki) scale--just small chunks that are
ideally regularly cleaned up. Are we talking about a database on
a Cloud VPS instance or ToolsDB?
Is
it possible to store data into user tables through queries on
Wikireplica DBs? Or is it only possible by mysqldump'ing from
the replica DB and loading into the user table in a separate
step?