mysql - Liquibase fails to update a sql file

Question

I am using liquibase with mysql. I am using xampp: phpmyadmin to build my database. After I've built it, I export a sql file (So basically this ensures that the syntax is valid in the file). Then I try to update liquibase with the file:

java -jar C:UsersTalDesktopmysql_test
ode_modulesliquibaselibliquibase-4.0.0liquibase.jar --changeLogFile=C:UsersTalDesktopmysql_testliquibase
esourceinmates_1.sql --url=jdbc:mysql://localhost:3306/inmates --username=root --password= --classpath=C:UsersTalDesktopmysql_test
ode_modulesliquibaselibDriversmysql-connector-java-8.0.22.jar --driver=com.mysql.cj.jdbc.Driver update

• According to liquibase documentation I did use the correct driver and classpath.
• inmates_1.sql is the file generated in phpmyadmin which is valid one
• Of course the url, username, password are correct
• mysql version is: 10.4.17-MariaDB

But still, when I run this command above, I get an error:

Starting Liquibase at 22:02:44 (version 4.0.0-beta1 #6 built at 2020-04-20 18:23+0000)
Unexpected error running Liquibase: Migration failed for change set C:/Users/Tal/Desktop/mysql_test/liquibase/resource/inmates_1.sql::raw::includeAll:
     Reason: liquibase.exception.DatabaseException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'START TRANSACTION;
SET time_zone = "+00:00";

And very important, this line: START TRANSACTION; SET time_zone = "+00:00" which liquibase inform of invalid syntax, was generated by phpmyadmin.

Answer 1

等待大神答复