Import tables

lpantos · Post by **lpantos** » 09 Feb 2007, 14:35

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

deboutv · Post by **deboutv** » 14 Feb 2007, 13:13

Do you have a SQL client on Windows?

lpantos · Post by **lpantos** » 14 Feb 2007, 16:29

yes, I have phpadmin and mysql....

deboutv · Post by **deboutv** » 14 Feb 2007, 16:32

With PHPMyAdmin you can import/export database.

lpantos · Post by **lpantos** » 14 Feb 2007, 19:01

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.

deboutv · Post by **deboutv** » 14 Feb 2007, 19:16

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

Narcissus · Post by **Narcissus** » 15 Feb 2007, 19:17

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.