Log in

View Full Version : Merge with another site's DB but it is 100mb ?


Mean
01-25-2008, 11:28 AM
Hello.

My forum is using a db which is 76 mb. But i am gonna merge another site's db which is 100 mb. I am gonna use mysqldumper and impex.

But my question is, can some error occurs, and is it possible ??
I want to take your ideas...

Marco van Herwaarden
01-26-2008, 07:51 AM
We always advice to do a testimport on a testboard first. With imports you can never be sure what you run into.

Mean
01-26-2008, 06:48 PM
But I have only one database, and server dont allow me to make new one...
What should I do ?

SauravG
01-26-2008, 06:50 PM
Take a full backup before trying it.

snakes1100
01-26-2008, 07:01 PM
But I have only one database, and server dont allow me to make new one...
What should I do ?

Do either db's use a table prefix?

If neither of them do, what you can do is modify your live db and add a table prefix to each table or vise versa on the one your going to import.

With one of the two db's having a prefix and the other not having one, you can import it into your current db, then use impex to merge them.