Liger Posted January 12, 2006 Share Posted January 12, 2006 ANyone know what to do? Link to comment Share on other sites More sharing options...
0 the_mole001 Posted January 12, 2006 Share Posted January 12, 2006 well, what version of mysql are you running? not all support charset i dont think? or they support it but the syntax is different on each version. i think. I had a problem where i couldnt update the db's on my server from my pc and i finally one day figured out my pc was running version 5 and the server was 4 lol. Link to comment Share on other sites More sharing options...
0 Liger Posted January 13, 2006 Author Share Posted January 13, 2006 (edited) well, what version of mysql are you running? not all support charset i dont think? or they support it but the syntax is different on each version. i think. I had a problem where i couldnt update the db's on my server from my pc and i finally one day figured out my pc was running version 5 and the server was 4 lol. phpMyAdmin 2.6.4-pl2 thats my hosts phpmyadmin version. Now how can I fix that error? :s My old servers Sql was : Server version 4.1.14-standard New servers : MySQL version 4.0.25-standard I backed up the sql from cpanel of my old hos and when i try to restore it on this new on i get that error.... Any fix for this? Edited January 13, 2006 by Liger Link to comment Share on other sites More sharing options...
0 devofash Posted January 13, 2006 Share Posted January 13, 2006 i'm still a newbie at php .... but aint u ment to close the sql with a semi-colon " ; " u havent done that on line 8 or line 10 (not sure which one try each) Link to comment Share on other sites More sharing options...
0 Liger Posted January 13, 2006 Author Share Posted January 13, 2006 i'm still a newbie at php .... but aint u ment to close the sql with a semi-colon " ; " u havent done that on line 8 or line 10 (not sure which one try each) where is that? I dont see it. :s Link to comment Share on other sites More sharing options...
0 devofash Posted January 13, 2006 Share Posted January 13, 2006 sql statement must end with a semi colon ' ; ' u havent ended the sql ........... at the end of line 10 or 8 just add a semi-colon Link to comment Share on other sites More sharing options...
0 devn00b Posted January 13, 2006 Share Posted January 13, 2006 ANyone know what to do? Remove the line with Engine= MYISAM its not needed realy and thats the problem all you need is the }; Link to comment Share on other sites More sharing options...
0 Liger Posted January 13, 2006 Author Share Posted January 13, 2006 Remove the line with Engine= MYISAM its not needed realy and thats the problem all you need is the ); thank you a lot. that worked! :D Link to comment Share on other sites More sharing options...
Question
Liger
ANyone know what to do?
Link to comment
Share on other sites
7 answers to this question
Recommended Posts