This Tutorial is meant for windows admins, who have root access to their server.
MySQLDumper-Version: 1.21 b6
----------------------------------------------------------------
Requirements:
- Windows Server
- working Perl + PHP
- IIS 6
----------------------------------------------------------------
Preparation:
The following modules have to be installed for Perl, if they aren't yet:
- DBI
- File::Find
- File::Basename
- Compress::Zlib
- Net::FTP
- MIME::Lite
- The User, who should use the MSD, have to be already set in the user management. In this example the user is called mysqladmin. The standard status "User" is okay. You should take care to choose a save password.
----------------------------------------------------------------
Now you create a directory in the inetpub for the MSD. In this example mysql.domain.de
After decompressing the MSD in this directory you have to give the user mysqladmin full access.
After the install you should set the rights back to "read, execute". But you have to give writing access to the work directory. Otherwise the dumper could not write the backup files.
The full access in the beginning is given because the dumper have to create the work directory and have to write into the config.php file.
In any case the "Internet Guest Account (IUSR_ANONYMOUS)" should not appear in the list or get any rights!
Otherwise everyone could mess with your databases.
----------------------------------------------------------------
Now switch over to the "Internetinformationservice-Manager" in the MMC. Create a new website / domain.
Take care to uncheck the "Allow anonymous access" Box in the "Web Site Creation Wizard":
After creating the website with the Creation Wizard, go to the "Properties" of your freshly created domain, navigate to "Home Directory".
Take care that the "Script source access" and "Read" is set.
Once you are there you could activate Perl for the MSD. Just click the Button "Configuration".
Scroll to the extension .pl - after clicking "Edit" the mask "Add/Edit Application Extension Mapping" will appear.
Select "All verbs".
Perhaps the path to the perl.exe have to be modified.
Save all changes - now all preparation in the IIS is done.
----------------------------------------------------------------
Installation:
Now install the MSD with the installer. e.g:
http://mysql.domain.de/install.php
During the installation process the "work" directory should be created, including subdirectories.
If this is not done, you have to do it yourself. Best check the Readme for doing this.
Now the MSD is ready to rock, at least with PHP:
----------------------------------------------------------------
Adjusting the Perl Files:
Now, as described in the Readme, adjust the Perl files in the "msd-cron" directory for Windows:
Windows user must change the first line of all Perl scripts, to the path of Perl.
Example:
instead of: #!/usr/bin/perl w
now #!C:\perl\bin\perl.exe w
These two lines of Code have to be modified too:
my $absolute_path_of_configdir="D:/Inetpub/mysql.domain.de/work/config/";
my $cgibin_path="D:/Inetpub/mysql.domain.de/work/config/"; # this is needed for MIME::Lite if it is in cgi-bin
In my configuration the mail function of the crondump.pl did not function. Try this fix for it:
search incrondump.pl:
MIME::Lite->send("sendmail", "/usr/lib/sendmail -t -oi -oem");
and replace with:
MIME::Lite->send('smtp', 'localhost', Timeout=>60);
It could be different depending on the server configuration.
In my case it works.
Now the installation ist done and the MSD should work without any errors.
Note:
No need to be irritated by this warning:
"Create directory protection Urgently recommended !"
The directory protection is now secured by the windows system. IIS does not support .htaccess .
