Hi,

I'm in the process of moving hosts, I backed up the database using their phpMyAdmin to two .gz files, one containing the structure and the other the data.

However, when I try to restore the structure, I get the following error:

Error
SQL query:

# --------------------------------------------------------
#
# Table structure for table `xoops_block_instance`
#
CREATE TABLE xoops_block_instance(

instanceid int( 12 ) unsigned NOT NULL AUTO_INCREMENT ,
bid int( 12 ) unsigned NOT NULL default '0',
options text NOT NULL ,
title varchar( 255 ) NOT NULL default '',
side tinyint( 1 ) unsigned NOT NULL default '0',
weight smallint( 5 ) unsigned NOT NULL default '0',
visible tinyint( 1 ) unsigned NOT NULL default '0',
bcachetime int( 10 ) unsigned NOT NULL default '0',
PRIMARY KEY ( instanceid ) ,
KEY JOIN ( instanceid, visible, weight )
) TYPE = MYISAM ;



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 'join (instanceid,visible,weight)
) TYPE=MyISAM' at line 11



Does anybody know whats causing this and what I can do about it, help please!!

'Join' is a reserved word in MySQL. Change it to something else, any other non-reserved word will do.

i.e. KEY instid ( instanceid, visible, weight )

this should work

Or redo the database export from phpMyAdmin, and select the option "Enclose table and field names with backquotes".

Thanks for your help. That seems to of worked :)