• I have got my website http://www.tumblendry.co.uk running for over a year. The one who built it is not traceable anymore and now I have got this error: Error establishing a database connection.
    I contacted the hosting provider and they said:
    We checked the Hosting Manager and have found out that there are no databases setup on the MySQL database manager. You need to setup a database to get the website up and running. You need to login to the Hosting Manager to setup the database.

    And now?
    Is there anyone who might want to take a look?
    I have got the passwords etc.

    Thanks,

    Michael

Viewing 15 replies - 1 through 15 (of 24 total)
  • Then it might be the case, it was connected with any remote server.

    Thread Starter tumblendry

    (@tumblendry)

    And now that remote data base server is down?
    My website doesn’t use a database to store data, is it used to store wordpress related data, such as user login etc, because also /wp-admin does not work.

    Yes, WordPress have its default database to store post, pages, user etc.

    Might be the case that database is down or the user / password is not working.

    Thread Starter tumblendry

    (@tumblendry)

    I found out that when I am trying to load http://www.tumblendry.co.uk/wp-admin, it says:
    ******************************************************************

    Error establishing a database connection
    
    This either means that the username and password information in your wp-config.php file is incorrect or we can't contact the database server at 79.170.44.82. This could mean your host's database server is down.
    
        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?
    
    If you're unsure what these terms mean you should probably contact your host. If you still need help you can always visit the WordPress Support Forums.
    ****************************************************************

    The given database address: 79.170.44.82 is different from when I ping http://www.tumblendry.co.uk, which is: 176.74.26.65

    However, pinging 79.170.44.82 gives a reply. Hostname is: web82.extendcp.co.uk. Trying to load that address doesn’t give anything in my browser. Whois doesn’t give any details. However, I found out that the address belongs to a range owned by: Heart Internet Ltd, a website hosting company. So, I suspect that my developer has stopped her hosting with this provider on which apparently my database was running, shoot.

    So, did the one who built my website connect to her own wp-press database? Probably yes.

    So, I need to setup a new database environment for wordpress.

    I have no clue how to do that.

    You can create a database via your cPanel and can link this wordpress. But you will not get your old content, as that was being stored on your developer’s database.

    Thread Starter tumblendry

    (@tumblendry)

    I am logged in on c-panel.
    I can see wordpress under web application.
    Under: Files & Tables I can see 79.170.44.82 as being the address for the DB.
    How to create and setup a new one?

    I think your hosts are Crazy Domains. So…

    http://www.crazydomains.co.uk/help/creating-a-mysql-db/

    Thread Starter tumblendry

    (@tumblendry)

    That’s correct.
    I just created a new mysql db, and I am now in the process of changing the wp-config-sample.php according to https://codex.wordpress.org/Using_cPanel

    Great.

    Of course, as pointed out by @thegreyparrots, you will have a brand new WordPress database, so no content created before today will be available unless you kept regular backups.

    Thread Starter tumblendry

    (@tumblendry)

    I saw that no back-ups were configured. I only need to know what information was stored in this wp db.
    As said, my website was not using data in or from a database as far as I know. More or less static pages, however, I don’t know how wp is working and whether (static) text from the pages is stored in the database.

    Thread Starter tumblendry

    (@tumblendry)

    So, now I have updated wp-config.php and made a backup of this file before.

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

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

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

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

    Thread Starter tumblendry

    (@tumblendry)

    I am not sure what to do next, as the instructions say to upload contents of the wordpress directory either in the root or sub directory. Do I have all these content files already, or were these located on the remote server before?

    Then also, I need to run an installation script, and I don’t want to screw up things more than they currently are.

    When I load my web site, it wants to start the install script already, so, does it look like I need to build a whole new website?

    WordPress should already be present. Just run the install and then see what you’re left with. You will have to login and re-activate your original theme and plugins etc.

    Thread Starter tumblendry

    (@tumblendry)

    But will I overwrite stuff when doing so?
    Would I lose any content. Should I make a backup first of the files by downloading the whole lot via ftp or is there another method for that?

    No. You have an empty database. When you run the install, the WordPress files won’t be touched.

Viewing 15 replies - 1 through 15 (of 24 total)

The topic ‘Error establishing a database connection’ is closed to new replies.