The file conf.xml is used for configuration settings. Make sure that file is placed in the same directory as your dbbackup.exe file.
<?xml version="1.0" encoding="utf-8"?>
<profile>
<section name="MySQL">
<entry name="Backup">True</entry>
<entry name="PathToResult">f:\backuper\DD-YYYYMMDD\mysql\</entry>
<entry name="Password">whatever</entry>
<entry name="ServerName">localhost</entry>
<entry name="Userid">root</entry>
<entry name="ExcludedDatabases">
</entry>
</section>
<section name="MSSQL">
<entry name="Backup">True</entry>
<entry name="PathToResult">f:\backuper\DD-YYYYMMDD\mssql\</entry>
<entry name="Password">whatever</entry>
<entry name="ServerName">(local)</entry>
<entry name="Userid">sa</entry>
<entry name="ExcludedDatabases">TMProd, TMTest</entry>
</section>
</profile>
There are two sections - one for MySQL and one for MSSQL.
Backup: true/false
Set to true of you want to run the backup. Most used for testing purposes
PathToResult: path
The place where the resulting backup files will be placed. Please note that you can use the special variable DD-YYYYMMDD which will then be translated to something like 20061011 - i.e the current date.
Password:
The db password
Userid
The userid to use
ServerName
The servername - typically localhost/(local)
ExcludedDatabases
Databases NOT to backup. Separate by comma
The cmd files
When running the system retrieves available databases and calls the cmd files - backmysql.cmd and backmssql.cmd. So make sure these files are in the same directory as the exefile as well. YOU WILL NEED TO CHANGE THE PATH TO OSQL AND MYSQLDUMP INSIDE THESE FILES:
"C:\Program\MySQL\MySQL Server 5.0\bin\mysqldump.exe" --host %1
--user %2
--password=%3
--databases %4
--compatible=mysql40
> "%5"
"c:\program\microsoft sql server\80\tools\binn\osql.exe"
-s %1
-U %2
-P %3
-Q "BACKUP DATABASE %4 TO DISK='%5'"
