DB table error
$10-30 USD
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.
Project ID: #5344148
About the project
Awarded to:
The utf16 character set is available since MySQL 5.5 and up. You have to upgrade mysql or change utf16 .please contact me
16 freelancers are bidding on average $24 for this job
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
LETS GET IT DONE QUICKLY!!!!!! ------------------------------------------------------------- THANKS, AJIT
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 :)
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.
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
Hello Graduated in Computer Engineering More than 6 years of experience in Web Development (front / backend) I can start working right now
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
hello. i am php programmer with 1 year experience . I think this is 10 minutes of work. lets do it!!
Hi I have over 10 years experience with MySQL, I can fix this error within 15 minutes from being awarded.