Vesta Control Panel - Forum

Community Forum

Skip to content

Advanced search
  • Quick links
    • Main site
    • Github repo
    • Google Search
  • FAQ
  • Login
  • Register
  • Board index Main Section Database Server
  • Search

getting error in sql file import

Questions regarding the Database Server
MySQL, PostgreSQL, MariaDB, Percona Server, phpMyAdmin, phpPgAdmin
Post Reply
  • Print view
Advanced search
1 post • Page 1 of 1
Biycchu
Posts: 6
Joined: Fri Jul 07, 2017 2:46 pm

getting error in sql file import
  • Quote

Post by 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.
Top


Post Reply
  • Print view
1 post • Page 1 of 1

Return to “Database Server”



  • Board index
  • All times are UTC
  • Delete all board cookies
  • The team
Powered by phpBB® Forum Software © phpBB Limited
*Original Author: Brad Veryard
*Updated to 3.2 by MannixMD
 

 

Login  •  Register

I forgot my password