I have PHPmyadmin on the current site and I have the backup of the old and new posts, I just don’t know how to attempt to integrate them without destroying more than I already have.
Correct me if I’m wrong:
– You have backup 1 which has everything except the users table.
– You have backup 2 which has the users table and subsequent (but no original) posts
– You need to wedge those two together ?
If this is correct, how many subsequent posts do you have ?
Could it be possible – given you have comments etc – to get backup 1 working, then manually add posts from backup 2 ?
Just trying to mix the databases into 1 is nigh on impossible, hence my ponderings.
I had a feeling that is what you were going to say, there are only 30 subsequent posts and not that much more in comments. Podz, what would be the best way to do this?
BTW, the original backup does have the users table but when I moved it to the new host it never acted right.
Okay…….what needs to happen is this:
Install backup 1 into a database.
Then using the initial code that WP uses to create the wp-users table, along with any other info that can be gleaned from the posts, we need to create the users table so that it actually does work – shows you as the author and does not delete etc….
Export it
Import it and check (to be sure)
Then export, import into your database and then you add the subsequent bit.
Needless to say, the last bit is tedious but easy, the first is interesting and I’ll be honest I’ve both not done it before or know how easy it will be – but it cannot be impossible (he says hopefully)
I have xampp setup here and can mess with databases easily and quickly. Do you want to email me the .sql backup 1 ?
I can create a testblog and try to get things going by comparing to my backup of my blog that I have.
I’ll certainly try 🙂
tamba2 at gmail dot com
(If you have IM, let me know what in the mail and I’ll fire up miranda)
I emailed you the information. Hope to hear from you!