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

Re: Can't restore from backup

How did you create this backup?

Re: Can't restore from backup

Hi

Sorry, forgot to say, i used the "backup" module ap_backup.php

Cheers

c

Re: Can't restore from backup

Oh, that plugin really doesn't work so well wink
You're missing semicolons at the end of the SQL queries

Re: Can't restore from backup

Hmmmm, so if the back up file consists of many segments like the two below, where do I add the semicolons?


--
-- Table structure for access
--

DROP TABLE IF EXISTS `access`;
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


Many thanks again!

Re: Can't restore from backup

After the default charset bit

Re: Can't restore from backup

That worked a treat! Thanks a million big_smile