• Registered: 2017-06-23
  • Posts: 50

Topic: Project new with existing MySql Database

Hello
I have a MySql database already created and I need to create a new project in MDV. I use the connection to MySql by the Connect to MySql button but in MDV I can not see the tables and I can not create the forms.
Thanks

  • Registered: 2014-02-14
  • Posts: 10,294

Re: Project new with existing MySql Database

Hello.


Your already created MySQL database was created by MVD?

Dmitry.
  • Registered: 2017-06-23
  • Posts: 50

Re: Project new with existing MySql Database

Hi
The database is already created, but it was created with phpMyAdmin not with MVD

  • Registered: 2014-02-14
  • Posts: 10,294

Re: Project new with existing MySql Database

MVD is not support working with exists database but actually you can do it.


First, there is two rules for exists database to be compatible with MVD.
1. Every database table must have primary key "id"
2. Foreign keys must have names like "id_tablename"


if your database meets these requirements, you can start to create your project using SQLite database, to create tables and fields like in your exists MySQL database. You do not have to create all tables and fields, just only those that will be used in your project.


After that you can just switch your project to MySQL DBMS and connect to exists database.

Dmitry.
  • Registered: 2017-06-23
  • Posts: 50

Re: Project new with existing MySql Database

Ok Thanks