MySQL Forums
Forum List  »  Replication

Replication with different lower-case-table setting
Posted by: Christian Molecki
Date: May 20, 2016 02:02AM

Hello everyone,

I have one MySQL server with v5.6.30.
Now its time to replace the server.

To speed up the migration of the databases, I don't want to reimport the database dumps. I want to replicate the databases from on server to another (same version) and stop the changes at the databases at a certain time.

But I have on the old server the setting lower_case_table=0 and on the new server lower_case_table=1.
Is a replication with these different settings possible and are the replicated databses stored in lower case?


BR
Christian

Options: ReplyQuote


Subject
Views
Written By
Posted
Replication with different lower-case-table setting
1328
May 20, 2016 02:02AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.