Support

Site Restoration

#24519 Database Error On Restore

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 mfbrowne on Wednesday, 24 February 2016 08:02 CST

mfbrowne
 Hello,
I get the following error when trying to restore. I have updated to the latest MySQL because of other tickets that say the UTFMb4 must be available. I am running an older version of MySQL as well and the new version on port 3307, but how do I change the port on a restore in kickstart.

Thanks for any response

Mike

The error I get is :

Database error processing line 15

Database server error reply:
ErrNo #0 SQL=

Raw query text:
CREATE TABLE `#__commentmeta` ( `meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `comment_id` bigint(20) unsigned NOT NULL DEFAULT '0', `meta_key` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `meta_value` longtext COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`meta_id`), KEY `comment_id` (`comment_id`), KEY `meta_key` (`meta_key`(191)) ) ENGINE=MyISAM AUTO_INCREMENT=780 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

mfbrowne
Hello,

Well after searching around a bit more I determined how to change the port.

Thanks

Mike

dlb
Kickstart is just the extractor, it doesn't do anything beyond that. When it is finished extracting, it hands off control to the restore script, which is embedded in your backup archive. The restore script will prompt you for the database connection details, including the port number to use. It defaults to the standard port, 3306?, if you don't fill it in.

Sorry, I was just writing the answer. :-(


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)

mfbrowne
Hello Dale,

Thanks for responding.

Well the restore script that I have from the latest Kickstart download does not have the port number for the database. However I figured if I entered localhost:3307 the port might be identified, which is true.

Mike

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!