Project

General

Profile

MySQL dump everything that is in connection with 1 exact project

Added by Imre Bertalan over 9 years ago

Hello Forum!

I just got an issue to save and give all information about a project to someone else who also have Redmine installed. I assume I have to MySQL dump something out, but can't really find what do I need to export that they can just import and woala, there it is. Log times, Wiki, Issues, Gantt, Files, etc......

Can I have some support form you guys? :)

Thank you!


Replies (2)

RE: MySQL dump everything that is in connection with 1 exact project - Added by James H over 9 years ago

you need to find out what project id; query each and every table in redmine for that project id and save each entry id for each table you looked in; query each and every table that doesnt have project id with the appropriate key column(s) and save each entry for each table you looked in; export each saved entry from every single table; decide whether or not you want to keep the same id numbers from the original redmine (depends on if the other redmine has already used these id numbers); insert the entries into the other redmine; re-define auto-increment numbers per table as needed.

I think that will about get you there.

this is not an EASY task, if you aren't familiar with developing databases, you should probably not attempt this.

RE: MySQL dump everything that is in connection with 1 exact project - Added by Imre Bertalan over 9 years ago

Than you for the reply James! I've came up with the same idea yesterday afternoon and started working on it. Exported all the queries that contained the project_id I was looking for, but nothing else. The following tables had project_id:
Documents
enabled_modules
invoices
issues
members
project_trackers
tine_entries
users
version
wiki

I've exported these in csv (reduced the number in users because I don't want to import that one, it is just good to know who was working on that project). It turned out I don't need to import these into a new redmine install. Maybe somebody will have to, but ATM I'm happy that I don't need to do it. :)

Thank you again James! :)

B.R.:
Bert

    (1-2/2)