getting error in sql file import

Questions regarding the Database Server
MySQL, PostgreSQL, MariaDB, Percona Server, phpMyAdmin, phpPgAdmin
Biycchu
Posts: 1
Joined: Fri Jul 07, 2017 2:46 pm

getting error in sql file import

Postby Biycchu » 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'
Last edited by Biycchu on Fri Jul 07, 2017 4:23 pm, edited 1 time in total.

Return to “Database Server”



Who is online

Users browsing this forum: No registered users and 2 guests