Duplicating MySQL Schema

Question

We are running Data Center in AWS with a MySQL 5.7 RDS. We would like to consolidate some of our separate databases into a single RDS.

I am trying to use MySQL Workbench's Migration Wizard to copy a schema from one RDS to another. However, it keeps erroring out.

Can someone recommend a way of duplicating a schema from one database to another?

Jeff Shepherd_fzkuue · Answer

Hmmm... Looking deeper into the errors it looks like they may be preceded by a timeout. This may be more a network issue rather than a Atlassian or MySQL.

Thank you for your suggestions!

Nic Brough -Adaptavist- · Answer

Confluence is simply using a database as a data store.  It doesn't need "parameters" to deal with what it's storing, and your problem is errors coming from SQL, not Confluence.

Whatever issue you're having, it is with the database.  I'd start by looking at the error you're getting from the workbench, what is that saying?

Jeff Shepherd_fzkuue · Answer

I have an associate that says some of the Atlassian records in the database are very large and require parameters when dealing with them. I have used the MySQL Workbench with other schema and have had no problem, so I believe this is an Atlassian issue.