Where does redmine mysql store its data
Added by Anonymous almost 13 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 almost 13 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 almost 13 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 almost 13 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.