Topshed Posted April 12, 2012 Share Posted April 12, 2012 Please help I am in deep trouble working in phpmyadimin I have wrecked a table of 15559 Records I have a backup but when I try to restore it I get an error message that ends 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 'TYPE=MyISAM AUTO_INCREMENT=15559' at line 40 Line 40 does indeed say ) TYPE=MyISAM AUTO_INCREMENT=15559 ; The only differance I can find is the number according to my existing file is 15646 I have tried editing the number down to 15559 with no effect I have also flushed the recieving table which also make no differance I do hope someone can hrlp Please .... Quote Link to comment https://forums.phpfreaks.com/topic/260778-mysql-gothca/ Share on other sites More sharing options...
PFMaBiSmAd Posted April 12, 2012 Share Posted April 12, 2012 AFAIK, the correct syntax should be - ENGINE=MyISAM Quote Link to comment https://forums.phpfreaks.com/topic/260778-mysql-gothca/#findComment-1336593 Share on other sites More sharing options...
Topshed Posted April 12, 2012 Author Share Posted April 12, 2012 Hi, thanks for the reply ENGINE=MyISAM Unfortunatly that chage stops the import straight away Regars Toppy Quote Link to comment https://forums.phpfreaks.com/topic/260778-mysql-gothca/#findComment-1336594 Share on other sites More sharing options...
PFMaBiSmAd Posted April 12, 2012 Share Posted April 12, 2012 And the error or exact symptom you are getting is??? Quote Link to comment https://forums.phpfreaks.com/topic/260778-mysql-gothca/#findComment-1336599 Share on other sites More sharing options...
PFMaBiSmAd Posted April 12, 2012 Share Posted April 12, 2012 Mysql 5.0 and below used either the ENGINE or TYPE keyword. Mysql 5.1 and above uses ENGINE only. What version of mysql was your backup made under and what version are you trying to restore under? Quote Link to comment https://forums.phpfreaks.com/topic/260778-mysql-gothca/#findComment-1336601 Share on other sites More sharing options...
Muddy_Funster Posted April 12, 2012 Share Posted April 12, 2012 another thing that would help would be to see the few lines either side of that one in the error, sometimes the problem isn't in the code listed in the error, which is why the error message uses the word near in stread of at. Quote Link to comment https://forums.phpfreaks.com/topic/260778-mysql-gothca/#findComment-1336650 Share on other sites More sharing options...
Topshed Posted April 22, 2012 Author Share Posted April 22, 2012 Thank you all for your support. I found after much conversation that my hosting site, Cpanel was exporting garbage because when they tried to export as a user (me) it also failed So they did a local dump and made it available to me to use. I am now waiting for an "It's fixed" from them. Regards Topshed2 Quote Link to comment https://forums.phpfreaks.com/topic/260778-mysql-gothca/#findComment-1339439 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.