Problem importing database back to MySql

shubb · 11-29-2005, 01:52 AM

I had Mambo running on my Slackware 9.x server just fine. I did a fresh install of 10.2, and now I cannot get the old database to import back to MySQL.

The error I get is

Code:

ERROR 1064 (42000) at line 145: 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 'option varchar(50) NOT NULL default '',
  ordering int(11) NOT NULL default '0',' at line 9

The referenced line in the import file is

Code:

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;

I am running the stock 4.1.14 MySQL that comes with Slackware 10.2.

fouldsy · 11-29-2005, 04:06 AM

At a guess, maybe you're running a different vesion of MySQL than you had on your old box. I've come across problems importing .sql from different versions depending on how it was exported. If you're running phpmyadmin, whilst choosing to import there should an option to select the input version.

shubb · 11-29-2005, 12:45 PM

Ok, I tried using phpMyAdmin, and it has the same problem. By the way, there is no option for selecting the input version.

It appears that it doesnt like the column name "option". When I try to import, the admin shows me the attempted import. It puts all the known MySQL commands in capital letters. It was having a problem with the "option" keyword being used as a column name. I changed it (and another invalid column name) and it imported ok. Now I just have to make sure it didnt break any of the php...

Thanks for the help!

deiussum · 11-29-2005, 01:36 PM

"option" sounds like a possible keyword. You probably could have quoted it to keep the column name the same.