Talk:Database Schema: Difference between revisions
Linda Petty (talk | contribs) m (New section: problem importing 1.8 data strucutre file into MySQL workbench ) |
Linda Petty (talk | contribs) mNo edit summary |
||
Line 3: | Line 3: | ||
JRR | JRR | ||
== problem importing 1.8 data | == problem importing 1.8 data structure file into MySQL workbench == | ||
Comment: | Comment: |
Revision as of 12:41, 25 February 2009
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
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