Talk:Database Schema: Difference between revisions
No edit summary |
Dorian Borg (talk | contribs) No edit summary |
||
Line 2: | Line 2: | ||
JRR | JRR | ||
Download link is not working. | |||
-Dorian | |||
== problem importing 1.8 data structure file into MySQL workbench == | == problem importing 1.8 data structure file into MySQL workbench == |
Revision as of 08:41, 1 December 2010
Note: You can't right-click and download the link: click on it and download the .rar file. Right-click/download results in a corrupted file that can't be unRar'ed.
JRR
Download link is not working.
-Dorian
problem importing 1.8 data structure file into MySQL workbench
Comment: The data structure file here does not import successfully into MySQL workbench 5 (which replaced DBDesigner4) http://moodle.org/file.php/5/moddata/forum/28/376698/moodle_1.8_data_structure.rar the import gets partway through then give this error:-
Type mismatch expected type INT but got STRING
(To get round this I imported into DBDesigner4 then generated a create script then brought that into MySQL Workbench.)
It would be very helpful to have the 1.9+ data model as XML or (preferably) the create script.
LP
Downloaded and installed DB Designer4. Downloaded and saved the moodle_1.8_data_structure.rar. Opened DB Designer and couldn't "Import" anything except .xml files. Gave up - for now. SK