<p><strong>1.</strong> Log into your hosted account as a Site Administrator. Click Settings at the top right, then "My On Demand Account", and click the download link for "MySQL format". Download and save the .sql file to your computer.</p> <p><strong>2.</strong> Install FogBugz fully and get it working (even add a test case). Remember the FogBugz user and password that you set for the database.</p> <p><strong>3.</strong> Once its working, log into mysql. You should be able to log on using the <em>fogbugz </em>user and password at this point. The instructions assume your FogBugz database is called 'fogbugz'. If not, replace <em>fogbugz</em> with the name of your database.<br /> <br /> mysql> drop database <em>fogbugz</em>;<br /> mysql> create database <em>fogbugz</em>;<br /> mysql> use <em>fogbugz</em>;<br /> mysql> source <em>/path/to/trial.sql.dat</em><br /> mysql> grant all on <em>fogbugz</em>.* to <em>fogbugzuser</em> identified by <em>'fogbugzpassword'</em>;<br /> mysql> grant all on <em>fogbugz</em>.* to <em>fogbugzuser@'localhost'</em> identified by <em>'fogbugzpassword'</em>;</p> <p>Note the ' around the 'localhost' part. You can replace localhost with the server name if your FogBugz server is on a different machine. You should replace all italicized values above with values corresponding to your setup and environment.</p> <p>Note the use of the "source" command above. Do not simply paste the contents of the .sql file into a MySQL GUI and run it. Tests have shown that this results in corrupted cases under certain circumstances.<br /> <br /> <strong>4.</strong> Then go back into FogBugz through your web browser. You will have to enter your order info for licenses again.</p> <p><strong>5. </strong>If you are running on Unix or Mac, edit the Setting table in your FogBugz database so that the row with <strong>fPasswordEnable</strong> as the sKey has a sValue of <strong>0</strong> (zero).</p> <p>mysql> use fogbugz;<br />mysql> UPDATE Setting SET sValue = '0' WHERE sKey = 'fPasswordEnable';</p> <p>This turns off passwords so you can log into your account (the passwords are stored in a different format on Windows vs. Unix/Mac and the hosted server is Windows). You will need to reset all the user passwords using FogBugz (or go into the database and set them all to 'AA' which is synonymous for a blank password).</p> <p>To turn passwords back on, set the value of the key <strong>fPasswordEnable</strong> back to <strong>1</strong> (one).</p> <p>mysql> use fogbugz;<br />mysql> UPDATE Setting SET sValue = '1' WHERE sKey = 'fPasswordEnable';</p> <p><strong>Windows: </strong>If you are running MySQL on Windows, please see <a href="http://www.fogcreek.com/FogBUGZ/KB/dbsetup/UsingMySQL.html">this guide</a>. </p>