Help! MySQL dB Restore Problem

Hi everyone,

I need to restore the database of my mambo site v4. However I always end up with these error messages:

Using phpMyAdmin:

--
-- Table structure for table `mos_articles`
--

CREATE TABLE mos_articles (
artid int(11) NOT NULL auto_increment,
catid int(11) NOT NULL default '0',
title text NOT NULL,
userID int(11) NOT NULL default '0',
author varchar(50) default NULL,
content text NOT NULL,
date date NOT NULL default '0000-00-00',
counter int(11) NOT NULL default '0',
approved tinyint(1) NOT NULL default '0',
archived tinyint(1) NOT NULL default '0',
ordering int(11) NOT NULL default '0',
checked_out tinyint(1) NOT NULL default '0',
checked_out_time time NOT NULL default '00:00:00',
editor varchar(50) default NULL,
published tinyint(1) NOT NULL default '0',
PRIMARY KEY (artid),
KEY show (artid, published, catid),
KEY listsections (catid,approved,published,archived)
) TYPE=MyISAM;


MySQL said:

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 'SHOW ( artid, published, catid ) ,
KEY listsections( catid, ap


Using SSH, generated MySql Error 1064 using the command line below:

mysql -u username -p database < /home/arzel/public_html/database.sql


Thank you and hoping for your kind response.

 

 

 

 

Top