I'm trying to download a copy of our FogBugz database from on demand. On the "Download MySQL / SQL Server Database" page (I've tried both), I hit "Begin Copy" and it runs to completion without problems and displays the "Download" button.
The download runs for a bit and apparently completes, but regardless of the database format chosen the .sql / .mdf files are 52,431,826 bytes in size, and both contain the following server error at the end of the file. I've tried this several times, using both versions of the database file, and the always end up this size, with the server error.
I'm supposed to be migrating our FogBugz from On Demand to an internally hosted instance this weekend - how can I go about getting our data?
This is the last part of the .sql version:
INSERT INTO `Revision` (`ixRevision`, `ixWikiPage`, `ixTemplate`, `ixPerson`, `sRemoteIP`, `nRevision`, `sTitle`, `sBody`, `sComment`, `fDiff`, `dt`, `dblStrength`, `ixTagEventLatest`) VALUES (350, 66, -1, 2, '', 15, '2.3 Database Changes', '--- c:\\www\\hosted.fogbugz.com\\172\\Accessories\\Diff\\FB4FBF.tmp 2009-04-22 01:52:11.796126100 -0400\n+++ c:\\www\\hosted.fogbugz.com\\172\\Accessories\\Diff\\FB4FC0.tmp 2009-04-22 01:52:11.796126100 -0400\n@@ -583,16 +583,6 @@\n </tr>\n <tr >\n <td >\n-Update migration script\n-<br />\n-</td>\n-<td align=\"right\" style=\"text-align:right;\">\n-2\n-<br />\n-</td>\n-</tr>\n-<tr >\n-<td >\n Fix problems with DB test harness\n <br<html>
<head>
<title>Runtime Error</title>
<style>
body {font-family:"Verdana";font-weight:normal;font-size: .7em;color:black;}
p {font-family:"Verdana";font-weight:normal;color:black;margin-top: -5px}
b {font-family:"Verdana";font-weight:bold;color:black;margin-top: -5px}
H1 { font-family:"Verdana";font-weight:normal;font-size:18pt;color:red }
H2 { font-family:"Verdana";font-weight:normal;font-size:14pt;color:maroon }
pre {font-family:"Lucida Console";font-size: .9em}
.marker {font-weight: bold; color: black;text-decoration: none;}
.version {color: gray;}
.error {margin-bottom: 10px;}
.expandable { text-decoration:underline; font-weight:bold; color:navy; cursor:hand; }
</style>
</head>
<body bgcolor="white">
<span><H1>Server Error in '/' Application.<hr width=100% size=1 color=silver></H1>
<h2> <i>Runtime Error</i> </h2></span>
<font face="Arial, Helvetica, Geneva, SunSans-Regular, sans-serif ">
<b> Description: </b>An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine.
<br><br>
<b>Details:</b> To enable the details of this specific error message to be viewable on remote machines, please create a <customErrors> tag within a "web.config" configuration file located in the root directory of the current web application. This <customErrors> tag should then have its "mode" attribute set to "Off".<br><br>
<table width=100% bgcolor="#ffffcc">
<tr>
<td>
<code><pre>
<!-- Web.Config Configuration File -->
<configuration>
<system.web>
<customErrors mode="Off"/>
</system.web>
</configuration></pre></code>
</td>
</tr>
</table>
<br>
<b>Notes:</b> The current error page you are seeing can be replaced by a custom error page by modifying the "defaultRedirect" attribute of the application's <customErrors> configuration tag to point to a custom error page URL.<br><br>
<table width=100% bgcolor="#ffffcc">
<tr>
<td>
<code><pre>
<!-- Web.Config Configuration File -->
<configuration>
<system.web>
<customErrors mode="RemoteOnly" defaultRedirect="mycustompage.htm"/>
</system.web>
</configuration></pre></code>
</td>
</tr>
</table>
<br>
</body>
</html>
