srwright Posted March 23, 2014 Share Posted March 23, 2014 ok i have loaded a .sql file into PHPmyadmin. it is giving me this error :/ what can i do? im using this version: Server version: 5.6.16 - MySQL Community Server (GPL -------------------------------------------------------------------------------- SQL query: /*!40000 ALTER TABLE `group_members` ENABLE KEYS */;-- Dumping structure for table bc.help_subjectsCREATE TABLE IF NOT EXISTS `help_subjects` (`id` int(11) unsigned NOT NULL AUTO_INCREMENT,`caption` varchar(100) NOT NULL,PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=latin1; MySQL said: #1064 - 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 'CREATE TABLE IF NOT EXISTS `help_subjects` ( `id` int(11) unsigned NOT NULL A' at line 6 Link to comment https://forums.phpfreaks.com/topic/287211-mysql-help/ Share on other sites More sharing options...
jazzman1 Posted March 24, 2014 Share Posted March 24, 2014 what can i do? I'd start running a mysql command line client executing sql statements from a text file using the source command. Here, it's an example of installation sakila database, use same logic. Link to comment https://forums.phpfreaks.com/topic/287211-mysql-help/#findComment-1473665 Share on other sites More sharing options...
srwright Posted March 24, 2014 Author Share Posted March 24, 2014 I'd start running a mysql command line client executing sql statements from a text file using the source command. Here, it's an example of installation sakila database, use same logic. Ok the only problem is. i dont really know much about databases. Im simply following a tutorial. and this hasn't happened in the tutorial :/ sorry i know it must be frustrating getting people who dont truly know what theyre doing Link to comment https://forums.phpfreaks.com/topic/287211-mysql-help/#findComment-1473737 Share on other sites More sharing options...
jazzman1 Posted March 24, 2014 Share Posted March 24, 2014 Ok the only problem is. i dont really know much about databases. Im simply following a tutorial. and this hasn't happened in the tutorial :/ sorry i know it must be frustrating getting people who dont truly know what theyre doing Then, stop learning tutorials and start learning the core programming logic by reading the docs Link to comment https://forums.phpfreaks.com/topic/287211-mysql-help/#findComment-1473756 Share on other sites More sharing options...
srwright Posted March 24, 2014 Author Share Posted March 24, 2014 Then, stop learning tutorials and start learning the core programming logic by reading the docs Im not interested in learning to program though. i simply needed the database for something else. as soon as thats setup i wont be using it again. couldn't you just help i im guessing you know how to do this stuff. Link to comment https://forums.phpfreaks.com/topic/287211-mysql-help/#findComment-1473761 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.