Talk:Requests for queries

Automated list of users who can perform database queries: tswiki:special:listusers/query-service ~Kylu (u|t) 23:38, 21 March 2008 (UTC)

Binary and UTF-8

I think it would be better to write:

CREATE DATABASE wikipedia
DEFAULT CHARACTER SET binary;

in p.5 here. Because dumps are in binary format. There will be serious problems, if someone tries to import non-english binary SQL-dump as utf8 or latin1 or something. --CodeMonk 17:53, 21 August 2005 (UTC)

How to write a query like...

How to write a query like this: "A list of articles on language X which do not have an interwiki to language Y, sorted by the number of interwikis the article has on language X"? -- Mathias Schindler 07:43, 16 Jul 2004 (UTC)

There seems to be somethig wrong? I get a "No such special page" error on Special:Asksql, and there is no logfile at the specified place either. Is that a temporary condition? 80.219.223.123 21:09, 5 Dec 2004 (UTC) en:User:Dbachmann

a

Passwords in database dump

Hey, are the wikipedia etc. passwords contained in the database dump? Wouldn't be that good... Actually, what stuff is contained in the dump? Thanks, --Abdull 12:07, 24 Mar 2005 (UTC)

The passwords are not included. --w:user:unforgettableid

Why Windows only

MySQL is portable and I basically all this should work in Linux and OSX fine with a slight amount of modification. Are we assuming Linux and Mac users are smart enough to know how to make database dumps? 58.69.3.194 05:03, 29 October 2005 (UTC)

Archiving

There's a lot of old stuff on the page, is there some reason that some of it shouldn't be archived? - brenneman 23:49, 6 April 2006 (UTC)

Archiving

I've archived everything to the archives section, removed the old outdated instructions on the .sql dumps and softredirected to the new toolserver page. Snowolf ^{How can I help?} 13:42, 6 February 2008 (UTC)