MySql schema vs. database problem

General Discussion
1

I’m trying to compare two mysql databases.


When I’m specifying the database in the URL the diff command results in changelogs containing the different schema although the databases are identical. E.g.:


  2.        


This makes no sense as the other database has always a different schema and the schema shouldn’t be a thing to migrate - in mysql “database” is equivalent to “schema” it results in an error like “Can’t create table 'migratedb.#sql-9db_6f”. Removing both attributes fixes this. The problem is that I would need to remove it every time I diff the databases.


When I try to solve this problem and execute the diff with explicit schemas (via --defaultSchemaName and --referenceDefaultSchemaName) then liquibase says unexpected command parameters due to referenceDefaultSchemaName. Was the parameter removed since this post:

http://forum.liquibase.org/topic/mysql-get-sql-statements-of-difference-between-two-tables-to-update-the-latest


?


How can I fix this?