Duplicating MySQL Schema

[Jeff Shepherd]

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?

[Nic Brough -Adaptavist-]

This is probably a question better asked on a database forum, unless you can explain what it has to do with Atlassian stuff?

[Jeff Shepherd]

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.

[Nic Brough -Adaptavist-]

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]

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!