Hello,

I hope this is the right place to post, I'm new. :stickout:

I am having an issue with my host's server that I can't seem to get resolved and I was hoping I could maybe get some help here. I have a CPanel 11 reseller account (I do not have access to anything more than CPanel, no SSH or shell access) with my web host. Lately CPanel and PHPMyAdmin have been acting up. I have contacted my host about my issues and they have not been able to find the source of the problem, so I hope someone here can help me.

My issue is this: Lately I am having issues downloading database backups from PHPMyAdmin, sometimes. Sometimes I will go to download a database backup from PHPMyAdmin and the download will stall partway through or otherwise hang. It never aborts, it just hangs there. Other times I can download the backups fine. Also, sometimes I will try and download a backup and have it fail. Then I will try to re-download the backup and I cannot, I need to completely exit out of my browser and re-login to my CPanel before I can get back into PHPMyAdmin; simply re-clicking the PHPMyAdmin link will just hang on the CPanel Redirecting to PHPMyAdmin page.

I have tried downloading the backups on both IE and Firefox and the same hanging occurs on both browsers. My host has been unable to find the source of this problem, even after contacting a CPanel tech. While this is happening my website is online and I can browse it and the internet just fine. I am hoping that one of you has seen this issue before and knows how to fix this.

Thanks,
BMR777

If you have ssh, you can do mysqldump -u username -p password database_name > dump.sql

Thanks PersonalJihad, but I do not have SSH on my account.

If you have access to cronjobs in cpanel you can always run that command at a certain time and then download the file through ftp.

Ok, thanks. By default, if I ran the command just like that (after specifying my username, pass and db name), where would it save the backup, just in my home directory? Or do I need to specify my home directory to save the file there? Also, with a large database is there any chance of this causing the server to stall or experience excess load that would get me in trouble with my host? The database has about 5,000 records on it.

Thanks,
BMR777

I'm not sure where it would actually dump the sql, it would dump in the same directory as where it was run from. You can try to cd to your home directory at the beginning of the cronjob though.