Panama

Just want to start by saying that I do have an alternative way to do the database backup and restore with PhpMyAdmin, so this is more a reality check than a problem to be solved.

I have been using the backup function of Cpanel to backup and restore my mysql databases for years. Worked fast, did the job.

The last couple of times I tried to use the Cpanel database restore it failed. It would seem to upload the Db from my machine, then give me a page that said “restoring Db”, then ... no backup (well, one time I got a partial backup).

The Db I am restoring has grown to over 1 meg. A Google of this issue suggests that the problem might be caused by a PHP timeout with this size file.

Has anyone been able to make the Cpanel database backup work with files larger than 1 meg ?

__________________
www.grandviewwatch.org
Pico

nathon

Best thing to do is probably email support. They have access to the cpanel and apache error logs. They can confirm whether or not the issue is actually due to timeouts.

Overall 1mb is not a large database and it should be restorable but I don't think I can ever recommend the cpanel automated DB restore functions.

FredFredrickson

if PHP times out, there's an option in phpmyadmin to start importing from a certain line. that might help. Sometimes I have to break a sql dump into 3 files and import them one at a time. it's a pain, but I've never seen a restore of a database go smoothly.

__________________

removed

Upload the .sql file to the server, and submit a ticket to support. This is a lot easier when done via command line on the server.

__________________
Unofficial IRC Channel: #surpass EFNet
Unofficial = No official support. Support requests can be submitted to our helpdesk.