Installing WP on new domain using SQL or CSV

  • loveitloveitloveit

    (@loveitloveitloveit)


    14 years, 10 months ago

    My website was hacked last weekend, meaning it had to be suspended. In a panic, I took several actions which were probably very dumb – if there is any way to resolve this situation, I’d be grateful for your help. My technical skills are already at their limit, so please don’t worry that you’re patronising me with straightforward stuff, you really won’t be.

    – Old WP blog had a bespoke theme and was hosted as a subdomain on my site
    – In order to resolve the hacking problem I’ve moved the site to a new platform and host, which only lets you have wordpress.com sites as subdomains . Therefore, I’ve set up a new domain to host the blog on.
    – why, I don’t know, but my last action with access to wp/admin was to reroute the blog to a spare domain name. It’s not showing up there
    – with no access to the front end of my site, post suspension I downloaded a SQL and CSV version back up of the blog database. Not an xml version or anything sensible, though.
    – Nameservers on the site have now updated, so there’s no access to any of the old stuff

    Is there anyway to retrieve old posts, theme, comments etc or is it time to move on and start again?

Viewing 2 replies - 1 through 2 (of 2 total)
  • stvwlf

    (@stvwlf)

    14 years, 10 months ago

    As long as you have an old database you can retrieve your old content. Make sure the database wasn’t contaminated during the hacking. Your host might have a backup from before the hack.

    Have you seen this? http://codex.ww.wp.xz.cn/Moving_WordPress
    That is where to start.

    An important issue is the entire old domain with its subdomain is embedded hundreds of times in the old database dump. Those have to be updated to the new domain, either through editing the dump file, or using SQL queries on the database once the database is restored.

    Thread Starter loveitloveitloveit

    (@loveitloveitloveit)

    14 years, 10 months ago

    Many thanks for your help Stvwlf, I’ll check the link.

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Installing WP on new domain using SQL or CSV’ is closed to new replies.

Tags