JayBlackwood

A few questions about backups and a comment....

I attempted to restore a backup of the mambo database and it failed. The mos_components table has a field in it named 'option' and this is also a keyword in mySQL (or acts like one) and you get a syntax error when you attempt to restore the db. I changed 'option' to 'zoption' in the SQL, ran the SQL in myPhpAdmin, and then rename the 'zoption' back to 'option'. This worked thankfully.

Here's an example of a SQL line that fails:

DROP TABLE IF EXISTS mos_components;
CREATE TABLE mos_components (
id int(11) NOT NULL auto_increment,
name varchar(50) NOT NULL default '',
link varchar(255) NOT NULL default '',
menuid int(11) unsigned NOT NULL default '0',
parent int(11) unsigned NOT NULL default '0',
admin_menu_link varchar(255) NOT NULL default '',
admin_menu_alt varchar(255) NOT NULL default '',
option varchar(50) NOT NULL default '',
ordering int(11) NOT NULL default '0',
admin_menu_img varchar(255) NOT NULL default '',
iscore tinyint(4) NOT NULL default '0',
params text NOT NULL,
PRIMARY KEY (id)
) TYPE=MyISAM;

FYI - The backup was generated using the backup available in CPanel. Clearly it needed to escape the field name 'option'.

Question #1) - Is there a way in the SQL syntax to get it to understand it is a field name and not a keyword?

Comment #1) - Isn't this an example why it wasn't necessarily a good idea to get rid of the native backup? I actually agree with the long term decision to do this but for now?

Ektoras

Yes. You can escape reserved words using backquotes. More details here.
Importing SQL file into MSAS

JayBlackwood

Thanks. I obviously didn't search this forum enought before asking the question!