Posted 2 years ago #
Hey guys. My blog as hacked and delted so i made a new post about it. Today I am going to back it up. However, the new post I made about the hack has 400+ comments so I would like to after I backup my blog, also import that single post with it's comments.
How would I go about?
Don't know that you can do that without either editing the backup file or the Tools->Export file.
With the coming Version 3.0 you will be able to filter the export to allow such a thing.
Posted 2 years ago #
Well I can't export the whoe file as it's over 2000posts and a few hundred of mb's.. Can it be done via phpmyadmin, and if so, how should I go about? Thanks
If you could export just that post and the related comments. Then what are you going to do with 'export' file?
Well you could use phpMyAdmin operations and copy the posts and comments tables to two new tables, then delete everything in each table but the post id in question.
Posted 2 years ago #
Cause I did a export from wordpress as the database was hacked and pass changed. So i made a export file and the host i have restored my bakcup.. so now the database is without that new post I made.
You'll probably have to use a text editor and delete everything you DON"T want imported.
Posted 2 years ago #
Let me start all over cause I don't think you understand me.
The site was hacked and everything deleted. The hackers made 1 post called it "Site has been hacked".
I changed that post and people started commenting.
I exported the file using wordpress's export tool before they host backed my site up to the time before the hack.
So now I have a normal blog with loads of posts. and a export file with only 1 post and 400+ comments.
I would like to insert that post into the entire blog.
I can't export the full blogg with wordpress tool and just add the lines for the post + comments as the file is a few hundred mb and it only allwos me to upload 8mb.
I thought I could make a new blog, empty. import the txt file with the post and 400 comments.
Then I could export that using phpmyadmin as a sql file and import it in the old blog.
My problem is. I have no idea how to make a sql querry for that, neither how to get the posts + comments, nor how to insert them.
So any help would be greatly appreciaited.
Posted 2 years ago #
Come on, someone @ this place should know? :S
Posted 2 years ago #
What should i take out from DB1 to insert into DB2?
This topic has been closed to new replies.
