Problems activating your account? Send notification email to: admin@post4vps.com
Host4Fun Budget VPS Hosting
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Database Import Error
#1
Hello experts, I have transferred my website from one host to a new one.I have a backup of mysql database.Whenever i import database it shows error.
My SQL Said : 
#1273 - Unknown collation: 'utf8mb4_unicode_520_ci' 



-- --------------------------------------------------------

--
-- Table structure for table `wp_commentmeta`
--

CREATE TABLE `wp_commentmeta` (
 `meta_id` bigint(20) UNSIGNED NOT NULL,
 `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
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
#2
Depending on which version of MySQL is running on the server it might not even support the collate "utf8mb4_unicode_520_ci" and will show you this error.

Try to remove "COLLATE utf8mb4_unicode_520_ci" from the whole database backup (make sure you make a copy of it before removing anything or changing anything). After that try to import the database without this code.
With best regards
Hidden Refuge
IT specialist for system integration



Friedrich Nietzsche Wrote:The advantage of a bad memory is that one enjoys several times the same good things for the first time.
#3
(02-05-2019, 07:35 AM)Hidden Refuge Wrote:  Depending on which version of MySQL is running on the server it might not even support the collate "utf8mb4_unicode_520_ci" and will show you this error.

Try to remove "COLLATE utf8mb4_unicode_520_ci" from the whole database backup (make sure you make a copy of it before removing anything or changing anything). After that try to import the database without this code.
Thanks @Hidden Refuge i have replaced those lines by " utf8mb4_general_ci ".It is working fine now.
#4
Looks as though inquiry has been answered to the satisfaction of the author of the topic. Am closing this topic to prevent spam responses. If anyone wishes it to be re-opened for further discussion please PM me.
[Image: 4ax8Kok.png]
Thank you to Post4VPS and VirMach for my super fast VPS 9!
- DH Blog




 


Possibly Related Threads...
Thread Author Replies Views Last Post
  Database Problems Rehan 7 378 05-15-2019, 11:46 AM
Last Post: Rehan

Forum Jump:


Users browsing this thread: 1 Guest(s)

Sponsors: VirMach - Host4Fun - CubeData - Evolution-Host - HostDare - SSDBlaze - VPSlices - Abc-Hosters - Hyper Expert - Shadow Hosting - Bladenode - HostDoc - Hostlease


About Post4VPS

Post4VPS is a forum/destiny where you can Delploy Your Free VPSs just by the Power of Posts.

We Provide VPSs of many locations like Germany,US,Canada,France,London,etc.

We also Provide VPSs of Both Linux and Windows OS.