7 {{ upvoteCount | shortNum }}
7 {{ upvoteCount | shortNum }}

Wordpress Help - Problems after transfering to new Host

by kuma1234
6 replies
I changed my Hosting to Hostgator. Managed to move my WP Blog over using a guide that I found online [Googled it]. All was going well until I tried to upload the Database into Hostgator. In Hostgator, the Username has a limit to the number of characters that can be used. That caused a problem, but I fixed it by changing the name in the old SQL and Config files to match the shorten name as set in Gator.

So when I uploaded it, there were some errors, but the Blog was up and running and I lost 4 recent posts. Thought thats OK, I could always re-post them as I still had the text files and images.

Now I discovered a major challenge....I cant LOG IN! to my wp-admin....it doesn't accept the Username and Password that was set when I created the Blog....which means I cant get in at all.

What do I do?....Does it look like it's a goner?
#host #problem #transfered #wordpress
  • Profile picture of the author The Pension Guy
    If you are familiar with phpMyadmin, login to your DB, find the wp_users table, then browse it to see the users. If it's only you, most likely you will see one user - "admin".
    Click on the pencil to edit it; the username should be left as it is and edit the password. After editing it, make sure you select MD5 from the dropdown.
    Save it.

    A more detailed description (as always) with images in the Wp Codex:
    Resetting Your Password WordPress Codex
    Signature

    {{ DiscussionBoard.errors[1003132].message }}
  • Profile picture of the author Peter Adamson
    Don't panic. Using phpMyAdmin, log into your mysql database and find the database called wordpress (surprisingly enough).

    In the database called wordpress find the table called wp_users.

    Edit the row with the user name admin. Be sure to make a copy of the fields before you modify them. You need to change the password for admin. But it is encrypted so you can't just type in your new password.

    Next to the field in the edit mode there is a popup menu under the title 'Function'. Choose the function 'PASSWORD'. This will cause whatever you type in to be encrypted using the mysql password encryption feature. Change the password to something short. Save then try to log in as as admin.

    If this does not work, set things back the way they were, and do some more research or come back here.
    Signature
    Could You Be Squeezing More Sales Out Of Your Traffic ?
    Free Report
    {{ DiscussionBoard.errors[1003150].message }}
    • Profile picture of the author kuma1234
      Thanks guys....BUT now I know why that happened.

      I had errors when I tried to upload the Database, so much so that only 5 files uploaded [ I notice my other Blogs have 10]. wp_users is not there.

      When I noticed this, I tried uploading it again, same result. I even tried downloading it again from previous hosting and re-uploading it. That didn't work either.
      {{ DiscussionBoard.errors[1003241].message }}
  • Profile picture of the author The Pension Guy
    Are you sure the database wasn't already corrupted at the original site?
    Does it have there all the 10 tables (minimum)?

    If so, you may want to take a look at your export/backup procedure. You should export all tables and structure, preferably as a file - make sure all those options are checked.
    Signature

    {{ DiscussionBoard.errors[1003387].message }}
    • Profile picture of the author kuma1234
      Originally Posted by The Pension Guy View Post

      Are you sure the database wasn't already corrupted at the original site?
      Does it have there all the 10 tables (minimum)?

      If so, you may want to take a look at your export/backup procedure. You should export all tables and structure, preferably as a file - make sure all those options are checked.
      Thanks...got it done.

      Here's what I found....I was trying to Import the tables again into the Database which had already recorded errors. So I kept on getting the same errors.

      What I did was I emptied and dropped all tables on the new host....re-exported the old tables from the old host [just to be doubly sure,... still have a week to go] and re-imported it back again to new host.

      Now everything works and I can log in too.

      Thanks again guys...you guys and this forum is amazing. Here I was wondering if I needed to dump this whole site....and I got good advise in minutes.

      I thought this was going to be a bad day....just as I started this thread....I heard odd sounds of water gushing from the Hallway....turns out, the hosing of my aquarium filtration pump gave way. I have a partially flooded hall.....BUT finding a solution to this challenge made up for that. ):
      {{ DiscussionBoard.errors[1003584].message }}
      • Profile picture of the author The Pension Guy
        Originally Posted by kuma1234 View Post

        What I did was I emptied and dropped all tables on the new host....re-exported the old tables from the old host [just to be doubly sure,... still have a week to go] and re-imported it back again to new host.

        Now everything works and I can log in too.
        Oops, we should have made it clear that at the new location you should have dropped all the tables (keeping just the database) before trying to import the old DB. Sorry about that... for me it is such a routine procedure that I always forget some small details.

        Glad that you worked it out, finally!
        Good luck with the new host.
        Signature

        {{ DiscussionBoard.errors[1003720].message }}

Trending Topics