DB table error

Completed Posted Jan 21, 2014 Paid on delivery
Completed Paid on delivery

We have recently migrated to a new hosting provider however part of our website getting table error : Table 'XXXX_XXX.tbl_video' doesn't exist - also Table 'capitalp_capitalp.tbl_users' doesn't exist.

I got full backup file and tried to import throught myPHP admin, but following error message appears:

Error

SQL query:

CREATE TABLE `tbl_users` ( `userid` int(11) NOT NULL AUTO_INCREMENT, `username` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `password` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `first_name` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `last_name` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `fbid` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `email` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `brdate` date NOT NULL, `contact_num` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `gender` enum('Female','Male') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Female', `thumbnail` varchar(150) COLLATE utf8_unicode_ci NOT NULL DEFAULT '[url removed, login to view]', `smallimg` varchar(150) COLLATE utf8_unicode_ci DEFAULT '', `countryid` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `state` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `city` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL, `zipcode` int(11) NOT NULL, `sign[...]

MySQL said: Documentation

#1115 - Unknown character set: 'utf16'

We need someone to fix this asap.

MySQL PHP Software Testing Web Hosting Website Management

Project ID: #5344148

About the project

16 proposals Remote project Active Jan 21, 2014

Awarded to:

aneeshtclt

The utf16 character set is available since MySQL 5.5 and up. You have to upgrade mysql or change utf16 .please contact me

$10 USD in 1 day
(1 Review)
2.5

16 freelancers are bidding on average $24 for this job

rajeshsonisl

Hello, With 99% completion rate, 650+ successfully completed projects, and a 5.00 reputation (maximum possible, 5.0) (Yes, not even 4.99 average rating, can be verified on my profile page !!)... you can never go wro More

$78 USD in 1 day
(488 Reviews)
7.4
tlchung

let fix the sql error now. let fix the sql error now. let fix the sql error now. let fix the sql error now. let fix the sql error now. let fix the sql error now. let fix the sql error now. let fix the sql error now. le More

$24 USD in 1 day
(163 Reviews)
6.9
csajit

LETS GET IT DONE QUICKLY!!!!!! ------------------------------------------------------------- THANKS, AJIT

$20 USD in 1 day
(156 Reviews)
5.9
bdsoft2010

Expert web developer is here working over 5 years in web development. Ready to start right now, very quick solution I have. Please send me message to discuss. thanks :)

$23 USD in 1 day
(42 Reviews)
5.6
truongngocthanh

A proposal has not yet been provided

$30 USD in 1 day
(26 Reviews)
5.1
ALogix

HI, I am Habib experienced php developer, interested to work with you. I have more then six years experience. Fast dedicated experienced professional always available. Please review my profile. I am here give me More

$25 USD in 1 day
(33 Reviews)
4.9
vinergeinfotech

Hello, I have been doing php projects since last 4 years and I can fix this issue within an hour. Please provide me details and let's get started.

$25 USD in 0 days
(8 Reviews)
3.8
webplaceinfo

I am having more than 6 years experience of working as a web developer and having a great exposure of website designing and Development in PHP, MySQL and Open Source Technologies like worddpress, oscommerce, zencart, More

$10 USD in 1 day
(8 Reviews)
3.2
codepen

Hi Dear. I am really happy to get an opportunity to apply to this project. I've read your job description so carefully and finally found out this job is very suitable for my skills and speciality. I have rich ex More

$10 USD in 0 days
(2 Reviews)
1.0
solutnprovider

A proposal has not yet been provided

$25 USD in 1 day
(3 Reviews)
0.8
ramoncho

Hello Graduated in Computer Engineering More than 6 years of experience in Web Development (front / backend) I can start working right now

$20 USD in 3 days
(1 Review)
0.1
jalpakothari07

I am experience in PHOTOSHOP, PHP, MYSQL, JQUERY, JAVASCRIPT and also learning php framework like CODEIGNITER, MAGENTO AND WORDPRESS. Please give me detail of your project. So I can understand it and do your work very More

$25 USD in 1 day
(0 Reviews)
0.0
slavicpaveluc

hello. i am php programmer with 1 year experience . I think this is 10 minutes of work. lets do it!!

$25 USD in 3 days
(0 Reviews)
0.0
tomaszkorwel

Hi I have over 10 years experience with MySQL, I can fix this error within 15 minutes from being awarded.

$20 USD in 1 day
(0 Reviews)
0.0