Support » Installing WordPress » wordpress migration Did not Work – please help

  • Resolved Alegria de Mundo

    (@alegria-de-mundo)


    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

Viewing 9 replies - 1 through 9 (of 9 total)
  • esmi

    (@esmi)

    Forum Moderator

    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?

    esmi

    (@esmi)

    Forum Moderator

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

    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?

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

    esmi

    (@esmi)

    Forum Moderator

    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”

    @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

    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.

    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!

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘wordpress migration Did not Work – please help’ is closed to new replies.