Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

How to write the table directly to the MYSQL database? #832

Open
phoenixlucky opened this issue Aug 16, 2024 · 2 comments
Open

How to write the table directly to the MYSQL database? #832

phoenixlucky opened this issue Aug 16, 2024 · 2 comments

Comments

@phoenixlucky
Copy link

Is your feature request related to a problem? Please describe.
All the data written is in the PostgreSQL database. How do I write to the MySQL database?

Describe the solution you'd like
I want to see the content I fill in the MySQL data synchronously, can it be achieved? If so, how do I configure it? Are there any specific cases?

Describe alternatives you've considered

Additional context

@tea-artist
Copy link
Contributor

While Teable primarily uses PostgreSQL, you can synchronize data to MySQL using external tools. Here's a brief guide:

Teable creates a PostgreSQL schema for each base, containing all user-created tables.

To sync to MySQL, consider these open-source or popular tools:

Airbyte (open-source)
Debezium (open-source, real-time CDC)
Navicat (widely used client tool with data synchronization features)
Basic setup:

Connect the tool to both PostgreSQL and MySQL databases
Configure data mapping between source and target tables
Set synchronization frequency
Remember, Teable will continue to interact with PostgreSQL as the primary database. The MySQL copy would be for reference or other use cases.

For detailed instructions, refer to the documentation of your chosen tool. If you need further assistance, please ask!

@phoenixlucky
Copy link
Author

You still need to use third-party data extraction, and you can't connect directly to MySQL, right?OK,I see. Thank you.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants