• I have a WordPress site on a server that I want to move to a Yahoo Small Business server. I also want to change the url of this site. It’s not working. Here’s what I’ve done…

    I backed up the current site into a desktop folder doing the following:
    • Using the WordPress Database Backup plugin I made a copy of the database.
    • Using Filezilla I copied the wp-content folder, the wp-config.php file, and the .htaccess file into this folder as well.

    At Yahoo I used the one step install to create a new, virgin WordPress site.

    Using phpMyAdmin I imported the current site database to the new WordPress site.
    Using Filezilla I moved the current site wp-content folder and wp-config.php file to the new site. It would not let me move the .htaccess file.

    When I try to access the site I get the ‘Error establishing a database connection’ message.

    Does anyone have any suggestions, or have a website that deals with this topic? I didn’t delete anything from the new site – should I have? Should I create a new site on Yahoo without any WordPress files and move all the files and folders from the current site into this? Or is everything I’m doing wrong?

    If I use dreamweaver to look at wp-config file I see something like what’s below (not real data). What do I need to change here? Thanks for any help!

    /** The name of the database for WordPress */
    define(‘DB_NAME’, ‘euirunbpy_wordpress6’);

    /** MySQL database username */
    define(‘DB_USER’, [redacted]);

    /** MySQL database password */
    define(‘DB_PASSWORD’, [redacted]);

    /** MySQL hostname */
    define(‘DB_HOST’, ‘localhost’);

    /** Database Charset to use in creating database tables. */
    define(‘DB_CHARSET’, ‘utf8’);

    /** The Database Collate type. Don’t change this if in doubt. */
    define(‘DB_COLLATE’, ”);

Viewing 4 replies - 1 through 4 (of 4 total)
  • Moderator t-p

    (@t-p)

    Moving:

    – review this codex: http://codex.wordpress.org/Moving_WordPress

    ‘Error establishing a database connection’:

    – If you get a page featuring the message “Error Establishing Database Connection,” this means that there is a problem with the connection to your database and there could be a number of reasons for this. The following codex lists possible reasons and solutions:
    http://codex.wordpress.org/Common_WordPress_Errors#Error_Establishing_Database_Connection

    Change your database username and password NOW! And never, ever, post sensitive information on a public forum like that again.

    Thread Starter 4duckisland

    (@4duckisland)

    Esmi: thanks for the warning, but none of the db or password info I posted was real – I’m not that naive!

    But it looks like I might have found a possible answer to my issue. Yahoo Small Business doesn’t allow you to update .htaccess files. If this is so, doesn’t that prevent me from moving a WordPress site from another server to Yahoo?

    It doesn’t prevent you from moving it, but id does prevent you form using pretty permalinks for URL’s. Without the .htaccess file you have to use the standard permalink structure of ?p=123.

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

The topic ‘Problems Migrating to New Server’ is closed to new replies.