Support

Akeeba Backup for Joomla!

#8559 Error at restoring database

Posted in ‘Akeeba Backup for Joomla! 4 & 5’
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

Joomla! version
n/a
PHP version
n/a
Akeeba Backup version
n/a

Latest post by dlb on Monday, 09 August 2010 09:06 CDT

user13077
I am trying to restore my site and have come across an error on the DB restore tab of kickstart 3.1. When I click next to begin the database restore, I get an error shortly after it begins to create the database. The error is as follows:

Error at the line 0: CREATE TABLE `akb_ak_profiles` ( `id` int(10) unsigned NOT NULL auto_increment, `description` varchar(255) NOT NULL, `configuration` longtext, `filters` longtext, PRIMARY KEY (`id`) ) TYPE=I ... MySQL: MySQL query failed with error 1005 (Can't create table '.\ethnobotanylife\jos_ak_profiles.frm' (errno: 121)). The query was:CREATE TABLE `jos_ak_profiles` ( `id` int(10) unsigned NOT NULL auto_increment, `description` varchar(255) NOT NULL, `configuration` longtext, `filters` longtext, PRIMARY KEY (`id`) ) TYPE=InnoDB AUTO_INCREMENT=2

Can someone help me with this?

dlb
First, don't use kickstart 3.1! There is a major extraction bug that has been fixed in kickstart 3.1.1. The extraction bug would not cause this error.

Kickstart is just the extractor, you are beyond kickstart and into the installation script at this stage. It's a picky point, but sometimes it makes a difference when you're describing the problem to us. :)

The error has something to do with you using the InnoDB engine. Please make sure the InnoDB engine is available on this MySQL server.


Dale L. Brackin
Support Specialist


us.gifEnglish: native


Please keep in mind my timezone and cultural differences when reading my replies. Thank you!


????
My time zone is EST (UTC -5) (click here to see my current time in Philadelphia, PA)

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!