Originally Said By: basim
I tried to import the sql data into my server but apparently I need access to your server. 
I am a bit bemused by that as the sql file that is supplied should be able to be imported via PHPMyAdmin or similar if you have admin rights.
Try just importing the tables into a database you have already created by just using the sql command to create and populate the tables i.e.
--
-- Table structure for table `engine`
--
CREATE TABLE `engine` (
`engineID` int(11) unsigned NOT NULL auto_increment,
`engineSize` decimal(3,1) NOT NULL,
PRIMARY KEY (`engineID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;
--
-- Dumping data for table `engine`
--
INSERT INTO `engine` (`engineID`, `engineSize`) VALUES
(1, '1.1'),
(2, '1.3'),
(3, '1.6'),
(4, '1.8'),
(5, '2.0'),
(6, '2.5');
-- --------------------------------------------------------
--
-- Table structure for table `manufacturer`
--
CREATE TABLE `manufacturer` (
`manID` int(11) unsigned NOT NULL auto_increment,
`manDesc` varchar(20) NOT NULL,
PRIMARY KEY (`manID`),
FULLTEXT KEY `manDesc` (`manDesc`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
--
-- Dumping data for table `manufacturer`
--
INSERT INTO `manufacturer` (`manID`, `manDesc`) VALUES
(1, 'Ford'),
(2, 'Toyota'),
(3, 'Vauxhall');
-- --------------------------------------------------------
--
-- Table structure for table `model_engine`
--
CREATE TABLE `model_engine` (
`modelID` int(11) NOT NULL,
`engineID` int(11) NOT NULL,
PRIMARY KEY (`modelID`,`engineID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `model_engine`
--
INSERT INTO `model_engine` (`modelID`, `engineID`) VALUES
(1, 4),
(1, 5),
(1, 6),
(2, 2),
(2, 3),
(2, 4),
(3, 1),
(3, 2),
(3, 3),
(4, 3),
(4, 4),
(4, 5),
(5, 2),
(5, 3),
(5, 4),
(6, 1),
(6, 2),
(6, 3),
(7, 4),
(7, 5),
(7, 6),
(8, 3),
(8, 4),
(8, 5),
(9, 1),
(9, 2),
(9, 3);
-- --------------------------------------------------------
--
-- Table structure for table `models`
--
CREATE TABLE `models` (
`modelID` int(11) unsigned NOT NULL auto_increment,
`manID` int(11) NOT NULL,
`modelDesc` varchar(20) NOT NULL,
PRIMARY KEY (`modelID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;
--
-- Dumping data for table `models`
--
INSERT INTO `models` (`modelID`, `manID`, `modelDesc`) VALUES
(1, 1, 'Mondeo'),
(2, 1, 'Focus'),
(3, 1, 'Fiesta'),
(4, 2, 'Avensis'),
(5, 2, 'Auris'),
(6, 2, 'Yaris'),
(7, 3, 'Vectra'),
(8, 3, 'Astra'),
(9, 3, 'Corsa');
It works as the zip has been downloaded from my site many many times and the number of questions I get are minimal.
