-
Type:
Task
-
Resolution: Unresolved
-
Priority:
Highest
-
None
-
Affects Version/s: None
-
MMU
-
Prod
Hi All,
Script is prepared and shared to Rajeev to check the in local system but its show error while running, its show path is not correct.
@echo off
set MYSQL_PATH="C:\Program Files\MySQL\MySQL Shell 8.0\bin"
set USER=root
set PASSWORD=your_password
set HOST=127.0.0.1
set PORT=3306
set DATABASE=db_iemr :: any default schema, not important if you use fully-qualified names
set SQL_FILE=C:\Temp\APL MMU Daily report.sql
set OUTPUT_FILE=C:\Temp\report.csv
"%MYSQL_PATH%\mysqlsh.exe" --sql --user=%USER% --password=%PASSWORD% --host=%HOST% --port=%PORT% %DATABASE% --result-format=csv --file=%SQL_FILE% > %OUTPUT_FILE%
echo Export done! Saved at %OUTPUT_FILE%
pause