dbTalk Databases Forums  

Error during restore

comp.databases.mysql comp.databases.mysql


Discuss Error during restore in the comp.databases.mysql forum.



Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old   
Valeria
 
Posts: n/a

Default Error during restore - 01-13-2008 , 08:18 AM






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

Reply With Quote
Reply




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.