WordPress.org

Ready to get started?Download WordPress

Forums

Pots/Pages not showing up after site re-install (8 posts)

  1. tribeka
    Member
    Posted 11 months ago #

    Hi there

    I have just reuploaded a wordpress site that had been archived for a year, http://www.sdaconsultants.co.uk.

    I've created a new database and reuploaded the sql file (which shows 11 tables in phpMyadmin) to this database. However, none of my posts/pages are showing up despite the sql file showing tables and content. Furthermore, when I look at the database, the size is shown as 0MB.

    I notice that for some reason, the tables have names like 'wp_mypageoptions' rather than the 'wp_options' that I'm used to seeing - don't know if this could have something to do with it?

    Would be very grateful for any help you could provide.

    Cheers

    James

  2. RobinInTexas
    Member
    Posted 11 months ago #

    It would appear that what you uploaded did not go to the database being used by the blog at http://www.sdaconsultants.co.uk.

    A database the size of 0mb would at best send you to the /wp-admin/install.php

    check to see that wp-config.php is configured to use the same database that you are uploading to.

  3. tribeka
    Member
    Posted 11 months ago #

    Hi Robin

    Thanks so much for your quick response. I've double checked the config file and it matches the dbname and db username and passwords I set up.

    When I first uploaded it all, I was sent to an install page.

    Any other thoughts?

    Many thanks

    James

  4. tribeka
    Member
    Posted 11 months ago #

    UPDATE...

    Ok, so I've tried uploading an sql file from another site and it loads the pages/posts fine so the problem must be with my sql file.

    I archived the site in the first place because it had been hacked tho' I thought the sql file had been spared - I've cleaned up the rest of the site.

    Does anyone know how I would go about cleaning up a hacked sql file?

    I've uploaded it to the address below if there are any sql whizzes feeling generous - I'm not really sure what to look for.

    [Link to hacked .sql file removed]

    Many thanks

    James

  5. esmi
    Theme Diva & Forum Moderator
    Posted 11 months ago #

    Does anyone know how I would go about cleaning up a hacked sql file?

    Very slowly and manually - checking every entry, I'm afraid. There are no shortcuts that I know of.

  6. tribeka
    Member
    Posted 11 months ago #

    Thanks for your sobering advice, Esmi. Do you know what I would be looking for?

  7. esmi
    Theme Diva & Forum Moderator
    Posted 11 months ago #

    Sorry but no. It could be almost anything. There's no way to determine what a hacker might have added, I'm afraid. I'd suggest working on a copy of the .sql file and editing anything in the wp_posts table that looks suspicious.

  8. RobinInTexas
    Member
    Posted 11 months ago #

    Wordfence will scan the site and report what it finds. It often finds links on my sites to url's to reported bad sites in links in post comments . (the comments aren't live tho :)
    If you install that and run the scan it might give you a place to focus your search.
    You probably don't need the paid option, but go through the settings because the default doesn't have everything that you probably want scanned selected.

Reply

You must log in to post.

About this Topic