So, is there a way to move wordpress entries from one set of tables in a database to another? The reason I ask is because I installed a new version of wordpress for my new domain and I now have this brand new version but all my old wordpress entries are in the other tables. Please tell me there's a neat little sql statement that will let me do it.. I finally have the new version of WordPress working for my new domain. I want to remove the blog altogether from thefictionalme.com since I'll have the blog on my new domain. But I don't want to lose all those entries (almost 500) dating back to 2002. Please help..
*draws a picture*
original blog from thefictionalme.com is sitting in the database thefict_wordpress in tables:
new blog from new domain is sitting in the database thefict_wordpress in tables:
Is it possible people?