Sync your MySQL Database to Wix finally working (Article)

Hey all!
All of you that have some MySQL Database hosted somewhere and wish you could get the content into Wix Data Collections will be so happy. I just pulled that off and wrote an extensive article on how to accomplish it.


Read the full article here:
https://uggadugg.wixanswers.com/en/article/syncing-data-from-mysql-to-wix-data-collections

3 Likes

Andreas, very interesting, good job. One question: why did you choose Zapier over doing the same using the mysql-NPM?

Andreas, another thing: did you realize you just solved the problem that Wix DB does not have an auto-increment field. If you just added the auto-increment ID-field to the JSON collection, you would be able to use autoincrements in Wix!!!

I have been in love with Zapier for 7 years, good enough?

Yes that is cool

My table is >1m rows. The collection cap is 10k. Can this help with that?

@andreas-kviby can you contact me via email? team@accountantBFF.com

hi
I am trying to sign in to your article https://uggadugg.wixanswers.com/en/article/syncing-data-from-mysql-to-wix-data-collections . I got a reply that I am not allowed to read it. Can you help? I need to get mysql to be connected to wix as well.
Thank you in advance

I am also trying to sign in with trouble. Did you get any help with this?

I can’t sign in… Someone who can help me with this?

You need to go to Wix Support instead of jumping onto a year old post…
https://support.wix.com/en/article/contacting-wix-support

People, the original article was written by Andreas, who since then has stopped doing development in Wix and closed all his Wix-related web sites. Because asking questions about it is therefor no longer relevant, I´m closing this post.