CODEWITHSUNDEEP
mysqldatabaseimportmysql-workbench
Plusce
Plusce

Reputation: 117

Error during importing a mysql database

I want to import .mwb file to start creating my server. Below is the error code:

#1064 - 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 '<?xml version="1.0"?> <data grt_format="2.0" document_type="MySQL Workbench Mode' at line 1
<?xml version="1.0"?>
<data grt_format="2.0" document_type="MySQL Workbench Model" version="1.4.4">
<value type="object" struct-name="workbench.Document" id="{9C96C2FB-0BB1-4A76-BE8F-79E5817A1EA6}" struct-checksum="0x7131bf99">
<value type="object" struct-name="workbench.logical.Model" id="{3CB64CD4-2162-4F9E-B626-AD410F02462D}" struct-checksum="0xf4220370" key="logicalModel">
<value _ptr_="0000000023AA1330" type="list" content-type="object" content-struct-name="workbench.logical.Diagram" key="diagrams"/>
<value _ptr_="0000000023AA2600" type="dict" key="customData"/>
<value _ptr_="0000000023AA1B10" type="list" content-type="object" content-    struct-name="model.Marker" key="markers"/>
<value _ptr_="0000000023AA1F70" type="dict" key="options"/>
<value type="string" key="name"></value>

What shall I do now?

Upvotes: 2

Views: 2635

Answers (1)

Marc Compte
Marc Compte

Reputation: 4819

You have an error in your SQL syntax because you are trying to import the MWB as an SQL. The system looks for SQL sentences and finds an XML and this produces the error you are given.

You should open it as a model and then use forward engineering.

Maybe this video helps you https://www.youtube.com/watch?v=fQH9Z9NVEY0

Upvotes: 3

Related Questions