LiquibaseFixes

 java -jar liquibase-core-1.8.1.jar 
 --driver=com.mysql.jdbc.Driver 
 --changeLogFile=install.changelog.xml 
 --url="jdbc:mysql://boomer/databasename" 
 --username=username 
 --password=password 
 --classpath=.:./mysql-connector-java-5.1.6.jar 

Generic command structure:

The format of the command line is the same for all operations, just use the different commands to make changes to the db:

 java -jar liquibase-core-1.8.1.jar  --driver=com.mysql.jdbc.Driver  --changeLogFile=install.changelog.xml  --url="jdbc:mysql://boomer/databasename"  --username=username  --password=password  --classpath=.:./mysql-connector-java-5.1.6.jar  changelogSync

Use the command 'changelogSync' with the above Java command to force a correct MD5? fingerprint on the database.

Environment setup

In order to apply Liquibase operations to the database, make a working directory that has the following files in it. These are part of the CONGO distribution, and should be easy to locate:

Sync : To reset the MD5 fingerprints

After making a manual change to the database or to the install.changelog.xml, you can force the database to have the 'correct' checksums (and stop Liquibase from trying to re-apply all the changes)

Run the command line utility to force the Sync:

To reset the MD5 fingerprints

Occasionally Liquibase needs to be 'tweaked' due to back-porting of changes or removing old unused tools. A good reference point for this is available here: http://www.liquibase.org/manual/command_line

 dbs@nimitz:~/liquibase$ ls -l
 total 1288
 -rw-r--r-- 1 dbs dbs  31421 2011-05-30 11:32 install.changelog.xml
 -rw-r--r-- 1 dbs dbs 567247 2011-05-30 11:09 liquibase-core-1.8.1.jar
 -rw-r--r-- 1 dbs dbs 703265 2011-05-30 11:09 mysql-connector-java-5.1.6.jar

 java -jar liquibase-core-1.8.1.jar 
 --driver=com.mysql.jdbc.Driver 
 --changeLogFile=install.changelog.xml 
 --url="jdbc:mysql://boomer/databasename" 
 --username=username 
 --password=password 
 --classpath=.:./mysql-connector-java-5.1.6.jar 
 changelogSync

Occasionally Liquibase needs to be 'tweaked' due to back-porting of changes or removing old unused tools.

To reset the MD5? fingerprints

After making a manual change to the database or to the install.changelog.xml, you can force the database to have the 'correct' checksums (and stop Liquibase from trying to re-apply all the changes)

To do this, set up a working directory that looks like this: <pre>dbs@nimitz:~/liquibase$ ls -l total 1288 -rw-r--r-- 1 dbs dbs 31421 2011-05-30 11:32 install.changelog.xml -rw-r--r-- 1 dbs dbs 567247 2011-05-30 11:09 liquibase-core-1.8.1.jar -rw-r--r-- 1 dbs dbs 703265 2011-05-30 11:09 mysql-connector-java-5.1.6.jar </pre>

Run the command line utilityto force the Sync:

<pre>java -jar liquibase-core-1.8.1.jar --driver=com.mysql.jdbc.Driver --changeLogFile=install.changelog.xml --url="jdbc:mysql://boomer/databasename" --username=username --password=password --classpath=.:./mysql-connector-java-5.1.6.jar changelogSync</pre>