Page 1 of 1

getting error in sql file import

Posted: Fri Jul 07, 2017 4:22 pm
by Biycchu
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'