![[The AI Show Episode 142]: ChatGPT’s New Image Generator, Studio Ghibli Craze and Backlash, Gemini 2.5, OpenAI Academy, 4o Updates, Vibe Marketing & xAI Acquires X](https://www.marketingaiinstitute.com/hubfs/ep%20142%20cover.png)
![[FREE EBOOKS] The Kubernetes Bible, The Ultimate Linux Shell Scripting Guide & Four More Best Selling Titles](https://www.javacodegeeks.com/wp-content/uploads/2012/12/jcg-logo.jpg){kind=logo}
![From drop-out to software architect with Jason Lengstorf [Podcast #167]](https://cdn.hashnode.com/res/hashnode/image/upload/v1743796461357/f3d19cd7-e6f5-4d7c-8bfc-eb974bc8da68.png?#)
.png?#)
.jpg?#)
_Christophe_Coat_Alamy.jpg?#)
![Rapidus in Talks With Apple as It Accelerates Toward 2nm Chip Production [Report]](https://www.iclarified.com/images/news/96937/96937/96937-640.jpg)
Moving data from mysql to postgresql
Precise Steps to Transfer Data from MySQL to PostgreSQL using DBeaver: 1. Connect to MySQL in DBeaver Open DBeaver. Click Database > New Database Connection. Select MySQL, click Next. Enter: Host: sourcedb-vicclasses.j.aivencloud.com Port: 19774 User: avnadmin Password: AVNS_DSKQiqnqWhlGSqkqB-R Database: defaultdb Test connection and click Finish. 2. Connect to PostgreSQL in DBeaver Database > New Database Connection. Select PostgreSQL, click Next. Enter: Host: 172.178.131.221 Port: 5432 User: luxds Password: 1234 Database: warehouse Test connection and click Finish. ** Export Data from MySQL** Right-click the MySQL table houses_for_rent_reinny. Select Export Data. Choose Database as target. Click Next. 4. Set PostgreSQL as Target Select the PostgreSQL connection (warehouse DB). Choose the staging.house_for_rent_reinny table (or create if not exists). Make sure column mapping matches: id, title, location, size, price. 5. Configure Export Options Check Truncate before load if you want to clear data first (optional). Make sure ON CONFLICT DO NOTHING option is respected (DBeaver might not natively support this; handle duplicates later if needed). Click Next. 6. Execute Transfer Review preview. Click Start to transfer. Wait until data is loaded and verify completion message. 7. Verify in PostgreSQL Right-click staging.house_for_rent_reinny table under PostgreSQL connection. View Data > All Rows. Confirm data matches top 10 rows from MySQL.
Precise Steps to Transfer Data from MySQL to PostgreSQL using DBeaver:
1. Connect to MySQL in DBeaver
- Open DBeaver.
- Click Database > New Database Connection.
- Select MySQL, click Next.
- Enter:
- Host:
sourcedb-vicclasses.j.aivencloud.com - Port:
19774 - User:
avnadmin - Password:
AVNS_DSKQiqnqWhlGSqkqB-R - Database:
defaultdb
- Host:
- Test connection and click Finish.
2. Connect to PostgreSQL in DBeaver
- Database > New Database Connection.
- Select PostgreSQL, click Next.
- Enter:
- Host:
172.178.131.221 - Port:
5432 - User:
luxds - Password:
1234 - Database:
warehouse
- Host:
- Test connection and click Finish.
**
- Export Data from MySQL**
- Right-click the MySQL table
houses_for_rent_reinny. - Select Export Data.
- Choose Database as target.
- Click Next.
4. Set PostgreSQL as Target
- Select the PostgreSQL connection (
warehouseDB). - Choose the staging.house_for_rent_reinny table (or create if not exists).
- Make sure column mapping matches:
id,title,location,size,price.
5. Configure Export Options
- Check Truncate before load if you want to clear data first (optional).
- Make sure
ON CONFLICT DO NOTHINGoption is respected (DBeaver might not natively support this; handle duplicates later if needed). - Click Next.
6. Execute Transfer
- Review preview.
- Click Start to transfer.
- Wait until data is loaded and verify completion message.
7. Verify in PostgreSQL
- Right-click staging.house_for_rent_reinny table under PostgreSQL connection.
- View Data > All Rows.
- Confirm data matches top 10 rows from MySQL.
