DB table error

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 '[login to view URL]', `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.