New York | Dave Beckerman

I just got an email from my ISP that they’re upgrading my account and one of the things they said was:

If you have any databases, they will be upgraded along with your website. During they upgrade, your existing database name and database username will change to include 14970_ before them.

For example, if you have a database “sales” it will now be “14970_sales”. If you have a username “saleslogin”, it will now be “14970_saleslogin”. All database passwords should remain the same.

If you have any applications or scripts that connect to databases, you will need to update your configuration information. This includes things such as WordPress Blogs, Bulletin Boards, Forums, etc.

——— Any wordpress gurus out there that can tell me what exactly I’ll have to reconfigure?

4 Responses Subscribe to comments


  1. Luke

    In your root directory (where Wordpress is installed) you’ll find a file called wp-config.php.
    Edit that and change the first entry
    from
    define(’DB_NAME’, ‘dbBeckerman’);
    to
    define(’DB_NAME’, ‘14970_dbBeckerman’);

    where dbBeckerman is the name of your database

    Aug 26, 2008 @ 7:44 pm


  2. Dave Beckerman

    Thanks Luke.

    Aug 26, 2008 @ 8:35 pm


  3. D. Brent Miller

    Dave, that wp-config file is the only thing I can think of that needs your attention. Everything else should work. I just upgraded my WP to 2.6.1 and it went smoothly. The “14970″ must be an ISP thing for security/ID purposes; my ISP (Network Solutions) has never done anything like this. They did upgrade the database from php 4 to php5 last spring.

    I know you made some changes recently. Is WordPress inside your main web site or a separate web site? This might need, at least, a look. Also, if you are using an ftp client, don’t forget to change that ID/password as needed. Some WP plugins might also need attention.

    Brent

    Aug 26, 2008 @ 9:34 pm


  4. Dave Beckerman

    Brent - the blog is within my website, so hopefully with your / Luke’s advice it won’t be a big deal. They also upgraded to php5 but it can be reset to php4 within the htaccess file. Well, it’s a while off so we’ll see. Oh yeah, and they also will change my db ip address so I’ll have to change that as well. The whole thing is part of a larger upgrade of some sort.

    Aug 26, 2008 @ 11:18 pm

Reply