Connect database from MySQL

[martin-lien]

I s it possible to connect your database from MySQL to your Wix site?

[ohad-laufer]

At the moment, you can’t connect an external db directly to your site.
Your options are to import the data from MySQL to Wix collection or to expose an api on your MySQL db and use fetch() from Wix code to get and use the data.

[usaircompressors]

Is there a way to write on a database from wix database?

[sfreeman1920]

SO if i expose the API on my end, i can connect directly to my SQL database to my Wix website correct?

[ohad-laufer]

@sfreeman1920 yes.
Another option is to use the external db feature: https://support.wix.com/en/article/corvid-working-with-external-database-collections

[sfreeman1920]

@ohad-laufer Thanks. Question - as data gets updated in my sql database will it update inside wix - automatically?

[yisrael-wix]

For accessing an external database, refer to the following:

• Corvid: Working with External Database Collections

• Corvid: Adding and Deleting an External Database Collection

• External Database Collections API

• Github repository for wix/corvid-external-db-mysql-adapter