Questions tagged with MySQL
Content language: English
Select up to 5 tags to filter
Sort by most recent
Browse through the questions and answers listed below or filter and sort to narrow down your results.
Hi,
I have configuration:
- rds mysql 8.0.36 multi az deployment (active - standby)
- few instances of read-replica
I have configured job to scale in and scale out of my main database (to save $ after...
1
answers
0
votes
106
views
asked 13 days agolg...
I used mysqljump to back up the database, uploaded the sql file to S3 and used Restore from S3 to restore the database, and then failed and reported an error: "Incompatible-restore"
My database...
1
answers
0
votes
125
views
asked 13 days agolg...
```
mysqldump -h source_MySQL_DB_instance_endpoint \
-u user \
-ppassword \
--port=3306 \
--single-transaction \
--routines \
--triggers \
--databases database database2 >...
1
answers
0
votes
84
views
asked 14 days agolg...
We would like to have a certain table truncated when the RDS for MySQL instance is started using the server parameter "init_file" which currently is NOT supported on RDS.
(The statements should be...
2
answers
0
votes
104
views
asked 16 days agolg...
We have a MySQL multi-AZ instance on t2 class, which needs to be migrated to t3 family.
AWS documentation says this requires downtime, which is understandable. But it also mentions that only one...
Accepted AnswerMySQL
1
answers
0
votes
57
views
asked 19 days agolg...
I'm trying to remove a database but i'm getting this error:
SQL Error [1010] [HY000]: Error dropping database (can't rmdir './databasename', errno: 39)
I've been reading solutions, but it looks like...
1
answers
0
votes
140
views
asked 19 days agolg...
We recently upgraded MySQL 5.7 to MySQL 8.0.35 and are noticing huge performance problems in our production website.
Any insights as to what sort of queries can cause performance issues? Any config...
Accepted AnswerMySQL
1
answers
0
votes
75
views
asked 19 days agolg...
I hope someone has some ideas on how to resolve the following issue I'm facing.
Here's the setup:
- 8.0.mysql_aurora.3.06.0 cluster with a writer and a reader instance(db.r7g.large)
- PHP web...
0
answers
0
votes
210
views
asked 22 days agolg...
Trying to connect MySQL RDS through VM machine by using mysql connectionstring. RDS is in private subnet and public accessible also set to false. Private Subnet routetable is mapped with Nat...
2
answers
0
votes
179
views
asked 22 days agolg...
2) MySQL 8.0 syntax check for routine-like objects
https://dev.mysql.com/doc/refman/8.0/en/keywords.html
More Information:
https://dev.mysql.com/doc/refman/en/keywords.html
mysql.flush_rewrite_rules -...
1
answers
0
votes
76
views
asked a month agolg...
We have a snapshot of RDS version 8.0.33 and we want to migrate to any potential version of Aurora MySQL.
The problem is that on the migration screen there are Aurora MySQL 3.05.2 and 3.06.00 which...
2
answers
0
votes
483
views
asked a month agolg...
Hello,
My RDS won't connect to MySQL Workbench or Power BI.
* MySQL Workbench error: "Failed to connect to MySQL at [endpoint URL] with user [username]. Unable to connect to localhost".
* Power BI...
2
answers
0
votes
247
views
asked a month agolg...