Offline MMU Daily Report Automation

XMLWordPrintable

    • 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

            Assignee:
            Venkatesh Bojja
            Reporter:
            Avinash Sharma
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated: