(Wordpress) Having an issue getting sql file uploaded to overwrite a database

I have a ,sql database that was created by a developer. I am trying to get that wordpress database imported. For some reason, it will not work and I get this error:

#1273 - Unknown collation: 'utf8mb4_unicode_520_ci'

I just need to get the database imported.

I am using MySQL and I am on SEO Hosting (Host Gator)

Skills: HTML, MySQL, PHP, SQL, WordPress

See more: back end work needed for wordpress, wordpress sql file, wordpress dictionary sql file, import wordpress database phpmyadmin, restore wordpress database to new server, how to restore wordpress backup cpanel, wordpress import database plugin, how to restore wordpress site from backup, how to restore wordpress site without backup, export wordpress database phpmyadmin, wordpress import sql file, php, mysql, css, html, wordpress, database administration, database development, codeigniter, cakephp

About the Employer:
( 108 reviews ) Los Angeles, United States

Project ID: #16113487

Awarded to:


Hi. I can fix the file for you so it is imported successfully. I'm available to do it immediately. I have a total of 15+ years in the IT Industry including two Microsoft Professional Certificates and have been worki More

$20 USD in 0 days
(457 Reviews)

36 freelancers are bidding on average $25 for this job


Hi i can work for (Wordpress) Having an issue getting sql file uploaded to overwrite a database i am expert at ,HTML,MySQL,PHP,SQL,WordPress So send me Private message at PMB so we can discuss more about it Than More

$30 USD in 1 day
(511 Reviews)

Hi let me replace the database for you, ready to start now...thanks! Relevant Skills and Experience MySQL,php

$15 USD in 1 day
(659 Reviews)

Hello there, I have experienced such error before and I was able to fix it. I can get the database dump import into your database. Ready to get started immediately. Regards Adeola

$25 USD in 1 day
(387 Reviews)

Hello, This is happening because you are using different versions of mysql on two different servers, this could be fixed and I have done that various times, but we need to export the database again with some tweaks. More

$30 USD in 1 day
(197 Reviews)

Modifying the database to change the collation should solve the problem, I can do it for you. Will need the database dump to do the work. Let me know if you're interested!

$25 USD in 0 days
(346 Reviews)

hello, as the error suggests, the encoding is not correct. if the encoding string is replaced, then DB will import. please message me back to get started right away.

$15 USD in 1 day
(309 Reviews)
$61 USD in 1 day
(201 Reviews)

Hi, I'm interested in doing your work. We can do it now. I'm ready for interview and feel free if you have any query and contact me anytime 24*7 will be available here. Open source (WordPress, Joomla, Drupal, More

$10 USD in 0 days
(148 Reviews)

Sir I have more than 4 years experience as web developer and I have already fixed similar type of issue before you can check my profile,we can talk more over [login to view URL]

$15 USD in 0 days
(125 Reviews)

Hi, Greetings of the day!! Thanks for review my Bid. I have gone through from your description and can do this work comfortably. I have 6+ years experience in development and i have done lot's of projec More

$25 USD in 1 day
(68 Reviews)

Hello, I am well expert in WORDPRESS. I design, develop and fix WordPress websites as per clients requirements. I have worked on plenty of WordPress projects. Wordpress [login to view URL] [login to view URL] More

$30 USD in 1 day
(86 Reviews)

Hello! I'm an advanced WordPress developer with 7 years of experience.I have read the requirements mentioned in the project description, Please come on chat to discuss more details. I built many websites using wordpr More

$30 USD in 1 day
(102 Reviews)

Hi, I can fix that for you in a minute, if you need it right now. Let's chat now if you have time Thanks

$20 USD in 1 day
(36 Reviews)

Hi, I read carefully your project, and I wanna do it for you. If you wanna work together, send me a message to discuss details. I am an experienced Web Developer and Web Designer, and have worked with wide variety of s More

$20 USD in 1 day
(52 Reviews)

Dear Client, I have gone through information provided and read to work with you. I can immediately start your work. Waiting for a positive response on chat. I can show my work on chat. Skills: HTML, CSS, WP, MySQL More

$55 USD in 1 day
(49 Reviews)

Hi i can solve issue for #1273 - Unknown collation: 'utf8mb4_unicode_520_ci' lets talk . send message at pmb Thanks

$20 USD in 1 day
(48 Reviews)

Hi, I'm an experienced Wordpress/LINUX developer from Hanoi, Vietnam I can help you , you can contact with me in inbox i provide you high quality work. Hope to hear your soon, Best regards ! Wordpress Linux More

$25 USD in 1 day
(35 Reviews)

Hi ,I am word press Specialist I'm all Plug-in & theme easily install.I have good experience in SEO. Please initiate chat to discuss further.

$25 USD in 1 day
(24 Reviews)

Please provide the server phpmyadmin details and the sql file you are trying to import. I can fix this

$35 USD in 1 day
(8 Reviews)

Hi please come for project discussion so we can discuss more in details of the project and start work together I will work in your budget and timeframe as per you require. Sincerely, Sneha Kanwar

$25 USD in 1 day
(16 Reviews)