MySQL import

[PRB]

Hello,

I tried to import the MySQL database of one my users (2.5GB) and the server got extremely overloaded (like 30.00). Sites with MySQL would load like after 30 seconds, which is unacceptable on a server with 600 other domains.

So I told him its not possible. So he tried some script to import the database, it also overloaded the server, so I warned him.

He wants to move all his websites to our server, but how can he transfer such a huge database without overloading the server and without splitting it up to 2MB files?

Is there ANY way? Is there a way to import it so that it imports 1 query per second or something so that the server doesnt get overloaded? Its a quadcore xeon 2gb ram

does anyone have some advice for me?

 

[nobaloney]

Make sure your MySQL configuration is optimzied; there are some good threads on these forums. I'm not an expert on it, or I'd direct you further.

Have you tried importing the database using MySQL from the command line instead of either the DirectAdmin control panel or PHP?

And finally, I'm not convinced a quadcore xeon processor, 2gb of RAM, and a 2.5G database are a good fit. Can you add more RAM? If you're running a 64-bit OS your server should be able to manage over 4G of memory; if a 32-bit OS you should be able to install 4G of memory though your server will see only about 3.5G.

I'm NOT a mysql expert and have had my own problems with optimization; hopefully you'll some other replies besides mine.

Jeff

Jeff