hgoldberg
|
Posted: August 17, 2009 20:55 by hgoldberg
|
|
Have mysql 5.0.45 installed on my machine. Getting errors from 'USING BTREE' clauses. Does anyone know if there is a syntax difference with 5.1.x or 5.0.45 is missing this capability--syntax looks valid from the documentation. Thanks, Howard |
installation--mysql issue
4 posts
Replies: 3 - Last Post: August 19, 2009 22:56
by: hgoldberg
by: hgoldberg
showing 1 - 4 of 4
|
hgoldberg
|
Posted: August 18, 2009 16:06 by hgoldberg
|
|
There was a syntax change between 5.0 and 5.1 with respect to column name and index type. See http://bugs.mysql.com/bug.php?id=25162 There is a compatibility flag that can be set to make the 5.1 .sql dumps compatible with 5.0 and 5.1. Howard |
|
anandsastry
|
Posted: August 19, 2009 13:30 by anandsastry
|
|
Howard, HIEOS has DDL scripts to create all the required database artifacts. There are some DML statements as well to initialize certain tables. Are you trying to do a "restore" from MySQL Admin ? Please launch the MySQL QueryBrowser from the MySQL Admin tool. On the browser, open script from the File menu and load the DDL. Per MySQL 5.0 documentation (http://dev.mysql.com/doc/refman/5.0/en/create-table.html), "USING BTREE", is valid. Please let me know if you are still having issues. Anand |
|
hgoldberg
|
Posted: August 19, 2009 22:56 by hgoldberg
|
|
Anand, I got the scripts to work, but I had to edit the scripts because they aren't compatible with MySql 5.0--follow my previous link. If you can regenerate the DDL scripts, setting the compatibility flag for 5.0, users can use either 5.0.x or 5.1.x. |
Replies: 3 - Last Post: August 19, 2009 22:56
by: hgoldberg
by: hgoldberg
