1. Georg Lacher
  2. Valentina Studio
  3. Mittwoch, Mai 06 2020, 08:03 AM
  4.  Abonnieren via E-Mail
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
Kommentar
There are no comments made yet.
Sergey Pashkov Akzeptierte Antwort
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.
Anhänge
Kommentar
There are no comments made yet.
Ruslan Zasukhin Akzeptierte Antwort
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"
Kommentar
There are no comments made yet.
Georg Lacher Akzeptierte Antwort
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
Kommentar
There are no comments made yet.
  • Seite :
  • 1


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

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories