Importing large database

I have a large database to import, I've tried bigdump but no success (duplicate error) Then I tried mysqldumper but always get a to many connections error about half way through. Is there any other way to do this? If I can do it via shell can someone give me a tutorial for direct admin?

 

take a look at the tools from dbconvert.com

 

http://www.ozerov.de/bigdump.php

The best one. I'm very happy with it, uploaded databases over 300MB all together.

 

Haven't been able to get bigdump to work cause it stops on familar lines...

 

BigDump is so far the best importing facility when it comes to large databases, double check a few recommen dations here, http://www.wanderings.net/notebook/Main/HowToImportLargeMySQLDataFiles

At this place there are two other suggestions importing large databases, may require additional time and effort though.

http://deployo.com/review/3-easy-ways-to-import-large-mysql-databases.html

 

I have used the EMS sql manager to import a 2 gig database to my provider as they did not give me shell access

 

in the control panel there is a backup button, go to backup and then choose restore database, that worked for me when everything failed.

 

Hi,

for ~1GB database I have used:

mysql -uuser_name -p database_name < mysqldump_backup.sql

PHP:

takes it's time but does the work.

If you already have some data in the database, then you need either clear it, or write some scipt that checks for duplicates and eliminates them.

 

This is what i've used in the past and has worked fine, may want to give it a go depending on the database size.