Jump to content

Database disappeared


Recommended Posts

Hi, my server or processwire or me cancelled database, that don't exist and my server haven't backup.

The error log is:

 

 http://www.permaculturaorganica.info/?/ Error:  Exception: SQLSTATE[HY000] [1044] Access denied for user 'casbo_RdS'@'%' to database 'casbooko1_po' (in /data/vhosts/permaculturaorganica.info/httpdocs/wire/core/ProcessWire.php line 308)

 

Is this log a log for database not found, it's correct? 

 

I was write any articles, but NOT PUBLISH, because the site haven't any grafic.

Now I go in  /site/assets/cache/ by ftp, but I don't see any file.

The address is correct for find the files cache?

Link to comment
Share on other sites

Sorry to hear that.  For the future, you may want to look at the following modules for backup:

To get a backup that will save a copy of your MySQL database:

https://modules.processwire.com/modules/process-database-backups/

To automate that process, the following module is recommended:

https://modules.processwire.com/modules/cronjob-database-backup/

Note:  There are many other useful backup modules for ProcessWire that will provide some relief in case you have a problem.

 

  • Like 2
Link to comment
Share on other sites

1 hour ago, franciccio-ITALIANO said:

Hi, my server or processwire or me cancelled database, that don't exist and my server haven't backup.

The error log is:

 


 http://www.permaculturaorganica.info/?/ Error:  Exception: SQLSTATE[HY000] [1044] Access denied for user 'casbo_RdS'@'%' to database 'casbooko1_po' (in /data/vhosts/permaculturaorganica.info/httpdocs/wire/core/ProcessWire.php line 308)

 

Is this log a log for database not found, it's correct? 

 

I was write any articles, but NOT PUBLISH, because the site haven't any grafic.

Now I go in  /site/assets/cache/ by ftp, but I don't see any file.

The address is correct for find the files cache?

I see you have added additional information.  Please check that the database listed has the correct permissions/privileges:

https://dev.mysql.com/doc/refman/5.7/en/privileges-provided.html

Your web host provider can assist you to tell whether this database still exists and provide guidance on getting things working again.  Good Luck.

  • Like 2
Link to comment
Share on other sites

8 hours ago, franciccio-ITALIANO said:

Hi, my server or processwire or me cancelled database

More likely than this, you just have one or more of...

  • wrong database name
  • wrong database username
  • wrong password for that username

...in /site/config.php

Your host should have some control panel (cPanel, Plesk, etc) where you can...

  • check the database name
  • check the database username
  • reset the password for that username

...and then update /site/config.php accordingly.

Edit: sorry, I spoke too soon. The error message for wrong db user/pass is slightly different. So it must be either wrong database name (hopefully) or no database at all (oh dear :().

P.S. I know it's not much help now but as @cstevensjr mentioned these two modules are essentials for every PW installation IMO:

  • Like 5
Link to comment
Share on other sites

Beh, in my server don't exist any DB :/ Brrrr :wacko:

Now, someone say anything about memory CACHE?

It'is a valid method for recover articles NOT PUBLISH but written?

I must install both this module or only 1, that I must to choose?

:wacko::wacko::wacko:

Link to comment
Share on other sites

Hi @franciccio-ITALIANO

You can look for cache files in 

site/assets/cache/Page

But there will be files only if your template cache is on.

About modules: 

First is to manually create DB backup, but the second one is to trigger backup creation periodically.

You can install and use only the first one. But if you want to use second, you have to install also the first, because it depends on it. 

Link to comment
Share on other sites

2 hours ago, franciccio-ITALIANO said:

You would install both.  The first module backs up your MySQL database.  The second module listed has many options  to make the backups you created with the first module automated.  That way you don't have to manually make a backup.

Link to comment
Share on other sites

On 2017-5-6 at 3:57 PM, franciccio-ITALIANO said:

Hi, my server or processwire or me cancelled database, that don't exist and my server haven't backup.

The error log is:

 


 http://www.permaculturaorganica.info/?/ Error:  Exception: SQLSTATE[HY000] [1044] Access denied for user 'casbo_RdS'@'%' to database 'casbooko1_po' (in /data/vhosts/permaculturaorganica.info/httpdocs/wire/core/ProcessWire.php line 308)

 

Is this log a log for database not found, it's correct? 

Not necessarily. I had a similar error last week. What happens in my setup is that I run my site locally, but connect to a database on a real live server, so I use an IP address rather than 'localhost'. In order to connect from my local account to a real server, I have to whitelist my home IP address in my hosting account to allow remote access to the database.

So what happened was that my ISP had changed my home IP address, the whitelist didn't match, therefore every one of my local sites gave me an error like the above. The answer was to login to my hosting control panel, add my IP address (literally looked up 'whatsmyip' in Google) to the whitelist and sites all worked straight away.

Long shot but I thought it was worth mentioning that it's not always the credentials in config.php that are the problem.

  • Like 1
Link to comment
Share on other sites

  • 2 weeks later...

What do you mean your hosters does not has your database?

What kind of provider are you using that is not doing data backup of their servers or customers data? Any decent hosting provider, even those cheap budget ones are doing daily backups. I would run away and fast from anyone company that doesn't protect its user's data. I also don't think ProcessWire deletes your database. I never heard of a software that deletes its own database. Either you deleted it by mistake from your control panel or your host did. I saw your other post where you mentioned the database is not in cPanel visible anymore. Is the MySQL user still there? If nothing is there, then indeed it would mean someone deleted your database.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...