Sysadmin « David Huby’s Blog

20Dec/080

Subversion via Apache

http://svn.spears.at/ is a straightforward guide to installing multiple subversion repositories and serving them via Apache.

I ran into one problem during installation - I downloaded a zip file containing subversion from tigris.org, and unzipped it into my Program Files\Subversion directory. The Apache service would not start. Since I was not using the installer I also had to add Program Files\Subversion\bin to my PATH.

The error in the event log appeared as:

Event Type: Error

Event Source: Apache Service

Event Category: None

Event ID: 3299

Date: 12/20/2008

Time: 5:19:33 PM

User: N/A

Computer: ********

Description:

The Apache service named reported the following error:

>>> httpd.exe: Syntax error on line 127 of C:/.../Apache2.2/conf/httpd.conf: Cannot load C:/.../Apache2.2/modules/mod_dav_svn.so into server: The specified module could not be found

This was despite it existing in the Apache2.2/modules directory.

Tagged as: Apache, Subversion No Comments

19Dec/080

Use the CALL command when nesting batch files

When nesting batch files, you must use the CALL command

first.bat

echo Begin first.bat

CALL second.bat

echo End first.bat

If the "CALL" command is not used, "echo End first.bat" will never be executed.

Tagged as: Batch files No Comments

19Dec/081

Daily or Hourly MySQL database backups on the command line in Windows

for /f "tokens=2,3,4,5,6 delims=/: " %%a in ("%date% %time%") do set timestamp=%%c-%%b-%%a-%%d-%%e

mysqldump -u DatabaseUsername -pPassword TheDatabaseName > C:\Archive\TheDatabaseName-%timestamp%.sql

References: http://technet.microsoft.com/en-au/library/bb490909.aspx

This currently points to the "for" article under Command Line reference A-Z under Windows XP in technet. Of course, by the time you click on the link, the article will have moved to a different URL.