getting error in sql file import
Posted: Fri Jul 07, 2017 4:22 pm
Please help me
I am new in vps and vestacp. One of my site hosted in namecheap shared host. Now i am moving this site in my vos vesta panel. When I try to upload database-backup.sql in phpmyadmin i am getting this error.
Is there any different in namecheap shared host phpmyadmin & vestacp phpmyadmin.
Error is:
--
-- Database: `desiwnhf_wall`
--
-- --------------------------------------------------------
--
-- Table structure for table `wlp_commentmeta`
--
CREATE TABLE IF NOT EXISTS `wlp_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_520_ci DEFAULT NULL,
`meta_value` longtext COLLATE utf8mb4_unicode_520_ci,
PRIMARY KEY (`meta_id`),
KEY `comment_id` (`comment_id`),
KEY `meta_key` (`meta_key`(191))
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci AUTO_INCREMENT=1
MySQL said: Documentation
#1273 - Unknown collation: 'utf8mb4_unicode_520_ci'
I am new in vps and vestacp. One of my site hosted in namecheap shared host. Now i am moving this site in my vos vesta panel. When I try to upload database-backup.sql in phpmyadmin i am getting this error.
Is there any different in namecheap shared host phpmyadmin & vestacp phpmyadmin.
Error is:
--
-- Database: `desiwnhf_wall`
--
-- --------------------------------------------------------
--
-- Table structure for table `wlp_commentmeta`
--
CREATE TABLE IF NOT EXISTS `wlp_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_520_ci DEFAULT NULL,
`meta_value` longtext COLLATE utf8mb4_unicode_520_ci,
PRIMARY KEY (`meta_id`),
KEY `comment_id` (`comment_id`),
KEY `meta_key` (`meta_key`(191))
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci AUTO_INCREMENT=1
MySQL said: Documentation
#1273 - Unknown collation: 'utf8mb4_unicode_520_ci'