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
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now