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.
Best Answer
It is much better to use mysqldump for exporting that large database.
You can do this with
mysqldump -u username -p -h hostname --databases yourdatabase > yourfile.sqlBut you must have user that can connect from outside of server.
Perfect solution will be do this export localy on server then download it via ftp. But for this you need shell account.