I have two databases. See screenshot below for better explanation. I want database one to be merged into database two and have database two be the main database with all information in it so I can get rid of database one. How do I go about doing this?
"Export" the contents of phpb1 as SQL with the following options. Only data exported (uncheck structure). Then open in notepad and do a find/replace, changing `jerlene_phpb1` to `jerlene_phpbb1` (note the backticks). The problem then is the keys. If both are forums with a number of posts and members already in them (are they?), then the keys will probably clash. If you know some server side scripting, you can parse the SQL and force it to use new IDs but then there is the problem with table relationships based on the IDs which requires some work.
I understood almost nothing of that. lol Sorry. But yes, it's a forum with members and posts. I think it was like 300+ members and posts.
I suggest you hire a Certified Database Administrator to do a job like that. They will create a script that copies the data from one db to the other. By doing so, the keys can be replicated without a problem. I am not a certified DBA, but I do know a few. It shouldn't be too expensive. PM me if you want the contact info. Cheers!
You do not really need a certified administrator for a task like this.. It only takes 10 minutes for someone who knows a little MySQL However why would you want to merge the databases if you find it difficult to export a database?!? You can simply back up the database and store it for when you will need it later
the phpbb webiste has, or should have, loads of info on this subject, plus the converter scripts to do the job. all for free. now i'm not saying phpbb is good stuff, i'm just saying these resources exist. SMF rocks.