1. Georg Lacher
  2. Valentina Studio
  3. Wednesday, May 06 2020, 08:03 AM
  4.  Subscribe via email
Hello!
I'm trying to use Valentina Studio as a new frontend for an existing MySQL database with about 100.000 records. The 10 minutes introduction video helped me a lot.
When trying to create a link in the database diagram I got an error message. It said I should use InnoDB. I never heard this word before. What can I do to get rid of this error?
Thank you very much.
Georg Lacher
Comment
There are no comments made yet.
Sergey Pashkov Accepted Answer
Hello Georg!

InnoDB is a storage engine.
Each table in MySQL database has property Engine, you can find it in the Property Inspector.
Different engines exist - MyISAM, InnoDB, Memory, etc.. All engines have different capabilities.
InnoDB supports the creation of foreign key links, MyISAM doesn't.

So you can switch Engine from (I suppose) MyISAM to InnoDB in the Property Inspector.
Note, it is recommended to create a backup before doing such operation to avoid any data loss.
Attachments (1)
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 1
Georg Lacher Accepted Answer
Hello Sergey,

thank you for your help!

After some research it was quite easy to solve the problem. I made a backup of the database. Then I had to edit the sql file and execute only one find and replace command: replacing each "ENGINE = MyISAM" with "ENGINE = InnoDB". Then I restored the database with the edited backup sql file. Done. I can work with the database just like before, and in additon I can use Valentina Studio, create a diagram, create links and so on.

Best wishes
Georg
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 2
Ruslan Zasukhin Accepted Answer
Sergey,

maybe we need to make msg more expressive? Something as

" You using now MyISAM engine, which not supports Foreign Key. To use them you need switch to InnoDB engine"
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 3
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.