arrow_upward

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;

Thanks to Post4VPS and Hostlease for their great services.  
lockThread Closed 


Messages In This Thread
Database Import Error - by Rehan - 02-05-2019, 06:00 AM
RE: Database Import Error - by Mashiro - 02-05-2019, 07:35 AM
RE: Database Import Error - by Rehan - 02-05-2019, 08:44 AM
RE: Database Import Error - by deanhills - 02-05-2019, 04:57 PM

Possibly Related Threads…
Thread
Author
Replies
Views
Last Post
6,017
03-28-2021, 03:36 PM
Last Post: deanhills
4,411
05-15-2019, 11:46 AM
Last Post: Rehan

person_pin_circle Users browsing this thread: 2 Guest(s)
Sponsors: VirMach - Host4Fun - CubeData - Evolution-Host - HostDare - Hyper Expert - Shadow Hosting - Bladenode - Hostlease - RackNerd - ReadyDedis - Limitless Hosting