downloading a large database

view full story

http://serverfault.com – I tried to export a large sized database using phpmyadmin but later the downloaded file seems to be of incorrect size, many of the tables inside the database are eliminated during download. The file size is about 700MB-1GB In Export of phpmyadmin, i save the file as mydb.sql then in mysql I use "source" command to save it into mysql. The DB file is originally stored in another server (in another country). I access phpmyadmin with password and username. I guess now you understand my situation, I would like to get down this large db file then use it locally for test and development. (HowTos)