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(8) 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(8) 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
Do your backups form the host or phpmyadmin.
https://wiki.simplemachines.org/smf/Backup
i did try that from phpmyadmin and thats even worse. and the host doesnt have that facility
If you can't dump the database, run, don't walk, to a better host.