2
Do mySQL export from phpmyadmin and replace all table prefixes with the one they give you, and then import the SQL dump using phpmyadmin again and all should work, make sure you change it in mainfile.php!
EXAMPLE:
CREATE TABLE `xoops_configcategory` (
`confcat_id` smallint(5) unsigned NOT NULL auto_increment,
`confcat_name` varchar(25) NOT NULL default '',
`confcat_order` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`confcat_id`)
) TYPE=MyISAM AUTO_INCREMENT=7 ;
#
# Dumping data for table `xoops_configcategory`
#
INSERT INTO `xoops_configcategory` VALUES (1, '_MD_AM_GENERAL', 0);
INSERT INTO `xoops_configcategory` VALUES (2, '_MD_AM_USERSETTINGS', 0);
INSERT INTO `xoops_configcategory` VALUES (3, '_MD_AM_METAFOOTER', 0);
INSERT INTO `xoops_configcategory` VALUES (4, '_MD_AM_CENSOR', 0);
INSERT INTO `xoops_configcategory` VALUES (5, '_MD_AM_SEARCH', 0);
INSERT INTO `xoops_configcategory` VALUES (6, '_MD_AM_MAILER', 0);
REPLACE XOOPS_ with what they want!!
