How to import a large database

[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.

AoN Reviewed by AoN 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

[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.

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

lol easier.