By sijuwi on

I have gone through the normal procedure of updating from Drupal v6.3 to v6.13 on a test subdomain. Everything went well and I was able to view the site as it should be, however, it seems overnight something is deleting the database entirely. I've had discussions with my ISP and we have determined it is not their server but must be something like a sql query running at a certain time. Anyone had this experience before or know what is going on??

Thanks

⋅ Categories: Drupal 6.x

Comments

Quint’s picture

Quint commented

The DB is actually deleted? ... or the tables are deleted? ... or the data is deleted?

If you go into your account control panel is the database actually GONE?

sijuwi’s picture

sijuwi commented

Yes the database is actually gone, gone!

sijuwi’s picture

sijuwi commented

I did a test. I removed all drupal files and reimported the database via phpMyAdmin. I checked if the database was still there after the weekend and it was. This confirms that there is some sql statement or other script in the file system that is deleting the database, it appears, at a set time?

Quint’s picture

Quint commented

create a new database in cpanel with a different name
import your database into that new database name

make a different db user and password, and attach to the new db
update your settings.php

now see which one gets deleted.

have you looked at your cron table (in cpanel)?

sijuwi’s picture

sijuwi commented

Thanks. I'm trying this.

Nothing listed in the Crontab.