howto change fisheye database name ?

Martin64

Hi !

I run and administer fisheye 2.10.1. My predecessor set the database to 'fisheye_2101' ...

I am not sure it is a good thing to include version in current active database name... as database schema is going to be upgraded when fisheye gets updated so the name isn't going to reflect the schema version anymore. So before trying and upgrade, I want to revert back to more common name like 'fisheye'. Here is what I did so far:

- stopping fisheye

- copy fisheye_2101 to fisheye (using phpmyadmin)

- Now what ? Do I have to edit config.xml to change to the new database name and start fisheye ? I didn't find anything in the documentation about that.

I tried to change the database reference from the UI but can't save the settings (I can only hit "save and migrate").

Thanks !

Sven [Dione Technology]

Hi Martin,

I suppose you are using Mysql (Phpmyadmin).

I think the best is to rename directly your DB and change your fisheye config file.

http://dev.mysql.com/doc/refman/5.1/en/rename-database.html

1- stop fisheye

2- rename your db

3- change the reference to the new name in server.xml

4- start fisheye

Sven.