I'm a Cocoa developer on the Mozy for Mac team, and occasionally I run into a problem where my Mozy installation has become confused. This has only happened twice in the long while I've been a Mozy user; however, both times proved to be a little annoying because I have lots of folders selected in the "Files and Folders" tab. When I reinstall Mozy to get it back on its feet, my selections get erased. In the past I have written these selections down on a piece of paper and then reselected them after reinstallation. Wait, what? Did I say paper? Why am I writing stuff down when I have a perfectly good computer right in front of me? Have no fear, the paperless solution is here!

Update: This was written for Mozy for Mac 1.3.x. The database schema was changed for Mozy 1.4. Everything was merged into a rules table.

Problem:

Mozy doesn't save your selections in "Backup Sets" or "Files and Folders" during reinstallation.

Solution:

It's fairly simple. Dump the database tables. (Huh?) We're going to export your information from the database Mozy uses before you reinstall and then import the information into the new database. Sounds hard, but it's not. There are a couple ways to do this. The first is the easy, point-and-click method. The second is for the command-line users who despise the rodent sitting next to your keyboard. I'm going to outline the easy method here. If you'd like to use the command-line, follow my logic, but use you l33t hax0ring skills to make it happen (and check out man sqlite3).

Easy way: Using the mouse

1. First thing you need to do is grab a SQLite application. A free, easy-to-use one I recommend is a Firefox add-on called SQLite Manager. It installs into Firefox and you can open it from the Tools menu. These instructions and screen shots assume you're using SQLite Manager.
2. Open SQLite Manager
   
3. Click Open (the open folder icon) and go to /Library/Application Support/Mozy/state.db
4. On the left, click on the "nodes" table and click on the "Export" button
   
5. Select the SQL tab, check the "BEGIN TRANSACTION" box, and click "Ok." Save the file.
   
6. Quit Firefox (best to do this to clear out its cache of the state.db)
7. Uninstall and Install Mozy.
8. After you're done with the setup assistant, let it launch the application where you normally make your selections (Configuration). Once that is open, you can close it.
9. Launch Firefox, go back into SQLite Manager, and open up state.db at the same location you did before.
10. This time, click on the large "Execute SQL" tab and paste in the code that you saved in step 5. Hit "Run SQL".
    
11. If it says "Not an error" then your Files and Folders selections have been successfully imported! Open Mozy and you should see them.

If you would like to save your Backup Sets selections, do the same thing, but export the "sets" table instead of "nodes."

Hope that saves you lots of time and grief! It sure saved me.