(Dec 29) New version 0.9.8-18 has been released

getting error in sql file import

Questions regarding the Database Server
MySQL, PostgreSQL, MariaDB, Percona Server, phpMyAdmin, phpPgAdmin
Forum rules
Before creating a new topic or reply on the forum you should fill out additional fields "Os" and "Web" in your profile section.
In case of violation, the topic can be closed or response from the support will not be received.
Biycchu
Posts: 3
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

cron