Question

How can I import a FogBugz On Demand trial database into MySQL?

Answer 1

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

1. Email customer-service@fogcreek.com to request a MySQL export of your FogBugz account. It will be provided on an FTP site for you. 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.

Answer 2

If you get errors during the "source" command, your instance of MySQL might be running in SQL strict mode. This needs to be disabled for FogBugz databases to operate correctly. (Strict mode is useful for when you want the database to offer all kinds of constraints; we put these constraints in our code, not the database schema.)

To disable strict mode, log into MySQL and run:

SELECT @@global.sql_mode;

If you get anything other than a blank string back, run:

SET @@global.sql_mode = '';

Note: This setting might be set in your MySQL configuration files, so if you restart MySQL, strict mode might be re-enabled, which will interfere with the normal operation of FogBugz. Check your my.cnf or my.ini file for lines that set the sql_mode setting.

Answer 3

If your plugins are broken after import, re-install them per this question.