DB table error

已完成 已发布的 Jan 21, 2014 货到付款
已完成 货到付款

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 软件测试 网络主机 网站管理

项目ID: #5344148

关于项目

16个方案 远程项目 活跃的Jan 21, 2014

授予:

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 在1天内
(1条评论)
2.5

有16名威客正在参与此工作的竞标,均价$24/小时

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 更多

$78USD 在1天里
(488条评论)
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 更多

$24USD 在1天里
(163条评论)
6.9
csajit

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

$20USD 在1天里
(156条评论)
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 :)

$23USD 在1天里
(42条评论)
5.6
truongngocthanh

A proposal has not yet been provided

$30USD 在1天里
(26条评论)
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 更多

$25USD 在1天里
(33条评论)
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 在0天内
(8条评论)
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, 更多

$10USD 在1天里
(8条评论)
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 更多

$10 USD 在0天内
(2条评论)
1.0
solutnprovider

A proposal has not yet been provided

$25USD 在1天里
(3条评论)
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 在3天内
(1条评论)
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 更多

$25USD 在1天里
(0条评论)
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 在3天内
(0条评论)
0.0
tomaszkorwel

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

$20USD 在1天里
(0条评论)
0.0