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?