Drupal database deleted!

conorkirk - July 27, 2008 - 21:27

I installed drupal yesterday, and now it is telling me it can't find the database. "The mysqli error was: Unknown database 'drupal'."

I have already written some pages and polls and a blog entry, so it would be nice if I didn't have to reinstall drupal again (This would be the 2nd time :( )

oh, and the mysql database

conorkirk - July 27, 2008 - 21:32

oh, and the mysql database appears to be gone, it isn't there :(

what have you done?

petiar - July 27, 2008 - 21:44

Can you describe exactly what have you done before your database has disappeared? I just can't believe Drupal would drop your db just like that...

--
Petiar
The biggest slovak folk music magazine proudly uses Drupal
http://folk.sk

You will need to talk to

Keyz - July 27, 2008 - 21:47

You will need to talk to your web host about this. Drupal itself has no means to create or delete your actual database. So assuming it wasn't an accident on your own part, whatever happened has to be on your web host's side of things (e.g. maybe they had a disk error and had to restore from a day old backup where your database didn't yet exist, or any number of other possible technical reasons).

-- David
absolutecross.com

I am my web host. I own the

conorkirk - July 27, 2008 - 22:52

I am my web host. I own the server, and it is run out of my house :D

I suppose I will have to ask over at a MySQL forum, because *everything* on the system is fine, except for this one database going :P

EDIT: I wasn't blaming Drupal for this, but was wondering if this happened to anybody else.

No it's never happened to me

Keyz - July 27, 2008 - 23:18

No it's never happened to me in 2 or so years of constant Drupal use (hundreds of installs on a variety of systems). I've never noticed anyone mention it happening to them, but maybe someone will come along who's had this experience (though like I said, Drupal itself can only read and write to a pre-existing database, not add or delete actual databases, so it's much more likely something with mysql setup or a disk issue... if other sites on the same server are using mysql without issue though then I'm stumped).

Good luck.

-- David
absolutecross.com

I am just going to go ahead

conorkirk - July 27, 2008 - 23:33

I am just going to go ahead and reinstall drupal, then take a backup every day and if the database goes away, then restore it :/

I have another

conorkirk - July 28, 2008 - 02:00

I have another problem.

Drupal says:

"The directory sites/default is not protected from modifications and poses a security risk. You must change the directory's permissions to be non-writable. The file sites/default/settings.php is not protected from modifications and poses a security risk. You must change the file's permissions to be non-writable."

But when I make it non writable: "chmod 774 sites/default/*"

I can't access drupal, since it takes me back to the installation screen :/

Another thing is it says that GD is disabled, how does one enable it? Do you have to recompile PHP?

 
 

Drupal is a registered trademark of Dries Buytaert.