1. Georg Lacher
  2. Valentina Studio
  3. Среда, Май 06 2020, 08:03 AM
  4.  Подписаться через email
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
There are no comments made yet.
Sergey Pashkov Ответ принят
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.
There are no comments made yet.
Ruslan Zasukhin Ответ принят

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"
There are no comments made yet.
Georg Lacher Ответ принят
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
There are no comments made yet.
  • Страница :
  • 1

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