<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. <b>Before you go on, stop the FogBugz Maintenance Service</b>.</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>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>