1)解压,path配置之后,执行migrate init testdb初始化
会产生drivers、environments和scripts三个文件夹,
2)在environments的development.properties文件中添加数据库连接信息,再执行migrate status
此时可能会报数据库连接错误,打开drivers是个空文件夹,添加mysql-connector-java包,执行上面命令
3)执行migrate up,将数据上传到数据库中
此时可能会报错误: Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ALTER TABLE CHANGELOG
ADD CONSTRAINT PK_CHANGELOG
PRIMARY KEY (id)' at line 34
解决:打开scripts中的create_changelog.sql文件删除以下内容:ALTER TABLE ${changelog}
ADD CONSTRAINT PK_${changelog}
PRIMARY KEY (id);