WordPress.org

1. wpfairchild
   Member
   Posted 5 months ago #

   I run a wordpress multi-site installation at a University. A former student created a weblog while he was studying and now wants to maintain the site away from the University. The main problem is that the site was hacked (no longer able to login as admin, generic login page). Since the student had graduated I simply installed a new copy of wordpress and created a new database for the new semester. I still have a pre-hack backup of the site that should work, but now I'm only interested in the single site. Can I export only his site (wp_123_***) and move it to wordpress.com?

   Any suggestions are welcome!
   Thanks in advance,
   Bill

2. Ipstenu
   Half-Elf Support Rogue & Mod
   Posted 5 months ago #

   If you really like this guy, you could do this:

   Make a new, separate, single install of WordPress on a new Database

   Copy the wp_123_** tables from the backup database to this DB and rename them wp_***. You should ONLY need to bring the wp_123_post and wp_123_postmeta tables.

   That should bring it up the posts. The author may be screwy though so I'm not 100% sure... You may need to copy his user ID info from the backup DB's wp_user and wp_usermeta tables.

   Also, unless you have a backup of all his images (they would have been in wp-content/blogs.dir/123/files/ ) he'll lose those.

3. wpfairchild
   Member
   Posted 5 months ago #

   I do have a backup of the images, etc. as well. I'll give it a try and see how it goes.

   Thanks for the clue!

4. Ipstenu
   Half-Elf Support Rogue & Mod
   Posted 5 months ago #

   No problem :) I'd probably do it as an experiment for the day I had to do it for real ;)

5. wpfairchild
   Member
   Posted 5 months ago #

   Okay, that's mostly working, but attached files are attempting to link to my webserver (I used a localhost installation). Do I just need to do something like:

   UPDATE wp_options SET option_value = replace(option_value, 'http://www.old-domain.com', 'http://www.new-domain.com') WHERE option_name = 'home' OR option_name = 'siteurl';

6. Ipstenu
   Half-Elf Support Rogue & Mod
   Posted 5 months ago #

   That's exactly right.

   You may also need to to that for wp_posts to point internal links correctly.

Reply

You must log in to post.