Probably need to DROP the database tables that still exist.
If you don’t want to DROP those tables, change the $table_prefix in wp-config.php to something different than you used the first time you installed.
Thread Starter
dobrak
(@dobrak)
Hi MichaelH
Thanks for your input.
I changed the $table_prefix from the default “wp_” to “wp_3_i_CH”. And this didn’t help.
I also tried it with different “DB_NAME” and also with the default “WORDPRESS”. But it didn’t help.
DROP the database tables? You mean ALL? With ALL other databases? Ouch!!!
Or do you know: Does there exist a command to reorganize a MySQL database. A command that eliminates all unused entries? Could it be this?
Thanks for you help.
I changed the $table_prefix from the default “wp_” to “wp_3_i_CH”. And this didn’t help.
Keep is simple and try something like wp1_
Don’t change anything else (if you changed the DB_NAME then change it back to what it was) and see if you are prompted to set-up your blog again.
Thread Starter
dobrak
(@dobrak)
Hi figaro
Thanks for your input.
So I changed $table_prefix from “wp_3_i_CH” to something simple “wp3_”. and I kept the DB_NAME at “wordpress”.
Still no result.
I get the message:
“We were able to connect to the database server (which means your username and password is okay) but not able to select the wordpress database.”
Maybe it works, when I create the database tables by manually. Has somebody an idea how the tables have to look like, or a script I can use for create them automatically.
Thanks in advance for inputs.
DB_NAME at “wordpress”
Are you certain the db name is wordpress? Most shared hosts will require that your account name be appended to the db name…same with db username. Are you sure you didn’t change that db name at some point?
Thread Starter
dobrak
(@dobrak)
Hello Figaro
You are making me thinking… I’m pretty sure that the name DB_NAME was “wordpress”, but I can’t guaranty it. (Is it case sensitive???)
The server is not a problem. It’s my own, and I’m running an XAMPP under Windows 2000 on it. (I know, strange combination, but it works since years – never touch a running system.)
BTW: Shared hosts … I’m running two different domains on my server. May this have an influence?
But as much as I remember, when I deleted the database with MySQL-Front, it was the “WordPress” database. And all other database in this MySQL are still alive and running.
Thanks for your efforts.
Well, okay, if you are running XAMPP then just go to phpMyAdmin and see what the database name is. If it’s wordpress then that’s good. Your db user will be root and the db user password should be left blank — unless you set-up one?
Also, make sure you have started both Apache and MySql
Thread Starter
dobrak
(@dobrak)
Hi Figaro
Thanks for your help.
Well … Apache is running and MySQL too.
Here you can see it (this is my second domain):
http://www.ultronicamerica.com/catalog/
With phpMyAdmin is nothing visible anymore, because with MySQL-Front I removed the database (wordpress) from MySQL.
There is simply nothing visible anymore with with no tool – and this makes me so crazy.
I don’t know if you are familiar with MySQL-Front. It’s a GUI for MySQL, and therefore pretty might. (probably far too mighty for me).
http://www.mysqlfront.de/ (in English)
So what have I done? I’m not so sure anymore.
I’m not familiar with MySql-Front, but I assume it’s just another MySql manager similar to phpMyAdmin and Navicat.
If you don’t see your database in XAMPP through phpMyAdmin, then maybe you deleted it through MySql-Front.
Thread Starter
dobrak
(@dobrak)
Hello Figaro
Yes, you are absolutely right. I deleted the database with the function “Remove” from the Database menu. This is correct.
There is nothing anymore that phpMyAdmin is seeing.
And this is what gives me an headache!!! I removed it, and when I try to install WordPress again, it’s telling me that it’s still there. But where???
Here is the link to my want-to-be blog.
http://www. cavallar.ch/inside_ch/wp-admin/install.php
(I put a “blank” between www. and the rest for tracking security reasons. I don’t need Google yet there. You understand for sure.
How can something that is deleted still have influence. (Oh, I also booted the server in the meantime. So it shouldn’t be the Cache).
Thanks for your patience and your help.
I don’t know, but you’ve got to have a database. So have you recreated one and entered the informaiton in the wp-config.php file?
Thread Starter
dobrak
(@dobrak)
Are you having the tables – or a script – or a link where I could find them.
I already thought about manually building up the database again, but when one has no ideas how.
Or … are there in the whole installation somewhere scripts that I could use manually in MySQL?
XAMPP comes with phpMyAdmin installed…you should be able to create your database using that.
Thread Starter
dobrak
(@dobrak)
Creating the database is not the thing. But what to write in?