Getting database installed

  • Resolved rich2506

    (@rich2506)


    15 years, 6 months ago

    Migrating a WordPress blog from www.ads-software.com to a 1and1 site. Here’re my database descriptions:

    Database name db297112516
    Host name db2044.perfora.net
    Port 3306
    User name dbo297112516
    Password Xek44kkkdfs
    Description deena
    Version MySQL5.0
    Status setup started

    and here’s what I inputted into the site to import the MySQL database:

    Database Name otherjones.com/otherjones/db297112516 The name of the database you want to run WP in.
    User Name dbo297112516 Your MySQL username
    Password Xek44kkkdfs …and MySQL password.
    Database Host localhost 99% chance you won’t need to change this value.
    Table Prefix wp_ If you want to run multiple WordPress installations in a single database, change this

    I keep getting a “404” or a message saying it doesn’t recognize what I’ve put in. Seems I’m messing up the database name, but I’ve tried a few variations.

    Any ideas?

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

  • Migrating a WordPress blog from www.ads-software.com to a 1and1 site.

    Did you mean wordpress.COM to a 1and1 site?

    If yes, then use the Tools->Export and wordpress.COM and Tools->Import->WordPress at your 1and1 blog.

    If no, then I’m not clear what import you would do via WordPress with MySQL.

    Related:
    Moving WordPress

    Thread Starter rich2506

    (@rich2506)

    D’oh! Yes, of course, WordPress.com (Slapping myself on wrist). Problem is, I’m trying to get the blog on otherjones.wordpress.com moved into the webspace (provided by 1and1.com) otherjones.com as my client wants to have her blog using the shorter name and wants it to have a particular header graphic.
    And yes, if we can just get the more full-featured WordPress blog into a 1and1 webspace as opposed to the more limited WordPress blog version that 1and1 provides (And that comes strictly with a limited set of pre-designed headers), that’d be great and I could take it from there.

    1. At otherjones.wordpress.com do Tools->Export
    2. At 1and1 (where your domain is hosted), install WordPress
    3. At your newly installed blog, do Tools->Import->WordPress and use the file from Step 1.

    Thread Starter rich2506

    (@rich2506)

    The trouble I’m having is in step 2. I created a MySQL database there, then moved WordPress installation files to the site and now I’m trying to get the WordPress blog up and running. For some reason, I can’t seem to locate the files I need to activate.

    Then please review Installing WordPress.

    Thread Starter rich2506

    (@rich2506)

    Aye, thanks!

    Thread Starter rich2506

    (@rich2506)

    Okay, I entered all of the requested data into my wp-config.php file to produce the following:

    // ** MySQL settings – You can get this info from your web host ** //
    /** The name of the database for WordPress */
    define(‘DB_NAME’, ‘db297112516’);

    /** MySQL database username */
    define(‘DB_USER’, ‘dbo297112516’);

    /** MySQL database password */
    define(‘DB_PASSWORD’, ‘Xek44kkk’);

    /** 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’, ”);

    /**#@+
    * Authentication Unique Keys.
    *
    * Change these to different unique phrases!
    * You can generate these using the {@link https://api.www.ads-software.com/secret-key/1.1/ www.ads-software.com secret-key service}
    * You can change these at any point in time to invalidate all existing cookies. This will force all users to have to log in again.
    *
    * @since 2.6.0
    */
    define(‘AUTH_KEY’, ‘in rhythm & sorrow’);
    define(‘SECURE_AUTH_KEY’, ‘effing in r and s’);
    define(‘LOGGED_IN_KEY’, ‘effing in rhythm’);
    define(‘NONCE_KEY’, ‘effing in r and sorrow’);
    /**#@-*/

    Any idea why when I try to go to
    https://otherjones.com/otherjones/wp-admin/install.php
    I still can’t establish a database connection?

    At 1and1, I don’t think localhost is the name of the DB_HOST.

    You first showed “db2044.perfora.net” and that looks more correct, at least for 1and1.

    Thread Starter rich2506

    (@rich2506)

    Many thanks! That provided about 90% of the answer. The last 10% is that I got the following error messages:

    Warning: Cannot modify header information – headers already sent by (output started at /homepages/0/d296509088/htdocs/otherjones/wp-config.php:1) in /homepages/0/d296509088/htdocs/otherjones/wp-login.php on line 290

    Warning: Cannot modify header information – headers already sent by (output started at /homepages/0/d296509088/htdocs/otherjones/wp-config.php:1) in /homepages/0/d296509088/htdocs/otherjones/wp-login.php on line 302

    Warning: Cannot modify header information – headers already sent by (output started at /homepages/0/d296509088/htdocs/otherjones/wp-config.php:1) in /homepages/0/d296509088/htdocs/otherjones/wp-includes/pluggable.php on line 671

    Warning: Cannot modify header information – headers already sent by (output started at /homepages/0/d296509088/htdocs/otherjones/wp-config.php:1) in /homepages/0/d296509088/htdocs/otherjones/wp-includes/pluggable.php on line 672

    Warning: Cannot modify header information – headers already sent by (output started at /homepages/0/d296509088/htdocs/otherjones/wp-config.php:1) in /homepages/0/d296509088/htdocs/otherjones/wp-includes/pluggable.php on line 673

    Warning: Cannot modify header information – headers already sent by (output started at /homepages/0/d296509088/htdocs/otherjones/wp-config.php:1) in /homepages/0/d296509088/htdocs/otherjones/wp-includes/pluggable.php on line 865

    Thread Starter rich2506

    (@rich2506)

    Found the instruction on how to fix the problem. My word processor (Open Office) appears to indicate the problem is fixed. Someone suggested a better word processor for the task, Pyroom, but after a checking half a dozen sites, it’s still not clear where to find instructions on how to use it.
    So, here’s hoping my next message is to report success.

    Thread Starter rich2506

    (@rich2506)

    Using gedit in Ubuntu Linux and with that, took off the blank character at the end of the last line.
    Read over the document at
    https://codex.www.ads-software.com/Editing_wp-config.php
    a few times. I just can’t figure out what I’m still doing wrong.

Viewing 11 replies - 1 through 11 (of 11 total)
  • The topic ‘Getting database installed’ is closed to new replies.