Command-line tool to dump MySQL tables to Microsoft Excel .xlsx Spreadsheets written in Java.
Download the latest release from https://github.com/DevDungeon/mysql2excel/releases or clone the repo from https://github.com/DevDungeon/mysql2excel
git clone https://github.com/DevDungeon/mysql2excel
# Compile and package with Maven
cd mysql2excel
mvn package
java -jar mysql2excel-1.0.3.jar -h
java -jar mysql2excel-1.0.3.jar -g sample.config
java -jar mysql2excel-1.0.3.jar my.config
NanoDano [email protected]
He Zengliang [email protected]
-
2020-12-02 v1.0.4
- bugfix: avoid out of memeory error
-
2020-12-02 v1.0.3
- enhancement: added offset of
dateandtime. e.g.date+1/time-1
- enhancement: added offset of
-
2020-12-01 v1.0.2
- enhancement: changed tablename to array
- enhancement: added condition for all tables
- enhancement: add replacement with
dateandtimefor output file name and auto creating directory
-
2018-03-25 v1.0.1
- Bug fix: added convert zeroDateTimeBehavior to convertToNull, minor formatting tweaks
-
2018-03-18 v1.0.0
- Initial stable release
- Allow multiple tables or all tables to be dumped at once
- Allow custom SQL query to be run