• Resolved nusi

    (@nusi)


    hi,

    just trying to get the recent wp-version running, i’ve edited wp-config as explaned in the readme. I think I’ve done it correctly (as the database is running on localhost). Though I think the installation has a problem because I have got to use an existing (though empty) database as I guess wp is trying to set up a new db?
    I’ve looked for an sql-file, which would have allowed me to do the setup manually, but it doesn’t seem to exist, neither as a file within the installation-download, nor here on the wp-server.

    anyone had the same problem?

    tanks for hints, stefan

Viewing 15 replies - 1 through 15 (of 24 total)
  • Moderator Samuel Wood (Otto)

    (@otto42)

    WordPress.org Admin

    The WordPress installation expects there to be an existing database already there. When you run the install, it creates the tables and such. It does not create a new database by itself.

    …as I guess wp is trying to set up a new db?

    Nope.

    WordPress tries to create tables inside a database; said database does not need to be empty.

    Thread Starter nusi

    (@nusi)

    hmm … ok. Nevertheless: what can I do? Can I set up the table-structure manually? I haven’t found any .sql that I could use …
    wp-config.php doesn’t leave many options to be done wrong. So I think I’ve provided the right params. An automatic setup is comfortable, but only if it works (may be my fault for sure).

    Moderator Samuel Wood (Otto)

    (@otto42)

    WordPress.org Admin

    Well, the first thing to do would be for you to actually tell us what the error you’re getting is, so that we can offer advice.

    Thread Starter nusi

    (@nusi)

    well:

    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 localhost. This could mean your host’s database server is down.

    well, I know already. Server’s not down, user/password should be correct. ‘Localhost’ should be alright.

    * 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.

    well, here I am.

    Moderator Samuel Wood (Otto)

    (@otto42)

    WordPress.org Admin

    “Error establishing a database connection” means that some information in wp-config.php is wrong or the mySQL server is not accessible. Period.

    Sorry, but this is not an SQL issue or any other kind of setup issue. You either have the wrong information in the file or the server is not accessible for some other reason.

    The error means that it cannot connect to the mySQL server. Manually creating the tables won’t help, because if it can’t connect, then it can’t connect whether the tables are already there or not.

    Also, how sure are you that “localhost” is correct? Is this running on a server you actually control? Most hosts do not run mySQL instances on the same boxes as their webservers, so “localhost” is usually incorrect.

    Thread Starter nusi

    (@nusi)

    Also, how sure are you that “localhost” is correct? Is this running on a server you actually control? Most hosts do not run mySQL instances on the same boxes as their webservers, so “localhost” is usually incorrect.

    That sound’s worth being considered (though wp-config says something different).

    Think I’m gonna try asking my provider’s support. Anyway it would maybe be useful to be able to turn on some debugging output (mysql error-codes?).

    Who is your host?

    Thread Starter nusi

    (@nusi)

    i saw the error last days too πŸ™

    Thread Starter nusi

    (@nusi)

    a bug? Could be that my settings are wrong, but are there others having the same troubles? (why can’t I just set up my mysql-tables by hand e.g. by using an .sql-file …)

    Thread Starter nusi

    (@nusi)

    Could just anyone maybe make an sql-dump of an already installed 2.2 wordpress instance (without entries) and post it? (just a thought)

    Me too – exactly as above. I don’t think I understand the full signifigance of “localhost”. I’m using lowesthosting.com
    Can someone give me a pointer? Thanks.

    Moderator Samuel Wood (Otto)

    (@otto42)

    WordPress.org Admin

    Sorry guys, but this is not a bug. It’s just not. Things do not work that way. This is a misconfiguration.

    Like I said, you either have the wrong information in wp-config.php (most likely) or your database server is down (not as likely).

    There really is no other possibility here.

    Now, “localhost” is the name of the server where your mySQL instance is. And yes, despite what it says in the wp-config.php file, it’s probably *not* localhost. It will be the name of the mySQL server. Like mysql5.yourhost.com or something like that.

    nusi: You could set up the tables by hand, if you liked, but your site would still not actually work. The PHP must connect to the database to generate the webpages. If it’s not connecting, then it’s not going to work. Simple as that.

    Thread Starter nusi

    (@nusi)

    ok, I believe you. I’ll gonna contact my host’s support. thanks

Viewing 15 replies - 1 through 15 (of 24 total)
  • The topic ‘.sql-file for creating empty database’ is closed to new replies.