Restoring database... (12 posts)

  1. jayess
    Posted 10 years ago #

    Hi everyone,

    I am going around in circles here.

    I have moved servers and created a new database. I run into two problems after trying to restore my database via PHPmyadmin.

    After I restore the database, I can no longer log into the dashboard - it tells me I have the wrong password.

    Secondly, the old wp URL was http://www.jennifersando.com/livien and the new one is just http://www.jennifersando.com - I am told I need to edit the wp options table and change the site url in there? is this correct? do i literally just the delete the "/livien" reference in the record and that's it? If I don't update the URL, when I click around on the wordpress site, it says "no input file specified"

    I have redone this so many times and am not making any progress! Somebody please help me!


  2. Mark (podz)
    Support Maven
    Posted 10 years ago #

    You can set yourself a new password by following this:

    And the /livien ? Yes, you need to make 2 changes in that table, and a guide to that is here:

    If that doesn't help at all, or seems confusing, post back ?

  3. vrada
    Posted 10 years ago #

    1. If you lost your password, just email yourself a new one with the lost password page. But you will probably have to do #2 first.

    2. Yes, delete all references for the /livien and replace with your new address.

    I assume by restore that you are:
    - Creating a new database
    - Go through the install procedure
    - Go back to phpmyadmin and delete your wp tables
    - Open you old sql file
    - Replace the directory, and rename the database name to the new database
    - Upload the recomposed sql file to your new database

  4. jayess
    Posted 10 years ago #


    I have messed around - changed the URL - and I can log in OK to the dashoard - but now the site is completely blank...

    Is it because I haven't uploaded my old theme files?

  5. Mark (podz)
    Support Maven
    Posted 10 years ago #

    The lack of a theme, or a damaged theme does cause blankness, yes.

  6. jayess
    Posted 10 years ago #

    OK... now I have something coming up. But I am back to where I started where if I click on anything - it says "no input file specified" (thanks for your help so far)

  7. Mark (podz)
    Support Maven
    Posted 10 years ago #

    Try redoing your permalinks ?

  8. jayess
    Posted 10 years ago #

    "Click on anything" meaning any of the links (archives etc) within the site...

    To answer Vrada's questions:
    I created a new database
    went through install procedure
    deleted wp tables
    *not sure what you mean by "replace the directory and rename database name to the new database..."

    well, the new database name is not the same as the old one... perhaps this is where I am going wrong? but then the content wouldn't load at all if that is the case ?

  9. jayess
    Posted 10 years ago #

    Do I redo the permalinks by just updating the structure in dashboard? Sorry - not sure how?

  10. Mark (podz)
    Support Maven
    Posted 10 years ago #

    The database and the connection to it are fine, otherwise as you say it just wouldn't work.

    I would try this:
    Go to Options > permalinks
    If there is anything in the 'Structure' box, empty it.
    Click Update
    Then put your desired structure in that box
    Click Update
    Then depending on whether wp can write to the .htaccess this part of the troubleshooting will be done.

    (Before you do this, ensure you have a .htaccess and that it's file permissions are 666)

  11. jayess
    Posted 10 years ago #

    Hmmh, then I think I have to create my own .htaccess file cause I can't see one at present...

  12. jayess
    Posted 10 years ago #

    OK I am just seeing if it is hidden in my ftp client

Topic Closed

This topic has been closed to new replies.

About this Topic