im trying to import a database and im getting these errors

[yh555]

i did a back up from the forum and have tried to import it into the database.

CREATE TABLE `smf_messages` (
`id_msg` int(10) unsigned NOT NULL auto_increment,
`id_topic` mediumint( unsigned NOT NULL default 0,
`id_board` smallint(5) unsigned NOT NULL default 0,
`poster_time` int(10) unsigned NOT NULL default 0,
`id_member` mediumint( unsigned NOT NULL default 0,
`id_msg_modified` int(10) unsigned NOT NULL default 0,
`subject` varchar(255) NOT NULL default '',
`poster_name` varchar(255) NOT NULL default '',
`poster_email` varchar(255) NOT NULL default '',
`poster_ip` varchar(255) NOT NULL default '',
`smileys_enabled` tinyint(4) NOT NULL default 1,
`modified_time` int(10) unsigned NOT NULL default 0,
`modified_name` varchar(255) NOT NULL default '',
`body` text NOT NULL,
`icon` varchar(16) NOT NULL default 'xx',
`approved` tinyint(3) NOT NULL default 1,
PRIMARY KEY (`id_msg`),
UNIQUE `topic` (`id_topic`, `id_msg`),
UNIQUE `id_board` (`id_board`, `id_msg`),
UNIQUE `id_member` (`id_member`, `id_msg`),
KEY `approved` (`a[...]

MySQL said: Documentation
#1071 - Specified key was too long; max key length is 1000 bytes


also getting Table '9kHxAt1kD6BIwmw0qaeFbg86OCk6UoCG.smf_settings' doesn't exist from the url

[Kindred]

Do your backups form the host or phpmyadmin.
https://wiki.simplemachines.org/smf/Backup

[yh555]

i did try that from phpmyadmin and thats even worse. and the host doesnt have that facility

[Sir Osis of Liver]

If you can't dump the database, run, don't walk, to a better host.