Title: .sql-file for creating empty database Last modified: August 18, 2016 --- # .sql-file for creating empty database * Resolved [nusi](https://wordpress.org/support/users/nusi/) * (@nusi) * [18 years, 10 months ago](https://wordpress.org/support/topic/sql-file-for-creating-empty-database/) * 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) 1 [2](https://wordpress.org/support/topic/sql-file-for-creating-empty-database/page/2/?output_format=md) [→](https://wordpress.org/support/topic/sql-file-for-creating-empty-database/page/2/?output_format=md) * Moderator [Samuel Wood (Otto)](https://wordpress.org/support/users/otto42/) * (@otto42) * WordPress.org Admin * [18 years, 10 months ago](https://wordpress.org/support/topic/sql-file-for-creating-empty-database/#post-580338) * 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. * [whooami](https://wordpress.org/support/users/whooami/) * (@whooami) * [18 years, 10 months ago](https://wordpress.org/support/topic/sql-file-for-creating-empty-database/#post-580339) * …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](https://wordpress.org/support/users/nusi/) * (@nusi) * [18 years, 10 months ago](https://wordpress.org/support/topic/sql-file-for-creating-empty-database/#post-580353) * 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)](https://wordpress.org/support/users/otto42/) * (@otto42) * WordPress.org Admin * [18 years, 10 months ago](https://wordpress.org/support/topic/sql-file-for-creating-empty-database/#post-580356) * 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](https://wordpress.org/support/users/nusi/) * (@nusi) * [18 years, 10 months ago](https://wordpress.org/support/topic/sql-file-for-creating-empty-database/#post-580367) * 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)](https://wordpress.org/support/users/otto42/) * (@otto42) * WordPress.org Admin * [18 years, 10 months ago](https://wordpress.org/support/topic/sql-file-for-creating-empty-database/#post-580369) * “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](https://wordpress.org/support/users/nusi/) * (@nusi) * [18 years, 10 months ago](https://wordpress.org/support/topic/sql-file-for-creating-empty-database/#post-580382) * > 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?). * [MichaelH](https://wordpress.org/support/users/michaelh/) * (@michaelh) * [18 years, 10 months ago](https://wordpress.org/support/topic/sql-file-for-creating-empty-database/#post-580383) * Who is your host? * Thread Starter [nusi](https://wordpress.org/support/users/nusi/) * (@nusi) * [18 years, 10 months ago](https://wordpress.org/support/topic/sql-file-for-creating-empty-database/#post-580388) * [http://sonance.net](http://sonance.net) phpmyadmin running on [https://manege.sonance.net](https://manege.sonance.net) my blog address: [http://pustota.basislager.org](http://pustota.basislager.org) * [video](https://wordpress.org/support/users/video/) * (@video) * [18 years, 10 months ago](https://wordpress.org/support/topic/sql-file-for-creating-empty-database/#post-580404) * i saw the error last days too 🙁 * Thread Starter [nusi](https://wordpress.org/support/users/nusi/) * (@nusi) * [18 years, 10 months ago](https://wordpress.org/support/topic/sql-file-for-creating-empty-database/#post-580413) * 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](https://wordpress.org/support/users/nusi/) * (@nusi) * [18 years, 10 months ago](https://wordpress.org/support/topic/sql-file-for-creating-empty-database/#post-580415) * Could just anyone maybe make an sql-dump of an already installed 2.2 wordpress instance (without entries) and post it? (just a thought) * [hamus](https://wordpress.org/support/users/hamus/) * (@hamus) * [18 years, 10 months ago](https://wordpress.org/support/topic/sql-file-for-creating-empty-database/#post-580420) * 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)](https://wordpress.org/support/users/otto42/) * (@otto42) * WordPress.org Admin * [18 years, 10 months ago](https://wordpress.org/support/topic/sql-file-for-creating-empty-database/#post-580439) * 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](https://wordpress.org/support/users/nusi/) * (@nusi) * [18 years, 10 months ago](https://wordpress.org/support/topic/sql-file-for-creating-empty-database/#post-580449) * ok, I believe you. I’ll gonna contact my host’s support. thanks Viewing 15 replies - 1 through 15 (of 24 total) 1 [2](https://wordpress.org/support/topic/sql-file-for-creating-empty-database/page/2/?output_format=md) [→](https://wordpress.org/support/topic/sql-file-for-creating-empty-database/page/2/?output_format=md) The topic ‘.sql-file for creating empty database’ is closed to new replies. * In: [Installing WordPress](https://wordpress.org/support/forum/installation/) * 24 replies * 8 participants * Last reply from: [nusi](https://wordpress.org/support/users/nusi/) * Last activity: [18 years, 9 months ago](https://wordpress.org/support/topic/sql-file-for-creating-empty-database/page/2/#post-580585) * Status: resolved ## Topics ### Topics with no replies ### Non-support topics ### Resolved topics ### Unresolved topics ### All topics