Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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.

share|improve this question

2 Answers 2

up vote 3 down vote accepted

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

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

share|improve this answer
    
Thank you for your reply I update to clearify better, I hope you could help me. –  Kingston Town Mar 15 '12 at 7:08
    
Thank you for your update, it works correctly now. I have used Putty and it also works as expected, the same as what you told me, except I didn't enter the hostname because I connect to the host server using Putty already. Thanks a lot! –  Kingston Town Mar 15 '12 at 7:21

most probably you'd like to know how to export from mysql dataset that is more than few megabytes. web tools are not very well suited for that. if you have access to the shell on the server or remote access to mysql instance where the data is stored - try using mysqldump.

if you dont have shell access you can try using phpmyadmin to dump table after table and there select row ranges [how many rows per dump? that you'll have to find out empirically].

share|improve this answer
    
Thank you for your reply, I update to clearify better –  Kingston Town Mar 15 '12 at 7:08
    
Thank, I finished it with the above method. I will try to dump table after table next time if I have another chance. –  Kingston Town Mar 15 '12 at 9:20

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.