Jump to content

User:Dispenser/terminal

From Wikipedia, the free encyclopedia
nightshade.toolserver.org - PuTTY
login as: dispenser
Authenticating with public key "rsa-key-20080514"
Passphrase for key "rsa-key-20080514":
Did you know...

   ... that if you don't read the rules, you will be haunted by the ghost
       of Noel Edmunds until the day you die?

       http://meta.wikimedia.org/wiki/Toolserver/Rules

   ... that our trained monkeys have written lots of helpful but confusingly
       organised documentation for users?

       http://meta.wikimedia.org/wiki/Toolserver/For_users (or type "faq")

   ... that we also have a server that doesn't crash every other day and
       run like a snail who overdosed on sleeping pills?

       http://meta.wikimedia.org/wiki/Toolserver/Stable_server

   ... that making your home world-writeable is a BAD idea?

Last login: Tue Oct 28 18:24:03 2008  from loop-10-165-250-71.tbeakm.aret.rastryn
.net
Your account will expire on Friday, 20 December 2024.
dispenser@nightshade:~$ sql enwiki_p
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 5926554
Server version: 5.0.64 Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> DESCRIBE
    -> user_groups;
+----------+-----------------+------+-----+---------+-------+
| Field    | Type            | Null | Key | Default | Extra |
+----------+-----------------+------+-----+---------+-------+
| ug_user  | int(5) unsigned | NO   |     | 0       |       |
| ug_group | char(16)        | NO   |     |         |       |
+----------+-----------------+------+-----+---------+-------+
2 rows in set (0.00 sec)

mysql> SELECT count(*) FROM user_groups WHERE ug_group="ipblock-exempt";
+----------+
| count(*) |
+----------+
|      838 |
+----------+
1 row in set (0.03 sec)

mysql> SELECT * from site_stats;
+-----------+----------------+----------------+------------------+--------------
-+----------+-----------+-----------+
| ss_row_id | ss_total_views | ss_total_edits | ss_good_articles | ss_total_page
 | ss_users | ss_admins | ss_images |
+-----------+----------------+----------------+------------------+--------------
-+----------+-----------+-----------+
|         1 |       63208805 |      1248520986 |          6900858 |      61710472
 |  48162716 |       496 |    928594 |
+-----------+----------------+----------------+------------------+--------------
-+----------+-----------+-----------+
1 row in set (0.00 sec)

mysql> quit
Bye
dispenser@nightshade:~$ _