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