PHPMyadmin cant export SQL?

Connection with the server was reset

[jaymullah]

When I try to export my SQL from a database in phpmyadmin it starts downloading and before finished it says "The connection with the server was reset." I have tried past couple of weeks only to get the same error.

I have a newly setup VPS server running CentOS. I'm not sure if it's because of a setting on my server, or some other reason.

Can anyone give me any clues as to what to check?

The strange thing is, I have a version of PHP Nuke CMS that has a built in SQL database backup utility and it does backups just fine. But if I go to phpmyadmin through Cpanel and do a manual export the connection to server resets.

Thanks for any and all help :)

[DrQuincy]

Is the browser timing out?

[barns101]

The strange thing is, I have a version of PHP Nuke CMS that has a built in SQL database backup utility and it does backups just fine. But if I go to phpmyadmin through Cpanel and do a manual export the connection to server resets.

I have come across this before and it sounds like the script is timing out. You could increase the PHP maximum execution time to give the script longer to run, or just use the PHP Nuke SQL database backup utility (I assume you then download the SQL file via FTP).

[jatar_k]

Welcome to WebmasterWorld jaymullah,

your other option would be to run the mysqldump [dev.mysql.com] from the command line

[jaymullah]

Thank you barns101, I will try to increase the PHP maximum execution time and see if that fixes it. The method using PHP Nuke's backup utility works fine for now, however I want to fix the problem because I use phpmyadmin for many other scripts other than Nuke. I will try your suggestion and let you know :)

Thank you for the welcome jatar_k, this site looks loaded with information, I will enjoy my membership here. Also thank you for the link you provided, I wasn't aware of that method, it is extremly helpful.

[jatar_k]

that's all phpmyadmin does is issue that command for you

for larger db's I have always had to do it from the command line

[barns101]

For those of us without command line access, there's a free program called MySQL Monitor from a company called Quicomm (I wont post a link because it's not open source) that will save a database dump in your webspace and so avoid the timeout issue.