All Content tagged with MySQL

I need to transfer data from a PostgreSQL database to a MySQL database using AWS Glue, with transformations applied to the data. The data source allows direct connectivity to PostgreSQL, but the targe...

Hi, I doing migration of my AWS infrastructure to the another region and currently experiencing issue with connecting to one of my MySQL database from my local laptop. What I did: 1. Created an sna...

Hi, when I try to make a new connection with the database that I created with the specific endpoint,I get error in MySql. I tried to change the security group as I saw on Youtube but it's still the s...

Hi everyone, I'm working on a project where we need to store and manage contact details in a database that integrates with Google Sheets via a Google Script. Currently we have this working but the sc...

I work with Amazon Web Services as a data engineer. I have created several Glue jobs that copy data from RDS Aurora MySQL to Amazon Redshift using the Glue catalog, Visual ETL, and ETL Scripts. The pr...

Hello, I'm experiencing an issue with an Aurora MySQL upgrade. I am currently migrating my Aurora database from version 5.7.mysql_aurora.2.11.5 to the latest available version (Aurora v3). The proces...

Hello, I'm working with Amazon RDS for MySQL, and I need to know the default values for the following parameters: 1. interactive_timeout 2. wait_timeout I've checked the documentation but couldn't ...

Hello, I'm trying to connect from Glue to Mysql, when testing the connection I'm getting the following error: ERROR StatusLogger Unrecognized format specifier [d] ERROR StatusLogger Unrecognized conve...

Hi, I have set up an Athena MySQL connector for federated queries to RDS. For some reason an extra column not present in my RDS table is added called "partition_name" all values set to "*". I have no...

Excited to see this: https://aws.amazon.com/about-aws/whats-new/2024/09/amazon-aurora-mysql-rds-data-api/, however.... I have enabled the Data API for my Aurora Serverless V2 cluster. When I try to u...

i try do this solution: ``` mysqld --skip-grant-tables --user=mysql --skip-external-locking --port=3306 --sock=/opt/bitnami/mariadb/tmp/mysql.sock ``` but: ``` mysqld: Deprecated program name. It...

Hi there, We are attempting to migrate one of our databases from **MySQL 5.7** to **MySQL 8**. Upgrading the snapshot for this database failed so I've attempted to restore it in a micro instance and ...