Mantis Bug Tracker - Forums

I have managed to create 2 databases - I took my mantis data from another box and thought I was inserting it into my new mantis database; instead,I created another. How do I (running Windows, not UNIX) insert the records from one database to the other.?

Thanks

Do you have a SQL client on Windows?

yes, I have phpadmin and mysql....

With PHPMyAdmin you can import/export database.

when I go to import, I'm told the table already exists; I want to append to the table or update it; when I exported it, I exported as file type 'update' but I'm still having the same error.

Open the file and replace all "CREATE TABLE" by "CREATE TABLE IF NOT EXISTS"

This probably will cause more issues: you're going to have problems as both databases will be using the same IDs which will just cause headaches.

I'd look into using MantisConnect to try and basically read issues from one Mantis instance and write to another.