• Excuse me if there is a post on this, i couldnt find it. I guess its pretty basic stuff, but i thought id ask here first.

    Trying to move my wordpress blog to a new host. Backed up up the public_html folder and copied it to the new host, same directory. Restored the database using the restore option in the backup wizard on the new host’s cpanel.

    error

    Are you sure you have the correct username and password?
    Are you sure that you have typed the correct hostname?
    Are you sure that the database server is running?

    I guess there is a possibilty of username/password confict, among other things 🙂

    Any pointers appreciated

    thnx

Viewing 12 replies - 1 through 12 (of 12 total)
  • Did you change wp-config.php to define the new DB_HOST?

    Read this about moving WordPress to a new server.

    Thread Starter zooph

    (@zooph)

    buddha

    thnxx for your sw!ft reply…

    well, the hosting requires DB_HOST to be set to localhost.

    is that what your getting at?

    z

    The settings of the previous and current host may be different. Just make sure that wp-config.php has been changed accordingly so the path is to the new database.

    Is this something you have done already?

    Thread Starter zooph

    (@zooph)

    thanks again,

    im not sure where to check what that path might be?

    Thread Starter zooph

    (@zooph)

    well i looked up on cpanel and the database prefix is different so i changed that in the wp-config.php and still problems – what about the password? Thats from the old host config. Surely that will prevent a database connection?

    thnx
    p

    You have to make sure these settings in wp-config.php, take you to the new database

    // ** MySQL settings ** //
    define('DB_NAME', 'name of the database');    // The name of the database
    define('DB_USER', 'your username');     // Your MySQL username
    define('DB_PASSWORD', 'your password'); // ...and password
    define('DB_HOST', 'localhost, or the host name as defined by your server');    // 99% chance you won't need to change this value
    define('DB_CHARSET', 'utf8');
    define('DB_COLLATE', '');

    Did you also check the link I gave you about moving WP to a new server? Some good info may be there too.

    Thread Starter zooph

    (@zooph)

    hmmm . My wordpress installation is from 2004. The wp-config i have is much slimer.


    <?php
    // ** MySQL settings ** //
    define('DB_NAME', 'something'); // The name of the database
    define('DB_USER', 'something'); // Your MySQL username
    define('DB_PASSWORD', 'something'); // ...and password
    define('DB_HOST', 'localhost'); // 99% chance you won't need to change this value

    // Change the prefix if you want to have multiple blogs in a single database.
    $table_prefix = 'wp_'; // example: 'wp_' or 'b2' or 'mylogin_'

    // Change this to localize WordPress. A corresponding MO file for the
    // chosen language must be installed to wp-includes/languages.
    // For example, install de.mo to wp-includes/languages and set WPLANG to 'de'
    // to enable German language support.
    define ('WPLANG', '');

    /* Stop editing */

    define('ABSPATH', dirname(__FILE__).'/');
    require_once(ABSPATH.'wp-settings.php');
    ?>

    Could it be the old password thats casuing problem?

    zooph,

    instead of ‘something’, the actual settings you put there must match the new database.

    How did you set up the new database at the new host? Did you use same name and same password as the other host?

    Did the old host also require ‘localhost’, or was the path different?

    And so on.

    Did you read the tutorial I mentioned before about moving WordPress to a new server? Make sure you do. All the needed steps are there, you have to make sure you followed the correct steps.

    Thread Starter zooph

    (@zooph)

    thanks buddha trance,

    yeah, actually the settings for ‘something’ are real data:

    <?php
    // ** MySQL settings ** //
    define(‘DB_NAME’, ‘paulprud_wrdp1’); // The name of the database
    define(‘DB_USER’, ‘paulprud_wrdp1’); // Your MySQL username
    define(‘DB_PASSWORD’, ‘T5yTqiGgWYnN’); // …and password
    define(‘DB_HOST’, ‘localhost’); // 99% chance you won’t need to change this value

    When i restored the database on the new server it changed the name to ‘paulprud_wrdp1’ so i added that to the config file.

    How do i know the password is right? It’s from the old host setting so i assume its wrong? I have indeed read the page on ‘moving to a new server’ but it doesnt explain what you actually need to edit in the wp-config file in detail. How can i find out this information?

    Many thanks again…

    zooph, edit your post right away and take off your real database details! No one should know them.

    database name and user are the same? hmmm

    If you don’t have access to the info on how you configured the new database, can you call your host and ask them?

    Either you did it yourself, and then you know what you used as username and database name, and password, or it happened automatically and your host knows.

    Then you can put the right info in wp-config.php

    Thread Starter zooph

    (@zooph)

    buddha,

    well i would edit it but i can’t find where. Usually a recent post has an edit link next to the post. Im logged in and cant find it.

    Thats why i put ‘something’ in in the first place 😉

    my previous wp-config that worked was

    define(‘DB_NAME’, ‘something_wrdp1’); // The name of the database
    define(‘DB_USER’, ‘something_wrdp1’); // Your MySQL username

    so i just changed to the new database name…

    Ill go hunting for that info from my host!

Viewing 12 replies - 1 through 12 (of 12 total)
  • The topic ‘Moving WordPress to a new host’ is closed to new replies.