• Registered: 2015-02-24
  • Posts: 446

Topic: Use an already existing MySQL Database

Hello all MVD fans,


This question might already have been  posted, but I could not find the answer...


Is it possible to launch a new MVD project based on an already existing (and full of data) MySQL database, or do we have to start from scratch ?



Cheers


Mathias

I'm a very good housekeeper !
Each time I get a divorce, I keep the house
Zaza Gabor
  • Registered: 2014-02-14
  • Posts: 10,294

Re: Use an already existing MySQL Database

Hello,


Actually you can use an already exists MySQL database, but before you must create the same database structure in My Visual Database, then you can connect to the exists database.


But there is two rules for database structure.


1. Every database table must have primary key with name `id`
2. Every foreign key must have name like  `id_parenttable`

Dmitry.