Database change from PostgreSQL to MySQL?

[lime panther]

Hello!
I have a problem where I started the development of the project in Supabase with PostgreSQL. Now I want to swap my db adapter to MySQL on Hostinger.
How can I achieve this? Can I just change my connection string and my content would automatically be sycned to the new database or do i have to export/import/convert the db tables from postgres to mysql?
Any insight from an experienced professional would be appreciated.

[heavy bane]

New Community-Help Thread Created!

Help is on the way! To mark it as solved, use the /solve command. In the meantime, here are some existing threads that may help you:

Documentation:

• Migrations - When to run migrations - Postgres
• Postgres
• Postgres - Prototyping in development mode
• Postgres - Drizzle schema hooks - beforeSchemaInit
• Migrations - Using Transactions

[charred adder]

As far as I know, you would have to create a database adapter for MySQL and Hostinger does not provide or not able to provide the connection string as MySQL is a completely different database architecture.

[weak cove]

You to migrate the content.
Use a backup and try to import to the new database.

[restive kelp]

MySQL support is not available yet. We are pretty well positioned to add this feature since we have postgres and sqlite. The abstractions are all there we just need to do some extra work to get through any differences we run into.
It does help to upvote the features you want from our discussions to raise visibility: https://github.com/payloadcms/payload/discussions?discussions_q=is%3Aopen+mysql

[lime panther]

Thank you for all answers. For now I am going to have to stick to Postgres as Mysql is a completely different architecture