Support

Site Restoration

#21300 Database restore gets half way - internal server error

Posted in ‘Site restoration’
This is a public ticket

Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.

Environment Information

PHP version
n/a
CMS Type
Other
CMS Version
n/a
Backup Tool Version
n/a
Kickstart version
n/a

Latest post by snaffle on Friday, 24 October 2014 00:44 CDT

snaffle
 Hi there,

I'm trying to migrate a Drupal site with Akeeba Solo and using Kickstart from one server to another. The database restoration falls over about half way through with the following error:

HTTP Request Error
HTTP Status: 500 (Internal Server Error)
Internal status: error
XHR ReadyState: 4
Raw server response:

Which I know doesn't tell you a lot.

By half way I mean that it says it's getting about 9Mb of 25Mb restored and then it generates the error. I've checked phpMyAdmin and about half the db tables are there, so it's connecting to the database fine.

I've look through a heap of support tickets and can't find anything that helps.

In ANGIE at the Database Restoration screen I've tried using MySQLi, MySQL and MySQL (PDO Driver) and they all have pretty much the same result. I've also tried quite a few combinations of the Advanced Options without any success.

Hoping that you have some troubleshooting suggestions for me.

Thanks

Nathan

nicholas
Akeeba Staff
Manager
Without an error I have to guess. Mind you, I am much better at understanding detailed error messages than grasping on straws.

My guess is that you have one of the following hosting related problems:
  • Your host has a very low memory or maximum execution time limit for PHP. You need at least 24Mb of memory limit and 20 seconds of execution time to comfortably restore a site.
  • The server has a maximum query per hour limit which was exceeded, killing the restoration script.
  • The server has a CPU or I/O usage quota. Since the restoration is a CPU and disk intensive operation you exceeded your quota and the restoration was killed.


I think you'll have to contact your host and ask them if any of these is the case.

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

snaffle
Thanks Nicholas, I'll contact them and see what I can find out.

Support Information

Working hours: We are open Monday to Friday, 9am to 7pm Cyprus timezone (EET / EEST). Support is provided by the same developers writing the software, all of which live in Europe. You can still file tickets outside of our working hours, but we cannot respond to them until we're back at the office.

Support policy: We would like to kindly inform you that when using our support you have already agreed to the Support Policy which is part of our Terms of Service. Thank you for your understanding and for helping us help you!