Restoring database…

  • Hi everyone,

    I am going around in circles here.
    https://www.jennifersando.com

    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 https://www.jennifersando.com/livien and the new one is just https://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!

    Jennifer

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

  • You can set yourself a new password by following this:
    https://www.tamba2.org.uk/wordpress/phpmyadmin/

    And the /livien ? Yes, you need to make 2 changes in that table, and a guide to that is here:
    https://www.tamba2.org.uk/wordpress/site-url/

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

    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

    Thread Starter jayess

    (@jayess)

    Hi!

    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?

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

    Thread Starter jayess

    (@jayess)

    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)

    Try redoing your permalinks ?

    Thread Starter jayess

    (@jayess)

    “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 ?

    Thread Starter jayess

    (@jayess)

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

    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)

    Thread Starter jayess

    (@jayess)

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

    Thread Starter jayess

    (@jayess)

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

Viewing 11 replies - 1 through 11 (of 11 total)
  • The topic ‘Restoring database…’ is closed to new replies.

Tags