show/hide this revision's text 4 lose the broken link, highlight the gotchas link

NB: Before you go through any of this, you should make sure there are no FogBugz-unfriendly settings in your MySQL instance.

1. 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.

2. Install FogBugz fully and get it working (even add a test case).  Remember the FogBugz user and password that you set for the database. Before you go on, stop the FogBugz Maintenance Service.

3. Once its working, log into mysql. You should be able to log on using the fogbugz user and password at this point.  The instructions assume your FogBugz database is called 'fogbugz'.  If not, replace fogbugz with the name of your database.

mysql> drop database fogbugz;
mysql> create database fogbugz;
mysql> use fogbugz;
mysql> source /path/to/trial.sql.dat
mysql> grant all on fogbugz.* to fogbugzuser identified by 'fogbugzpassword';
mysql> grant all on fogbugz.* to fogbugzuser@'localhost' identified by 'fogbugzpassword';

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.

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.

4. Then go back into FogBugz through your web browser. You will have to enter your order info for licenses again.

Windows: If you are running MySQL on Windows, please see this guide.
show/hide this revision's text 3 should not need to turn off passwords

1. 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.

2. Install FogBugz fully and get it working (even add a test case).  Remember the FogBugz user and password that you set for the database. Before you go on, stop the FogBugz Maintenance Service.

3. Once its working, log into mysql. You should be able to log on using the fogbugz user and password at this point.  The instructions assume your FogBugz database is called 'fogbugz'.  If not, replace fogbugz with the name of your database.

mysql> drop database fogbugz;
mysql> create database fogbugz;
mysql> use fogbugz;
mysql> source /path/to/trial.sql.dat
mysql> grant all on fogbugz.* to fogbugzuser identified by 'fogbugzpassword';
mysql> grant all on fogbugz.* to fogbugzuser@'localhost' identified by 'fogbugzpassword';

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.

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.

4. Then go back into FogBugz through your web browser. You will have to enter your order info for licenses again.

5. If you are running on Unix or Mac, edit the Setting table in your FogBugz database so that the row with fPasswordEnable as the sKey has a sValue of 0 (zero).

mysql> use fogbugz;
mysql> UPDATE Setting SET sValue = '0' WHERE sKey = 'fPasswordEnable';

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).

To turn passwords back on, set the value of the key  fPasswordEnable back to 1 (one).

mysql> use fogbugz;
mysql> UPDATE Setting SET sValue = '1' WHERE sKey = 'fPasswordEnable';

Windows: If you are running MySQL on Windows, please see this guide.

show/hide this revision's text 2 added 63 characters in body

1. 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.

2. Install FogBugz fully and get it working (even add a test case).  Remember the FogBugz user and password that you set for the database. Before you go on, stop the FogBugz Maintenance Service.

3. Once its working, log into mysql. You should be able to log on using the fogbugz user and password at this point.  The instructions assume your FogBugz database is called 'fogbugz'.  If not, replace fogbugz with the name of your database.

mysql> drop database fogbugz;
mysql> create database fogbugz;
mysql> use fogbugz;
mysql> source /path/to/trial.sql.dat
mysql> grant all on fogbugz.* to fogbugzuser identified by 'fogbugzpassword';
mysql> grant all on fogbugz.* to fogbugzuser@'localhost' identified by 'fogbugzpassword';

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.

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.

4. Then go back into FogBugz through your web browser. You will have to enter your order info for licenses again.

5. If you are running on Unix or Mac, edit the Setting table in your FogBugz database so that the row with fPasswordEnable as the sKey has a sValue of 0 (zero).

mysql> use fogbugz;
mysql> UPDATE Setting SET sValue = '0' WHERE sKey = 'fPasswordEnable';

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).

To turn passwords back on, set the value of the key  fPasswordEnable back to 1 (one).

mysql> use fogbugz;
mysql> UPDATE Setting SET sValue = '1' WHERE sKey = 'fPasswordEnable';

Windows: If you are running MySQL on Windows, please see this guide.

show/hide this revision's text 1