Slow download when export sql via PHPMYADMIN

konrath

Well-Known Member
May 3, 2005
366
0
166
Brasil
Hello

I have slow download when export sql via PHPMYADMIN

Any suggestion ?

Thank you
Konrath
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,904
2,218
463
Hello :)

How large is the database? Have you considered using the "mysqldump" utility in the command line? EX:

Code:
mysqldump database_name > /path/to/exported_database.sql
Thank you.
 

konrath

Well-Known Member
May 3, 2005
366
0
166
Brasil
Hello cPanelMichael

The database has 1MB only. The download is the problem... 5KB per second only. Only download via phpmyadmin is slow

Any suggestion ?

Thank you
Konrath
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,904
2,218
463
Have you checked to verify if this is a network issue on your server? For instance, does it happen from multiple internet connections, or does it happen for any other servers that you operate?

Thank you.
 

storminternet

Well-Known Member
Nov 2, 2011
460
0
66
cPanel Access Level
Root Administrator
Upload or download speed are mainly depends upon your local internet connection. If you are sure that it is not too slow then check your server's network speed by ethtool or miitool and confirm network card's speed if it is running with half duplex mode or full duplex mode.
Have you also checked if there was high load on server while you download sql backup via phpmyadmin. Sometimes it could slower the server speed.

Another option is to try changing server resolver and check if it make any improvement in server speed.