I want a C# console application which can take the following parameters and can either backup the database and perform optimize.
1) mySQL login url
4) catalog name aka database name
5) actiontype (OPTIMIZE or BACKUP)
6) backup type: full or incremental
7) backup folder (like 'c:\mySQL\backup')
9) FTP url
10) FTP userid
11) FTP password
12) 7-zip backup password
if OPTIMIZE is passed, the the all the tables an indexes in the database should be optimized. The optimize result should be recorded in a log file (cummulative with datetimestamp, table name, index name, start time, end time etc..)
an input file can be used to list all the tables and indexes of the database.
if BACKUP is selected, the database should be backed up either FULL or INCREMENTAL depending on backup type passed. The backup should be 7-zipped ([url removed, login to view]), password protected and named <databasename>_<backuptype>[url removed, login to view])
PS-1: We need to use EDFTP and on successful completetion, and email should be generated with some detail.
PS-1: 7-zip working code and instruction will be provided
PS-2: edftp working code and instruction will be provided