TeamCity deleted projects in restored database

Hi,

I have just moved my old TeamCity installation to a new computer, along with postgres database backup.
I have successfully restored the postgres backup, was able to see the data in tables (projects, users etc).

After the first start of TeamCity I realised that I have forgotten the password for admin account, but still remembered the one for guest, so I went to the database and upated teh "users" table accordingly.

After I started TeamCity and logged in I have discovered, to my huge surprise, that all teh projects are in fact gone.

I checked the table "projects" and they were not there as well.

So my question is - why does that happen and how can I avoid it? Is there a process to follow when restoring backups?

Thanks!

3 comments

Hello Artem,

  Actually, the project configuration is stored not in database, but in XML config files under <TEAMCITY_DATA_DIRECTORY>/config. So if you didn't migrate this data, the projects won't appear.
  Please read more on structure of TeamCity data at http://confluence.jetbrains.net/display/TCD5/TeamCity+Data+Directory

  Hope this helps,
  KIR

0

That worked, thanks!          

0

Useful information. Having assumed the projects were in the db and not having them after the upgrade, I added a new project.
Having read this thread, I stopped TC, copied the existing xml, dtd and xsd files to a backup directory and copied over the previous versions backed up config/xml etc files.
Restarted TC. And the "old" projects have not returned, still just the new project I added after the upgrade.
Any ideas to what I have done wrong?

0

Please sign in to leave a comment.