Error during restore

When I try to restore a backup on a local machine ... during the restore
I obtain this error

Error while executing this query:CREATE TABLE `webstati` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`descrizione` char(50) DEFAULT NULL,
`sigla` char(4) DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=278 DEFAULT CHARSET=latin1;
The server has returned this error message: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 'USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=278 DEFAULT CHARSET=latin1' at line 5
MySQL Error.


Can you help me?

Thanks

On Sun, 13 Jan 2008 15:18:42 +0100, Valeria <vali@libero.it> wrote:

> When I try to restore a backup on a local machine ... during the restore
> I obtain this error
>
> Error while executing this query:CREATE TABLE `webstati` (
> `id` int(11) NOT NULL AUTO_INCREMENT,
> `descrizione` char(50) DEFAULT NULL,
> `sigla` char(4) DEFAULT NULL,
> PRIMARY KEY (`id`) USING BTREE
> ) ENGINE=InnoDB AUTO_INCREMENT=278 DEFAULT CHARSET=latin1;
> The server has returned this error message: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 'USING BTREE
> ) ENGINE=InnoDB AUTO_INCREMENT=278 DEFAULT CHARSET=latin1' at line 5
> MySQL Error.

http://bugs.mysql.com/bug.php?id=25162
http://bugs.mysql.com/bug.php?id=27890


Ideally, you would've used the same server. If not, use an editor to
either change the order around in the sql dump, or remove the USING
statements all together. Temporary workaround to avoid this in future is
mentioned in bugreport (using compat mode, which will unfortunatelly also
alter some other aspects of the dump).
--
Rik Wasmus