Support

Akeeba Backup for WordPress

#23072 Restore from MAMP to siteground vps

Posted in ‘Akeeba Backup for WordPress’
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

WordPress version
n/a
PHP version
n/a
Akeeba Backup version
n/a

Latest post by on Thursday, 03 September 2015 17:20 CDT

Tempo
Nic,

Thank you for creating an akeeba back up for wordpress.

My issues arise with restoring the db.

ANGIE gives me: a Database error processing line 10
Database server error reply:

ErrNo #0
SQL=
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=InnoDB AUTO_INCREMENT=68 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

I attempted to import the db from an export from phpmyadmin and it said in a red box:

Error
SQL query:
/*!40101 SET NAMES utf8mb4 */;
MySQL said: Documentation
#1115 - Unknown character set: 'utf8mb4'

The answers I got on google were over my paygrade!

What do you think I can do?

regards,

Greg Dahl for MTempo
[email protected]

tampe125
Akeeba Staff
Hello Michael,

the error number 0 means that the MySQL service is not running.
You should contact your host and ask help on how setup your server.

Davide Tampellini

Developer and Support Staff

๐Ÿ‡ฎ๐Ÿ‡นItalian: native ๐Ÿ‡ฌ๐Ÿ‡งEnglish: good โ€ข ๐Ÿ• My time zone is Europe / Rome (UTC +1)
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

Tempo
Siteground is not having much luck on their end. Other db's in this account are working. They restarted the servers. I tryed uploading the db directly and MySQL doesn't seem to like the character set. See below.

I've clicked the buttons for force etc. to no effect

Any ideas?

Error
SQL query:

/*!40101 SET NAMES utf8mb4 */;
MySQL said: Documentation

#1115 - Unknown character set: 'utf8mb4'

tampe125
Akeeba Staff
While restoring the database, can you please un-flag all the options except Suppress foreign key checks and No auto value on zero ?

Davide Tampellini

Developer and Support Staff

๐Ÿ‡ฎ๐Ÿ‡นItalian: native ๐Ÿ‡ฌ๐Ÿ‡งEnglish: good โ€ข ๐Ÿ• My time zone is Europe / Rome (UTC +1)
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!