BEGINFUNCTIONS
 FUNCTION BackupLog
  DBUSE odbcDSN /odbc
  IFERROR RETURN
  SET BackupLog_file = staging + "\" + dbName + "_" + %datetime + "_log.bak" 
  DBQUERY "USE master"
  IFERROR RETURN
  SET sSQL = "BACKUP LOG " + dbName + " to disk='" + BackupLog_file  
  SET sSQL = sSQL + "' WITH INIT, SKIP, NAME='Transaction Log Backup'"
  DBQUERY sSQL 
  IFERROR RETURN
  DBCLOSE 
  RETURN $ERROR_SUCCESS
 ENDFUNCTION
ENDFUNCTIONS

SET dbName = "MySQLServerDB"
SET odbcDSN = "MySQLServerDB_Offsite"
SET ManagedSite = "LogShipping"
SET staging = %installdir + "\ProgramData\LogShipping"
SET archive = staging + "\archive"
ARCHIVEDIR archive

BackupLog
IFERROR RETURN

WORKINGDIR staging
IFERROR RETURN

FTPLOGON ManagedSite
IFERROR RETURN
FTPTMPNAME "" ".partial"

:send_files
GETNEXTFILE "*" /oldest 
IFERROR RETURN $ERROR_SUCCESS

SENDFILE %nextfile /archive 
IFERROR RETURN
GOTO send_files