Cannot access wordpress after using sql back up file

  • Resolved absolutenewbie

    (@absolutenewbie)


    4 years, 1 month ago

    I had to copy back up folder from my sql as it kept crashing and said was full. After copying back up file over it connected but now when I try to access wordpress I get a screen asking me to selecet language. When do teh following screen is asking me to install wordpress. Though its states Username : User(s) already exist. When I go to my PHPadmin I can see my wordpress database. How I can I access it without re installing? It recognises I have a usernae but wont take me to teh dashboard. Help!

Viewing 11 replies - 1 through 11 (of 11 total)
  • Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    The DB you restored has a different table prefix. Check wp-config.php and set the $table_prefix variable to match what’s in the DB you restored.

    Thread Starter absolutenewbie

    (@absolutenewbie)

    Hi, thanks for this. IM a complete newbie to this and this is my first wordpress site. I saw that there were two wp_configs, one was a sample and one normal, I deleted the sample one and left the one with my username and password etc… is this correct? I can see te table prefix here, where is the location that I want to match it to? Sorry Im totally new to this.

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    What do the tables in your MySQL database start with?

    Thread Starter absolutenewbie

    (@absolutenewbie)

    Can you dumb this down for me. Where do I need to look? Here? C:\xampp\mysql\data\mysql or where?

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    Look at the tables via PHPMYADMIN. What do all of the tables start with? wp_? something else?

    Thread Starter absolutenewbie

    (@absolutenewbie)

    They all start with wp_

    Thread Starter absolutenewbie

    (@absolutenewbie)

    Sorry I was looking at my databse. THe tables in slq dont have a prefix it seems. They just say “Pluggins” “DB” nothing in front of them under my SLQ… is this wrong? Can I fix it?

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    Then that should be the value of the variable $table_prefix in your wp-config.php file.

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    do not look at the files in /var/lib/mysql (or wherever).

    Thread Starter absolutenewbie

    (@absolutenewbie)

    so as the tables in my sql have no prefixes I should change $table_prefix to ‘wp_’ leaving it blank? The back up version on the htdocs had ‘WP_fght’ (example only). On Myphpadmin Mywaordpressdatabase all start with ‘wp_’ but teh tables have no prefixes. Should these match? Should I put wp before everything in My sql tables?

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    Please show me a screen shot because I don’t think we’re talking on the same page.

Viewing 11 replies - 1 through 11 (of 11 total)
  • The topic ‘Cannot access wordpress after using sql back up file’ is closed to new replies.