How to import a large database

[desibreaker]

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

 

[Doublecrosser]

use mysqldumper
it will Help

 

[minisofts.com]

You try to use MySQLDumper

It's a best :D

 

[BlaZe]

Yes MySQL Dumper is the best

 

[desibreaker]

I have installed it on my server but don't know how to import the file

 

[Doublecrosser]

add me
doublecrosser@rocketmail.com ^_^

 

[desibreaker]

don't know what happen I'm unable to login in my cpanel now!!

 

[TooManySecrets]

Il help you m8 just give me your msn

 

[Prince]

Contact your host about Cpanel, add the backup file after you install mysql dumper to /work/backup/

It will detect it as "other scripts backup", choose it and click restore.

Alternatively use bigdump, search on it on Google to find it, it is simple php file, add to it your server SQL info and your backup file name then run it.

 

[Jayar]

ssh is the fastest and most reliable way when you get down to the bottom of it all

 

[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

 

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

 

[drlove]

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.