V2 /
LiquibaseFixesV2.LiquibaseFixes HistoryHide minor edits - Show changes to output Changed lines 16-22 from:
java -jar liquibase-core-1.8.1.jar to:
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 Added lines 13-24:
!! 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 Changed lines 29-38 from:
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 to:
Use the command 'changelogSync' with the above Java command to force a correct MD5 fingerprint on the database. Changed lines 3-8 from:
!! After making a manual change to the To do this, set up a working directory that looks like this to:
!! 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: Changed lines 13-17 from:
to:
!! ''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: Changed line 3 from:
!! To reset the to:
!! To reset the `MD5 fingerprints Changed line 1 from:
Occasionally Liquibase needs to be 'tweaked' due to back-porting of changes or removing old unused tools. to:
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 Changed lines 8-14 from:
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 to:
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 Changed lines 16-23 from:
--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 to:
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 Added lines 1-24:
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> |