• MrFlanders

    (@mrflanders)


    I’m moving my WP from one host to another. My old database name uses a underscore “_” but my new host does not allow that character. How can I solve this? Can I just change the name? The blog is no longer available at the old host, the MYSQL is and I have FTP access.
    Thanks! 🙂

Viewing 6 replies - 1 through 6 (of 6 total)
  • Teo

    (@zeitblog)

    1 First, backup your database.
    2 Change the name of the database from Control Panel of your hosting provider.
    3 change the name of the database in wp-config.php
    Configure:
    Database Name
    Database Username
    Database Password
    Database Host

    Thread Starter MrFlanders

    (@mrflanders)

    Ok, can you please clarify where I change – in the old or the new?
    1. I back up my old db
    2. Change the name of the new db?
    What do I do about the _ character?
    Thanks!

    David Gard

    (@duck_boy)

    Yes, change in the new database. If you are not allowed the underscore then you will have to remove it, and then change the database name in wp-config.php.

    See Moving WordPress for more on this – the very first section looks like it is relavent to you.

    Teo

    (@zeitblog)

    will you use the mysql from the old host from now on, or you want to move also the mysql to the new host?

    David Gard

    (@duck_boy)

    You have to move the MySQL to the new host. You usually have access to your database through PHPMyAdmin (most hosts use that), so you need to save your database and then import it in to your new host.

    Thread Starter MrFlanders

    (@mrflanders)

    Thanks folks, zeitblog – yeah I guess I could keep the db at the old host, since I have other stuff there.

    Sorry I’m being a bit slow here, but how do I go about the underscore thing. I don’t really have any clear view of the importance of the db-name. If I change the db name – wouldn’t that mess up my WP?

    Thanks for your time 🙂

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

The topic ‘Changing database name for host transfer’ is closed to new replies.