How to import a large database

[desibreaker]

hello there, I tried to use bigdump again and thankfully I have been able to add the database but unfortunately I have a blank page for my site take a look

http://forum.movizddl.com

any help

desibreaker Reviewed by desibreaker on 25th Oct 2009. How to import a large database Hi, how to import a large database in mysql? I have tried bigdump but I'm getting an internal error. Have tried many other method even then no result! Help please Rating: 5

[pikeypete]

Personally I use SQLdumper, it can handle large databases with no problem.
Info and download:

http://www.mysqldumper.net/

Pikeypete

[Storming]

I use bigdump or if its really big i do it via ssh on my server.

[Prince]

Always after importing your database check it with phpmyadmin for errors and fix anything by repair command.

I see it sorted out now.

[Sandino]

if you have ssh access you can do it yourself with some simple commands.
but if you are hosted with someone, just ask your host to do it.
they should be able to do it, if not you have a crappy host.

[AoN]

If you have ssh access,then it's so easy, go and download putty enter Your details..

You will need the database username, password and database name, and putty
After you ssh into OLD server, type "mysqldump -u USER_NAME -p DB_NAME | gzip > FILE.sql.gz"
Enter the database password when it asks. Then, usinf FTP or sFTP, copy the FILE.sql.gz file from the OLD server to the NEW server. (Presumably by copying it from OLD server to your PC and then to NEW server.)
After you ssh into NEW server, type "gunzip < FILE.sql.gz | mysql -u USER_NAME -p DB_NAME"
Enter the database password when it asks. When it is done, your database will be copied to the new server.

Restoring . ssh to new host (make sure the database actually exists!)

mysql database -uusername -p < database.sql
or simply mysql database -uusername -p
enter password
source database.sql

PM me if you need more help.

[sniffdog]

I use HeidSQL ... free and don't have to install anything on your server.

Works perfect!

http://www.heidisql.com/

[Sandino]

If you have ssh access,then it's so easy, go and download putty enter Your details..

You will need the database username, password and database name, and putty
After you ssh into OLD server, type "mysqldump -u USER_NAME -p DB_NAME | gzip > FILE.sql.gz"
Enter the database password when it asks. Then, usinf FTP or sFTP, copy the FILE.sql.gz file from the OLD server to the NEW server. (Presumably by copying it from OLD server to your PC and then to NEW server.)
After you ssh into NEW server, type "gunzip < FILE.sql.gz | mysql -u USER_NAME -p DB_NAME"
Enter the database password when it asks. When it is done, your database will be copied to the new server.

Restoring . ssh to new host (make sure the database actually exists!)

mysql database -uusername -p < database.sql
or simply mysql database -uusername -p
enter password
source database.sql

PM me if you need more help.

Expand

i simply do ->
mysql -D database_name < file.sql

lol easier.