WordPress.org

Support

Support » How-To and Troubleshooting » How to configure and install MySQL settings

How to configure and install MySQL settings

  • Josephvaneeden

    @josephvaneeden

    This is the problem.

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

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

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

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

    I asked godaddy and they have send me this.

    Browser : Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/31.0.1650.63 Safari/537.36
    Reason : 191

    What must I do with this concerning: You can get this info from your web host

    What must I insert exactly into the various spaces.

    I’m fairly new at this.

Viewing 15 replies - 1 through 15 (of 28 total)
  • J M

    @hiphopinenglish

    Are you trying to install WordPress as a new site (a fresh copy), or are you trying to transfer a site?

    Josephvaneeden

    @josephvaneeden

    I bought a sit from flippa and I must configure it and put it back into the http docs.

    But don’t know what to put in there.

    Josephvaneeden

    @josephvaneeden

    Transfer a site

    J M

    @hiphopinenglish

    If you’re transferring a site, you’ll need the database from the previous copy of the site. Try to find that.

    Some good information on moving a site can be found here: Moving WordPress.

    Josephvaneeden

    @josephvaneeden

    I got everything.
    He uploaded it and I got all the files on my PC

    J M

    @hiphopinenglish

    Yes but you still need a database to connect to. That’s where all the information for the site lives.

    Josephvaneeden

    @josephvaneeden

    I have the database files.
    I wanted to import it into the SQL but did not work. I did it when it was in a rar file and plain.

    J M

    @hiphopinenglish

    OK, I really need more details to help you. Why didn’t it work? What was the error?

    Josephvaneeden

    @josephvaneeden

    Error
    SQL query:


    — Database: value_mmix

    — ——————————————————–

    — Table structure for table wp_cntctfrm_field

    CREATE TABLE IF NOT EXISTS wp_cntctfrm_field (

    id INT( 11 ) NOT NULL AUTO_INCREMENT ,
    name CHAR( 100 ) COLLATE utf8_unicode_ci NOT NULL ,
    UNIQUE KEY id ( id )
    ) ENGINE = MYISAM DEFAULT CHARSET = utf8 COLLATE = utf8_unicode_ci AUTO_INCREMENT =14;

    MySQL said: Documentation

    #1046 – No database selected

    Josephvaneeden

    @josephvaneeden

    That was rar

    J M

    @hiphopinenglish

    Well it’s difficult to say what’s happening, I’m not an SQL expert, but are you sure you created a new database to import the old one to?

    Josephvaneeden

    @josephvaneeden

    I don’t know which one to do it in. There are 2.

    wpdb 50.62.209.12:3306 joseph_admin Webadmin Copy

    MySQL wordpress_d0 (Used by an installed web app) 50.62.209.12:3306 joseph_admin, wordpress_99

    J M

    @hiphopinenglish

    OK, you’re much better asking your webhost for support. Explain your problem clearly and in detail to them.

    I think you need to create a new database in your CPanel (on your web host’s customer area), and you should be able to import the database from the old site. When you create this database, you will use a username, password and your webhosting will tell you your MySQL hostname. This is the information you will enter into config.php.

    Josephvaneeden

    @josephvaneeden

    Thanks I will do that.

    Best Regards
    Joseph van Eeden

    Josephvaneeden

    @josephvaneeden

    Name : Joseph JG van Eeden
    Domain Name : http://googlefreesale.com
    ShopperID : 73518192
    Phone : 0722118865
    Shopper Validated : Yes
    Browser : Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/31.0.1650.63 Safari/537.36
    Reason : 191

Viewing 15 replies - 1 through 15 (of 28 total)
  • The topic ‘How to configure and install MySQL settings’ is closed to new replies.
Skip to toolbar