I'm trying to install enwiki-20130503-page.sql into an empty database and the process is too slow (it takes days), so I think it isn't normal. What I do is:
1. Installing tables.sql 2. Executing a script to disable foreign key checks 3. Installing enwiki-20130503-page.sq (mysql -u <usr> -p<pwd> enwiki < enwiki-20130503-page.sql &).
I don't know if the problem can be my MySQL configuration:
[client] port = 3306 socket = /var/run/mysqld/mysqld.sock default-character-set =utf8
[mysqld_safe] socket = /var/run/mysqld/mysqld.sock nice = 0
[mysqld] user = mysql pid-file = /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock port = 3306 basedir = /usr datadir = /var/lib/mysql tmpdir = /tmp lc-messages-dir = /usr/share/mysql skip-external-locking bind-address = 127.0.0.1 key_buffer = 16M max_allowed_packet = 256K thread_stack = 192K thread_cache_size = 8 myisam-recover = BACKUP query_cache_limit = 1M query_cache_size = 16M log_error = /var/log/mysql/error.log expire_logs_days = 10 max_binlog_size = 100M
collation-server = utf8_unicode_ci init-connect ='SET NAMES utf8' character-set-server = utf8
[mysqldump] quick quote-names max_allowed_packet = 16M
[mysql] default-character-set = utf8
[isamchk] key_buffer = 16M
!includedir /etc/mysql/conf.d/
Any idea?