Dumping large database

Hello

I want to dump large database of around 80 mb and my internet is so slow to handle please suggest any measure

 

If your Internet speed is slow and liable to interruption, you can
use a download manage which will be able to resume interrupted
downloads.

 

Also make sure that the raw database file is compressed before downloading.

 

First compress the DB and then you may use this script

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

 

I hope u have SSH enabled if yes, then follow the steps.
> Give this command in ur SSH do replace wid ur database username & Password.

mysqldump -udbusername -pdbpassword --dbname >filename.sql

it will create .sql file now transfer tht .sql file with "wget" command.

and after getting tht .sql on ur new host simply extract tht .sql with command

mysql -uusername -ppassword -- username < file.sql

Hope it works

 

Let me second the bigdump link prior. I used it to upload a 300 meg db perfectly.

Charles

 

Thanks guys for your concern