Yes you can use either notepad or wordpad, or any other text editor that does not add formatting to the text.

The sql file from what I see looks correct. It will drop, create tables, then insert data into those tables. Would not know for sure with out testing. For anything adding tables manually to my database I test it on my test site first.

HTH.

Hi jdseymour!

For avoiding more mistakes, please confirm me if these are the rows that I have to delete. This is: from the row before "-- Table structure for table `xoops_is_daycount`" to two rows before "--
-- Table structure for table `xoops_marquee`". Is it right? Please, I wait your answer to delete it...
Thank you very much

ReySolar



--
-- Dumping data for table `xoops_imgsetimg`
--



--
-- Table structure for table `xoops_is_daycount`
--

CREATE TABLE `xoops_is_daycount` (
`id` int(10) NOT NULL auto_increment,
`date` date NOT NULL default '0000-00-00',
`daycount` int(10) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM;

--
-- Dumping data for table `xoops_is_daycount`
--



--
-- Table structure for table `xoops_is_mth`
--

CREATE TABLE `xoops_is_mth` (
`id` int(5) NOT NULL auto_increment,
`mth` char(2) NOT NULL default '',
`year` int(5) NOT NULL default '0',
`count` int(10) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM;

--
-- Dumping data for table `xoops_is_mth`
--



--
-- Table structure for table `xoops_is_mth_days`
--

CREATE TABLE `xoops_is_mth_days` (
`day` char(2) NOT NULL default '',
`count` int(10) NOT NULL default '0'
) TYPE=MyISAM;

--
-- Dumping data for table `xoops_is_mth_days`
--


INSERT INTO `xoops_is_mth_days` VALUES ('01',0);
INSERT INTO `xoops_is_mth_days` VALUES ('02',0);
INSERT INTO `xoops_is_mth_days` VALUES ('03',0);
INSERT INTO `xoops_is_mth_days` VALUES ('04',0);
INSERT INTO `xoops_is_mth_days` VALUES ('05',0);
INSERT INTO `xoops_is_mth_days` VALUES ('06',0);
INSERT INTO `xoops_is_mth_days` VALUES ('07',0);
INSERT INTO `xoops_is_mth_days` VALUES ('08',0);
INSERT INTO `xoops_is_mth_days` VALUES ('09',0);
INSERT INTO `xoops_is_mth_days` VALUES ('10',0);
INSERT INTO `xoops_is_mth_days` VALUES ('11',0);
INSERT INTO `xoops_is_mth_days` VALUES ('12',0);
INSERT INTO `xoops_is_mth_days` VALUES ('13',0);
INSERT INTO `xoops_is_mth_days` VALUES ('14',0);
INSERT INTO `xoops_is_mth_days` VALUES ('15',0);
INSERT INTO `xoops_is_mth_days` VALUES ('16',0);
INSERT INTO `xoops_is_mth_days` VALUES ('17',0);
INSERT INTO `xoops_is_mth_days` VALUES ('18',0);
INSERT INTO `xoops_is_mth_days` VALUES ('19',0);
INSERT INTO `xoops_is_mth_days` VALUES ('20',0);
INSERT INTO `xoops_is_mth_days` VALUES ('21',0);
INSERT INTO `xoops_is_mth_days` VALUES ('22',0);
INSERT INTO `xoops_is_mth_days` VALUES ('23',0);
INSERT INTO `xoops_is_mth_days` VALUES ('24',0);
INSERT INTO `xoops_is_mth_days` VALUES ('25',0);
INSERT INTO `xoops_is_mth_days` VALUES ('26',0);
INSERT INTO `xoops_is_mth_days` VALUES ('27',0);
INSERT INTO `xoops_is_mth_days` VALUES ('28',0);
INSERT INTO `xoops_is_mth_days` VALUES ('29',0);
INSERT INTO `xoops_is_mth_days` VALUES ('30',0);
INSERT INTO `xoops_is_mth_days` VALUES ('31',0);

--
-- Table structure for table `xoops_is_referer`
--

CREATE TABLE `xoops_is_referer` (
`id` int(10) NOT NULL auto_increment,
`url` varchar(255) NOT NULL default '',
`count` int(10) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM;

--
-- Dumping data for table `xoops_is_referer`
--



--
-- Table structure for table `xoops_is_today_hour`
--

CREATE TABLE `xoops_is_today_hour` (
`hour` char(2) NOT NULL default '',
`count` int(10) NOT NULL default '0'
) TYPE=MyISAM;

--
-- Dumping data for table `xoops_is_today_hour`
--


INSERT INTO `xoops_is_today_hour` VALUES ('00',0);
INSERT INTO `xoops_is_today_hour` VALUES ('01',0);
INSERT INTO `xoops_is_today_hour` VALUES ('02',0);
INSERT INTO `xoops_is_today_hour` VALUES ('03',0);
INSERT INTO `xoops_is_today_hour` VALUES ('04',0);
INSERT INTO `xoops_is_today_hour` VALUES ('05',0);
INSERT INTO `xoops_is_today_hour` VALUES ('06',0);
INSERT INTO `xoops_is_today_hour` VALUES ('07',0);
INSERT INTO `xoops_is_today_hour` VALUES ('08',0);
INSERT INTO `xoops_is_today_hour` VALUES ('09',0);
INSERT INTO `xoops_is_today_hour` VALUES ('10',0);
INSERT INTO `xoops_is_today_hour` VALUES ('11',0);
INSERT INTO `xoops_is_today_hour` VALUES ('12',0);
INSERT INTO `xoops_is_today_hour` VALUES ('13',0);
INSERT INTO `xoops_is_today_hour` VALUES ('14',0);
INSERT INTO `xoops_is_today_hour` VALUES ('15',0);
INSERT INTO `xoops_is_today_hour` VALUES ('16',0);
INSERT INTO `xoops_is_today_hour` VALUES ('17',0);
INSERT INTO `xoops_is_today_hour` VALUES ('18',0);
INSERT INTO `xoops_is_today_hour` VALUES ('19',0);
INSERT INTO `xoops_is_today_hour` VALUES ('20',0);
INSERT INTO `xoops_is_today_hour` VALUES ('21',0);
INSERT INTO `xoops_is_today_hour` VALUES ('22',0);
INSERT INTO `xoops_is_today_hour` VALUES ('23',0);

--
-- Table structure for table `xoops_marquee`
--