Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Problem uploading my database to host server

Status
Not open for further replies.
Floodster

Floodster

Technical User
Jan 28, 2005
204
HI,
I've read on how to do the above but I keep getting an error or "No Sql query!" in my phpmyadmin.

I have created a dump of my database using DB Tools. I then log into my server & from the cpanel I choose mysql admin tool. I then choose the SQL tab & choose the file & then get the above error!?!?!

I have opened the file in notepad & here is the code;
Code: 
-- MySQL dump 10.10
--
-- Host: localhost    Database: mbdata
-- ------------------------------------------------------
-- Server version	5.0.21-community-nt

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `tbl_events`
--

DROP TABLE IF EXISTS `tbl_events`;
CREATE TABLE `tbl_events` (
  `order` int(10) default NULL,
  `Event` varchar(255) default NULL,
  `norder` int(10) default NULL,
  `event2` varchar(255) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_events`
--


/*!40000 ALTER TABLE `tbl_events` DISABLE KEYS */;
LOCK TABLES `tbl_events` WRITE;
INSERT INTO `tbl_events` VALUES (5,'Cape Hill Cup',5,'Cape_Hill_Cup'),(1,'Captains Cup',1,'Captains_Cup'),(3,'Committee Shield',3,'Committee_Shield'),(2,'Deers Leap',2,'Deers_Leap'),(7,'Player of the Year',7,'Player_of_the_Year'),(6,'Presidents Putter',6,'Presidents_Putter'),(4,'Terry Hillin Challenge Cup',4,'Terry_Hillin_Challenge_Cup');
UNLOCK TABLES;
/*!40000 ALTER TABLE `tbl_events` ENABLE KEYS */;

--
-- Table structure for table `tbl_fixtures`
--

DROP TABLE IF EXISTS `tbl_fixtures`;
CREATE TABLE `tbl_fixtures` (
  `id` int(11) NOT NULL auto_increment,
  `Venue` varchar(50) default NULL,
  `Event` varchar(50) default NULL,
  `link` varchar(50) default NULL,
  `ddate` date default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_fixtures`
--


/*!40000 ALTER TABLE `tbl_fixtures` DISABLE KEYS */;
LOCK TABLES `tbl_fixtures` WRITE;
INSERT INTO `tbl_fixtures` VALUES (1,'Kidderminster','Captains Cup','[URL unfurl="true"]http://www.kidderminstergolfclub.com','2006-04-13'),(2,'Walmley','Deers[/URL] Leap','[URL unfurl="true"]http://www.walmleygolfclub.co.uk','2006-05-11'),(3,'Ladbrook[/URL] Park','Committee Shield',NULL,'2006-06-22'),(4,'Robin Hood','Terry Hillin Cup',NULL,'2006-07-13'),(5,'Harborne','Cape Hill Cup',NULL,'2006-08-17'),(6,'Handsworth','Presidents Putter',NULL,'2006-09-07');
UNLOCK TABLES;
/*!40000 ALTER TABLE `tbl_fixtures` ENABLE KEYS */;

--
-- Table structure for table `tbl_latest`
--

DROP TABLE IF EXISTS `tbl_latest`;
CREATE TABLE `tbl_latest` (
  `id` int(11) NOT NULL auto_increment,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_latest`
--


/*!40000 ALTER TABLE `tbl_latest` DISABLE KEYS */;
LOCK TABLES `tbl_latest` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `tbl_latest` ENABLE KEYS */;

--
-- Table structure for table `tbl_login`
--

DROP TABLE IF EXISTS `tbl_login`;
CREATE TABLE `tbl_login` (
  `log_id` int(11) NOT NULL auto_increment,
  `user_id` int(10) default NULL,
  `user_logname` varchar(50) default NULL,
  `user_login` datetime default NULL,
  PRIMARY KEY  (`log_id`),
  KEY `log_user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_login`
--


/*!40000 ALTER TABLE `tbl_login` DISABLE KEYS */;
LOCK TABLES `tbl_login` WRITE;
INSERT INTO `tbl_login` VALUES (154,2,'JohnF',NULL),(155,2,'JohnF','2006-05-16 11:54:58'),(156,2,'JohnF','2006-05-16 12:01:49'),(157,2,'JohnF','2006-05-16 14:48:57'),(158,2,'JohnF','2006-05-16 15:22:59'),(159,2,'JohnF','2006-05-16 17:17:03'),(160,2,'JohnF','2006-05-17 08:43:51'),(161,1,'AustinM','2006-05-17 08:45:48'),(162,2,'JohnF','2006-05-17 09:26:54'),(163,1,'AustinM','2006-05-17 09:59:45'),(164,2,'JohnF','2006-05-17 10:04:28'),(165,1,'AustinM','2006-05-17 10:13:46'),(166,2,'JohnF','2006-05-17 10:16:53'),(167,1,'AustinM','2006-05-17 11:21:55'),(168,1,'AustinM','2006-05-17 11:23:09'),(169,1,'AustinM','2006-05-17 11:23:30'),(170,2,'JohnF','2006-05-17 12:02:39'),(171,3,'Test','2006-05-17 12:03:14'),(172,3,'Test','2006-05-17 12:22:38'),(173,3,'Test','2006-05-17 12:22:48'),(174,3,'Test','2006-05-17 12:23:47'),(175,3,'Test','2006-05-17 12:25:18'),(176,3,'Test','2006-05-17 13:38:04'),(177,2,'JohnF','2006-05-17 13:51:14'),(178,2,'JohnF','2006-05-17 15:56:37'),(179,2,'JohnF','2006-05-18 14:30:59'),(180,2,'JohnF','2006-05-19 08:41:33');
UNLOCK TABLES;
/*!40000 ALTER TABLE `tbl_login` ENABLE KEYS */;

--
-- Table structure for table `tbl_members`
--

DROP TABLE IF EXISTS `tbl_members`;
CREATE TABLE `tbl_members` (
  `mid` int(11) NOT NULL auto_increment,
  `Surname` varchar(255) default NULL,
  `Forename` varchar(255) default NULL,
  `handicap` smallint(5) default NULL,
  `Cape_Hill_Cup` int(10) default NULL,
  `Captains_Cup` int(10) default NULL,
  `Committee_Shield` int(10) default NULL,
  `Deers_Leap` int(10) default NULL,
  `Masters_Trophy` int(10) default NULL,
  `Presidents_Putter` int(10) default NULL,
  `Terry_Hillin_Challenge_Cup` int(10) default NULL,
  PRIMARY KEY  (`mid`),
  KEY `ID` (`mid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_members`
--


/*!40000 ALTER TABLE `tbl_members` DISABLE KEYS */;
LOCK TABLES `tbl_members` WRITE;
INSERT INTO `tbl_members` VALUES (1,'McLean','Adam',10,NULL,NULL,NULL,30,NULL,NULL,NULL),(2,'Quance','Adam',20,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,'Monk','Austin',13,NULL,29,NULL,31,NULL,NULL,NULL),(6,'Darby','Bob',18,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,'Hallett','Chris',28,NULL,NULL,NULL,19,NULL,NULL,NULL),(9,'Roberts','Dai',28,NULL,30,NULL,19,NULL,NULL,NULL),(10,'Hordern','Darren',28,NULL,18,NULL,NULL,NULL,NULL,NULL),(11,'Howe','Dave',18,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(12,'Forster','David',12,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(13,'Elwell','Garry',15,NULL,28,NULL,27,NULL,NULL,NULL),(14,'Cutler','Ian',10,NULL,NULL,NULL,25,NULL,NULL,NULL),(15,'Hillifer','Ian',24,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(16,'Crouch','Jerry',17,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(17,'Brooks','Jim',17,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(19,'Higgins','John',27,NULL,NULL,NULL,24,NULL,NULL,NULL),(20,'Robinson','John',28,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(23,'Hurley','Mick',20,NULL,27,NULL,25,NULL,NULL,NULL),(24,'Halloran','Mike',19,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(26,'Key','Nigel',19,NULL,27,NULL,31,NULL,NULL,NULL),(29,'Taylor','Pete',8,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(30,'Parry','Peter',21,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(31,'Hackwood','Phil',20,NULL,23,NULL,20,NULL,NULL,NULL),(32,'Turner','Richard',19,NULL,NULL,NULL,24,NULL,NULL,NULL),(33,'Pickering','Robin',11,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(34,'Spindler','Ron',23,NULL,31,NULL,29,NULL,NULL,NULL),(35,'Burford','Roy',22,NULL,26,NULL,34,NULL,NULL,NULL),(37,'Fuller','Steve',13,NULL,27,NULL,24,NULL,NULL,NULL),(38,'Davis','Tony',26,NULL,32,NULL,NULL,NULL,NULL,NULL),(48,'FLOOD','JOHN',18,NULL,NULL,NULL,32,NULL,NULL,NULL),(49,'Bodley','Andrew',14,NULL,24,NULL,29,NULL,NULL,NULL),(50,'Boyle','Brian',15,NULL,NULL,NULL,24,NULL,NULL,NULL),(51,'Davies','Tony',28,NULL,28,NULL,24,NULL,NULL,NULL),(52,'Essex','Paul',20,NULL,30,NULL,NULL,NULL,NULL,NULL),(53,'Male','Colin',28,NULL,28,NULL,NULL,NULL,NULL,NULL),(54,'Male','Neil',28,NULL,18,NULL,NULL,NULL,NULL,NULL),(55,'Purcell','Jason',18,NULL,29,NULL,NULL,NULL,NULL,NULL),(56,'Tomkinson','Paul',22,NULL,30,NULL,26,NULL,NULL,NULL),(57,'Wright','Simon',20,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
UNLOCK TABLES;
/*!40000 ALTER TABLE `tbl_members` ENABLE KEYS */;

--
-- Table structure for table `tbl_options`
--

DROP TABLE IF EXISTS `tbl_options`;
CREATE TABLE `tbl_options` (
  `option_id` int(11) NOT NULL auto_increment,
  `nOption` varchar(50) default NULL,
  `nLevel` int(10) default NULL,
  `nLink` varchar(50) default NULL,
  `norder` int(3) default NULL,
  PRIMARY KEY  (`option_id`),
  KEY `option_id` (`option_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_options`
--


/*!40000 ALTER TABLE `tbl_options` DISABLE KEYS */;
LOCK TABLES `tbl_options` WRITE;
INSERT INTO `tbl_options` VALUES (1,'Members - Add',2,'/navigation/option_add_member.asp',1),(2,'Members - Handicaps',2,'/navigation/option_handicap.asp',3),(3,'Results - Update',2,'/navigation/option_scores.asp',4),(4,'Winners - Add',2,'/navigation/option_winner.asp',5),(5,'View Logins',1,'/navigation/option_login.asp',8),(6,'Members - Delete',2,'/navigation/option_delete_member.asp',2),(7,'Winners - Delete',2,'/navigation/option_delete_winner.asp',6),(8,'Fixtures - Update',2,'/navigation/option_fixture.asp',7),(9,'Option - Add',1,'/navigation/option_add_option.asp',9),(11,'User - Add',1,'/navigation/option_add_user.asp',11),(12,'User - Amend',1,'/navigation/option_amend_user.asp',12),(13,'Latest News - Update',3,'/navigation/option_update_latest.asp',13);
UNLOCK TABLES;
/*!40000 ALTER TABLE `tbl_options` ENABLE KEYS */;

--
-- Table structure for table `tbl_users`
--

DROP TABLE IF EXISTS `tbl_users`;
CREATE TABLE `tbl_users` (
  `user_id` int(10) NOT NULL auto_increment,
  `user_logname` varchar(50) default NULL,
  `user_password` varchar(50) default NULL,
  `user_level` int(10) default NULL,
  `user_active` varchar(1) default NULL,
  PRIMARY KEY  (`user_id`),
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_users`
--


/*!40000 ALTER TABLE `tbl_users` DISABLE KEYS */;
LOCK TABLES `tbl_users` WRITE;
INSERT INTO `tbl_users` VALUES (1,'AustinM','golf007',2,'y'),(2,'JohnF','falcon',1,'y');
UNLOCK TABLES;
/*!40000 ALTER TABLE `tbl_users` ENABLE KEYS */;

--
-- Table structure for table `tbl_winners`
--

DROP TABLE IF EXISTS `tbl_winners`;
CREATE TABLE `tbl_winners` (
  `id` int(11) NOT NULL auto_increment,
  `Event` varchar(255) default NULL,
  `Year` double(15,5) default NULL,
  `Winner` varchar(50) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_winners`
--


/*!40000 ALTER TABLE `tbl_winners` DISABLE KEYS */;
LOCK TABLES `tbl_winners` WRITE;
INSERT INTO `tbl_winners` VALUES (1,'Cape Hill Cup',1990.00000,'C SHOWELL'),(2,'Cape Hill Cup',1991.00000,'M HURLEY'),(3,'Cape Hill Cup',1992.00000,'M HOWARD'),(4,'Cape Hill Cup',1993.00000,'T HILLIN'),(5,'Cape Hill Cup',1994.00000,'A FORRESTER'),(6,'Cape Hill Cup',1995.00000,'A FORRESTER'),(7,'Cape Hill Cup',1996.00000,'H WILLIAMS'),(8,'Cape Hill Cup',1997.00000,'P TAYLOR'),(9,'Cape Hill Cup',1998.00000,'B PUGH'),(10,'Cape Hill Cup',1999.00000,'D FORSTER'),(11,'Cape Hill Cup',2000.00000,'J BROOKS'),(12,'Cape Hill Cup',2001.00000,'D FORSTER'),(13,'Cape Hill Cup',2002.00000,'J BROOKS'),(14,'Cape Hill Cup',2003.00000,'J KNIGHT'),(15,'Cape Hill Cup',2004.00000,'-'),(16,'Cape Hill Cup',2005.00000,'R TURNER'),(17,'Captains Cup',1976.00000,'A. ALLEN'),(18,'Captains Cup',1977.00000,'J. PUGH'),(19,'Captains Cup',1978.00000,'R. QUINTON'),(20,'Captains Cup',1979.00000,'D. RAISON'),(21,'Captains Cup',1980.00000,'E. DUGGINS'),(22,'Captains Cup',1981.00000,'K. PETERS'),(23,'Captains Cup',1982.00000,'B. COLLEDGE'),(24,'Captains Cup',1983.00000,'J. PUGH'),(25,'Captains Cup',1984.00000,'J. PUGH'),(26,'Captains Cup',1985.00000,'T. HILLIN'),(27,'Captains Cup',1986.00000,'S. HESP'),(28,'Captains Cup',1987.00000,'P. TAYLOR'),(29,'Captains Cup',1988.00000,'T. MARKLEW'),(30,'Captains Cup',1989.00000,'C. SHOWELL'),(31,'Captains Cup',1990.00000,'M. HURLEY'),(32,'Captains Cup',1991.00000,'G. VAUGHN'),(33,'Captains Cup',1992.00000,'D. WILSON'),(34,'Captains Cup',1993.00000,'M. SHOWELL'),(35,'Captains Cup',1994.00000,'C. SHOWELL'),(36,'Captains Cup',1995.00000,'P. BASTABLE'),(37,'Captains Cup',1996.00000,'M. BELLM'),(38,'Captains Cup',1997.00000,'P. TAYLOR'),(39,'Captains Cup',1998.00000,'M. HOWARD'),(40,'Captains Cup',1999.00000,'B. WILLETTS'),(41,'Captains Cup',2000.00000,'C. CLINTON'),(42,'Captains Cup',2001.00000,'B. POWELL'),(43,'Captains Cup',2002.00000,'G. DODD'),(44,'Captains Cup',2003.00000,'N. KEY'),(45,'Captains Cup',2004.00000,'N. HUGHES'),(47,'Committee Shield',1982.00000,'B REEVES'),(48,'Committee Shield',1983.00000,'D COX'),(49,'Committee Shield',1984.00000,'W NOLAN'),(50,'Committee Shield',1985.00000,'A. O\'HARE'),(51,'Committee Shield',1986.00000,'N WESTON'),(52,'Committee Shield',1987.00000,'D COX'),(53,'Committee Shield',1988.00000,'S HESP'),(54,'Committee Shield',1989.00000,'R BURFORD'),(55,'Committee Shield',1990.00000,'D GASCOYNE'),(56,'Committee Shield',1991.00000,'W GREGORY'),(57,'Committee Shield',1992.00000,'M HOWARD'),(58,'Committee Shield',1993.00000,'M SHOWELL'),(59,'Committee Shield',1994.00000,'P BASTABLE'),(60,'Committee Shield',1995.00000,'M TAMBLING'),(61,'Committee Shield',1996.00000,'J CRAIG'),(62,'Committee Shield',1997.00000,'R BURFORD'),(63,'Committee Shield',1998.00000,'D WILSON'),(64,'Committee Shield',1999.00000,'B REEVES'),(65,'Committee Shield',2000.00000,'G LIVINGSTONE'),(66,'Committee Shield',2001.00000,'-'),(67,'Committee Shield',2002.00000,'-'),(68,'Committee Shield',2003.00000,'P TAYLOR'),(69,'Committee Shield',2004.00000,'A BODLEY'),(70,'Committee Shield',2005.00000,'N KEY'),(71,'Deers Leap',1985.00000,'K LYNE & M HOWARD'),(72,'Deers Leap',1986.00000,'J MAHON & R BURGESS'),(73,'Deers Leap',1987.00000,'D KIERNAN & G BRENNAN'),(74,'Deers Leap',1988.00000,'G GILBERT & D COX'),(75,'Deers Leap',1989.00000,'R BISHOP & R KEAN'),(76,'Deers Leap',1990.00000,'C GRANNER & K SCHOLZ'),(77,'Deers Leap',1991.00000,'C GRANNER & K SCHOLZ'),(78,'Deers Leap',1992.00000,'D COATES & T MARKLEW'),(79,'Deers Leap',1993.00000,'B REEVES & P BASTABLE'),(80,'Deers Leap',1994.00000,'A FORRESTER & R PICKERING'),(81,'Deers Leap',1995.00000,'J SKINGLEY & I BENNETT'),(82,'Deers Leap',1996.00000,'T HOARE & J MASON'),(83,'Deers Leap',1997.00000,'R SPINDLER & M TAMBLING'),(84,'Deers Leap',1998.00000,'B REEVES & P TAYLOR'),(85,'Deers Leap',1999.00000,'R NICHOLLS & R HARRIS'),(86,'Deers Leap',2000.00000,'R BURFORD & C SHOWELL'),(87,'Deers Leap',2001.00000,'R BURFORD'),(88,'Deers Leap',2002.00000,'B PUGH'),(89,'Deers Leap',2003.00000,'M HOWARD'),(90,'Deers Leap',2004.00000,'B DERBY'),(91,'Deers Leap',2005.00000,'A McLEAN'),(92,'Masters Trophy',1996.00000,'R SPINDLER'),(93,'Masters Trophy',1997.00000,'D COX'),(94,'Masters Trophy',1998.00000,'M SHOWELL'),(95,'Masters Trophy',1999.00000,'P TOMKINSON'),(96,'Masters Trophy',2000.00000,'M HURLEY'),(97,'Masters Trophy',2001.00000,'D FORSTER'),(98,'Masters Trophy',2002.00000,'P TAYLOR'),(99,'Player of the Year',1998.00000,'C SHOWELL'),(100,'Player of the Year',1999.00000,'D FORSTER'),(101,'Player of the Year',2000.00000,'J BROOKS'),(102,'Player of the Year',2001.00000,'D FORSTER'),(103,'Player of the Year',2002.00000,'M HOWARD'),(104,'Player of the Year',2003.00000,'P TAYLOR'),(105,'Player of the Year',2004.00000,'C PUREWELL'),(106,'Player of the Year',2005.00000,'S FULLER'),(107,'Presidents Putter',1980.00000,'M TAYLOR'),(108,'Presidents Putter',1981.00000,'M TAYLOR'),(109,'Presidents Putter',1982.00000,'B REEVES'),(110,'Presidents Putter',1983.00000,'J TOUGH'),(111,'Presidents Putter',1984.00000,'O.C. DARBY'),(112,'Presidents Putter',1985.00000,'P TAYLOR'),(113,'Presidents Putter',1986.00000,'O.C. DARBY'),(114,'Presidents Putter',1987.00000,'W CULSHAW'),(115,'Presidents Putter',1988.00000,'O.C. DARBY'),(116,'Presidents Putter',1989.00000,'M HURLEY'),(117,'Presidents Putter',1990.00000,'S GROCUTT'),(118,'Presidents Putter',1991.00000,'S GROCUTT'),(119,'Presidents Putter',1992.00000,'C CLINTON'),(120,'Presidents Putter',1993.00000,'W GREGORY'),(121,'Presidents Putter',1994.00000,'D WILSON'),(122,'Presidents Putter',1995.00000,'M TAMBLING'),(123,'Presidents Putter',1996.00000,'S GROCUTT'),(124,'Presidents Putter',1997.00000,'J LEAMAN'),(125,'Presidents Putter',1998.00000,'C SHOWELL'),(126,'Presidents Putter',1999.00000,'P BASTABLE'),(127,'Presidents Putter',2000.00000,'R PICKERING'),(128,'Presidents Putter',2001.00000,'A MONK'),(129,'Presidents Putter',2002.00000,'A McLEAN'),(130,'Presidents Putter',2003.00000,'M NICKLESS'),(131,'Presidents Putter',2004.00000,'A MONK'),(132,'Presidents Putter',2005.00000,'I CUTLER'),(133,'Terry Hillin Challenge Cup',1995.00000,'T MARKLEW'),(134,'Terry Hillin Challenge Cup',1996.00000,'T MARKLEW'),(135,'Terry Hillin Challenge Cup',1997.00000,'T MARKLEW'),(136,'Terry Hillin Challenge Cup',1998.00000,'B REEVES'),(137,'Terry Hillin Challenge Cup',1999.00000,'C SHOWELL'),(138,'Terry Hillin Challenge Cup',2000.00000,'-'),(139,'Terry Hillin Challenge Cup',2001.00000,'R BURFORD'),(140,'Terry Hillin Challenge Cup',2002.00000,'M HOWARD'),(141,'Terry Hillin Challenge Cup',2003.00000,'A MONK'),(142,'Terry Hillin Challenge Cup',2004.00000,'P TOMKINSON'),(143,'Terry Hillin Challenge Cup',2005.00000,'R PICKERING'),(144,'All',NULL,'All'),(149,'Captains Cup',2005.00000,'John Flood'),(150,'Deers Leap',2006.00000,'Roy Burford'),(151,'Captains Cup',2006.00000,'Tony Davis');
UNLOCK TABLES;
/*!40000 ALTER TABLE `tbl_winners` ENABLE KEYS */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

Any help would be most grateful
 
Sort by date Sort by votes
following on from thid I have tried to paste in the SQL directly & I get the following error
"Error

SQL-query :

CREATE TABLE `tbl_events` (
`Event` varchar( 255 ) default NULL ,
`norder` int( 10 ) default NULL ,
`event2` varchar( 255 ) default NULL
)ENGINE = InnoDB DEFAULTCHARSET = latin1

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 'ENGINE=InnoDB DEFAULT CHARSET=latin1' at line 5

Back"

Does this shed anymore light??
 
Upvote 0 Downvote
I think the "ENGINE" keyword was introduced fairly recently. "TYPE" can be used instead.
 
Upvote 0 Downvote
I have sorted this, for other who may have the same problems it was due to my privileges on phpmyadmim. I couldn't create a new database so I removed these lines from the SQL & it worked straight away.

Thanks.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

E
  • Locked
  • Question
MySQL calculator tools
Replies
0
Views
229
EdZzy
E
boylesg
  • Locked
  • Question
Can't sort my table by a particular column, records are returned in autinc order.
Replies
4
Views
477
spamjim
spamjim
Colin Burton
  • Locked
  • Question
Sending A a video clip to either a web server or MySql Database
Replies
2
Views
162
Colin Burton
Colin Burton
Arthur Lewis
  • Locked
  • Question
Backup Mysql database to client machine
Replies
2
Views
161
Arthur Lewis
Arthur Lewis
soushi01
  • Locked
  • Question
MySQL replication slave server re-sync issue
Replies
0
Views
234
soushi01
soushi01

Part and Inventory Search

Sponsor

Back
Top