Project

General

Profile

Forums » Help »

Where does redmine mysql store its data

Added by Anonymous over 12 years ago

I am on a debian system with a freshly installed redmine using a mysql data base.

When adding something to the data base the files under /var/lib/mysql/redmine remain unchanged, in addition there are only .frm files containing the table schema, no .MYD files, usually containing the data. Redmine seems to store the data in an other place but where?

Thanks,
Christian


Replies (3)

RE: Where does redmine mysql store its data - Added by Tony Marschall over 12 years ago

seems to be a debian/mysql specific question. Did you have a look into your database with mysql tools and configuration files (/etc/mysql)?

RE: Where does redmine mysql store its data - Added by Anonymous over 12 years ago

When I connect to my data base using the mysql command I can see the data is there. For all other data bases despite redmine a table is stored in 3 files under /var/lib/mysql/otherdb/:
table1.frm (table structure)
table1.MYD (table data)
table1.MYI (indexes)

But for /var/lib/mysql/redmine/ it's only
table1.frm

And this file is not changed when I add something to the db.

RE: Where does redmine mysql store its data - Added by Ivan Cenov over 12 years ago

You may run MySQL Administrator to see what is the database storage. May be it is InnoDB? In such case all databases that are InnoDB share a single data file.

    (1-3/3)