Support

Site Restoration

#32140 Database restore fails

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 on Thursday, 16 January 2020 17:17 CST

[email protected]
Hello

I'm trying to restore the Akeeba Joomla Backup to Azure but the database restore stops after 1-2 MB with errors on different line numbers:

Database error processing line 50

Database server error reply:
ErrNo #1030

Got error 1 from storage engine
SQL=CREATE TABLE `mm_fsf_data` (
`table` varchar(50) NOT NULL,
`prikey` varchar(250) NOT NULL,
PRIMARY KEY (`table`,`prikey`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8

Raw query text:

CREATE TABLE `mm_fsf_data` (
`table` varchar(50) NOT NULL,
`prikey` varchar(250) NOT NULL,
PRIMARY KEY (`table`,`prikey`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8



[Database error processing line 46

Database server error reply:
ErrNo #1030

Got error 1 from storage engine
SQL=CREATE TABLE `mm_fsf_data` (
`table` varchar(50) NOT NULL,
`prikey` varchar(250) NOT NULL,
PRIMARY KEY (`table`,`prikey`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8

Raw query text:

CREATE TABLE `mm_fsf_data` (
`table` varchar(50) NOT NULL,
`prikey` varchar(250) NOT NULL,
PRIMARY KEY (`table`,`prikey`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8

Any help is appreciated.
Thank you and kind regards
Erwin

nicholas
Akeeba Staff
Manager
MySQL error 1030 means that MySQL could not perform the operation because of a problem at the storage engine level (reference). This could mean different things such as the database being corrupt, running out of disk space, MySQL not having adequate permissions to write to its on-disk database files etc. This is something you need to contact your host about. The problem ultimately comes from the database server experiencing an error related to its configuration or the server environment. It's not something we can work around or help you fix.

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!

System Task
system
This ticket has been automatically closed. All tickets which have been inactive for a long time are automatically closed. If you believe that this ticket was closed in error, please contact us.

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!