Topic: Can't restore from backup
Hi
I have a backup file but when I try to restore it i get the error message
"Error imported backup file, the database probably has not been restored"
I am using the "DB management" plugin.
When I try and upload it through phpmyadmin i get the following error:
------------------------------------------------------------------------------
SQL query:
CREATE TABLE `access` (
`aid` int( 11 ) NOT NULL AUTO_INCREMENT ,
`mask` varchar( 255 ) NOT NULL default '',
`type` varchar( 255 ) NOT NULL default '',
`status` tinyint( 4 ) NOT NULL default '0',
PRIMARY KEY ( `aid` )
) ENGINE = MYISAM DEFAULT CHARSET = utf8--
-- Table structure for akismet
--
CREATE TABLE `akismet` (
`id` int( 10 ) unsigned NOT NULL AUTO_INCREMENT ,
`poster` varchar( 200 ) NOT NULL default '',
`poster_id` int( 10 ) unsigned NOT NULL default '1',
`poster_ip` varchar( 15 ) default NULL ,
`poster_email` varchar( 50 ) default NULL ,
`subject` varchar( 255 ) NOT NULL default '',
`message` text NOT NULL ,
`hide_smilies` tinyint( 1 ) NOT NULL default '0',
`posted` int( 10 ) unsigned NOT NULL default '0',
`edited` int( 10 ) unsigned default NULL ,
`edited_by` varchar( 200 ) default NULL ,
`topic_id` int( 10 ) unsigned NOT NULL default '0',
`forum_id` int( 10 ) unsigned NOT NULL default '0',
PRIMARY KEY ( `id` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1--
-- Table structure for authmap
--
DROP TABLE IF EXISTS `authmap` ;
MySQL said:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE `akismet` (
`id` int(10) unsigned NOT NULL auto_i
----------------------------------------------------------
Any ideas? many thanks
Chantaspell