WordPress.org

Ready to get started?Download WordPress

Forums

[resolved] wordpress migration Did not Work - please help (10 posts)

  1. Alegria de Mundo
    Member
    Posted 2 years ago #

    Hello!

    I needed to move my wordpress site onto a new domain with new hosting this is what I did.

    1. I created a database in the new hosting & imported the .sql file I'd exported from my old hosting.
    2. I downlaoded via ftp all the site files.
    3. I edited the config file with the new database name, username & password.
    4. I ftp'd all the site files ( with edited config file) to new server
    5. I went in to phpMyAdmin on my new hosting & edited the 'home' & 'url' fields in the wp_options section of the database.

    Is there anything I am missing?

    This is the URL of the new site
    http://www.brazilianentertainment.com.au

    Any advice would be greatly appreciated!

    Thanks,
    Greer

  2. esmi
    Theme Diva & Forum Moderator
    Posted 2 years ago #

  3. Alegria de Mundo
    Member
    Posted 2 years ago #

    Hi Esmi , I did read that. I want the original blog to still work which is why I changed the wp-options just in the new database not in the old installation...

    From what I have described can you see what went wrong?

  4. esmi
    Theme Diva & Forum Moderator
    Posted 2 years ago #

    From what you have said, you did not follow all of the steps outlined in this Codex section.

  5. Alegria de Mundo
    Member
    Posted 2 years ago #

    No I didn't because I didn't want to risk breaking the old site & I read other instructions that said you could edit the database details in the new installation. If I updated those my MyAdmin editing the wp_options tabel is that not the same as updating thise options in the old installation & exporting it?

  6. Nikki Blight
    Member
    Posted 2 years ago #

    Did you remember to give your new mySQL user permission to access to the database when you created it?

  7. esmi
    Theme Diva & Forum Moderator
    Posted 2 years ago #

    No I didn't because I didn't want to risk breaking the old site

    *sigh* try reading the section entitled "If You Want Your Old Blog To Still Work"

  8. Alegria de Mundo
    Member
    Posted 2 years ago #

    @kionae - yes I put the new DB_User & new password from the new hosting into the wp_config file. Is that what you mean?

    @esmi - thanks I did read that but it involved breaking it then fixing it so I was looking for a solution that doesn't do that. As I said I would think updating those options in the new database set-up in my phpMyAdmin should have the same result as doing it through the old blog - I figured those instructions where written with the thought that not everyone might have access to edit their database through phpMyAdmin

  9. Nikki Blight
    Member
    Posted 2 years ago #

    No, I actually mean does the user have access to the database. When you create a new user and database, there's an intermediary step that's required to allow the new user to access the new database. Some hosts do it automatically during user/database creation, but not all of them. If you don't grant it access, the user can log in to mySQL, but cannot do anything once it's logged in.

    Depending on how your host gives you access to mySQL, you may be able to grant permissions under the Privileges tab in in phpMyAdmin, or you may have to use the host's interface.

  10. Alegria de Mundo
    Member
    Posted 2 years ago #

    Hi Kionae - yes they do have access. It was automatically created when the database was created.

    I've figured out it was a mistake in the config file though.
    So all working now.

    Thanks everyone for your advice!

Topic Closed

This topic has been closed to new replies.

About this Topic