MySQL dump not working [RESOLVED]

[Mannekino]

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

[LFA]

MySQL should work correctly. It is what I use for development. What version of MySQL are you running?

[Mannekino]

I'm running: Server version: 5.0.51a-24+lenny4 (Debian)

[LFA]

Try removing "USING BTREE" from the script.

[Mannekino]

Thanks, that fixed it.