Hi,

We are importing a 600MB database into My SQL version 5.0.77 on Red Hat 5.5.

It's taking 11 hours to import this data.

We tried it with My SQL 5.1 as well with the same results.

The OS is sitting on a blade server with 12GM RAM + 8GB Swap and 2.83MHZ Dual Core Proc.

I am a UNIX Admin, but our DBA's aren't able to shed any light on this.

We tried on Ubuntu 10.04 running on a desktop and it took 163 minutes to complete! This was using My SQL 5.1.

The rpm's look like this;

mysql-5.0.77-4.el5_4.2
php-mysql-5.2.6-1.el5.remi
mysql-server-5.0.77-4.el5_4.2

So, why is it taking so long to complete?

Cheers,

please put here variables in my.cnf

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1

# Disabling symbolic-links is recommended to prevent assorted security risks;
# to do so, uncomment this line:
# symbolic-links=0

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid