Mannekino Posted August 17, 2010 Share Posted August 17, 2010 (edited) I guess MySQL support is still experimental. I thought it would be better to use MySQL. I got the following error when trying to load the SQL file. mysql -u tcadmin -p<password> tcadmin < tcadmin.sql ERROR 1064 (42000) at line 49: 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 'USING BTREE ) ENGINE=MyISAM DEFAULT CHARSET=utf8' at line 10 Perhaps because we run MySQL on Linux and this dump was made on Windows. Edited August 17, 2010 by Mannekino Link to comment Share on other sites More sharing options...
LFA Posted August 17, 2010 Share Posted August 17, 2010 MySQL should work correctly. It is what I use for development. What version of MySQL are you running? Link to comment Share on other sites More sharing options...
Mannekino Posted August 17, 2010 Author Share Posted August 17, 2010 I'm running: Server version: 5.0.51a-24+lenny4 (Debian) Link to comment Share on other sites More sharing options...
LFA Posted August 17, 2010 Share Posted August 17, 2010 Try removing "USING BTREE" from the script. Link to comment Share on other sites More sharing options...
Mannekino Posted August 17, 2010 Author Share Posted August 17, 2010 Thanks, that fixed it. Link to comment Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now