Database Migration Problems
I am trying to move a MySQL FogBugz Database from the server that has FogBugz installed to a new server without a FogBugz installation. I assumed all I had to do was export the current database and then import it into the new database, then change the ODBC entry to point to the new database, but I get the following error when I do that.
Its trying to upgrade the database because it thinks the database is version 0, (because it can't log in). You need to give the FogBugz user on the machine full access to the new database you created. If you're using SQL server and the server used to be on the same machine as IIS and now it isn't, you will have to use sql server authentication and include the userid and password in the connection string. See http://www.connectionstrings.com
Michael H. Pryor
Fog Creek Home