if you have access to SSH then use this command in putty

mysqldump --opt -u username -p databasename > {path}/backupfile.sql

and if you don't have that then use the script BIGDUMP.. that is great.. mysqldumper sucks..

Bigdump restores 1GB databases in 2-3 minutes...
Jason_weds_Freddy Reviewed by Jason_weds_Freddy on . Very slow database restore using mysqldumper As you can see in the picture below, my 6 mb compressed database took 185 minutes and still going on to restore. Is it normal? http://i.imgur.com/zbORT.png Rating: 5