Accidentally Deleted MYSQL Database. I have full site backup downloaded in my pc

look out for mysql backup file and reupload it. might have to recreate database via cpanel and then import file via import feature in phpmyadmin

i created a sql database with the same name as it was before. i imported the file using phpmyadmin but still same error.

you need to give user permissions to database. check under mysql database page. (check in wp-config.php what user was having acess to your database earlier)

i have created a MYSQL user with same username and password as it was before. What else i have to do? How i give permissions to database..please elaborate. Im noob in all this ??

you have to go into the php for the data base and find where your user name and password are in the file and change it to the correct one

– Check the error logs on your server for a more specific error message and see why it’s failing. If you need help locating them, ask your hosting provider to help you with that.

In the error log it is showing “[Thu Jun 18 16:48:37.149607 2015] [core:crit] [pid 170847] (13)Permission denied: [client 180.215.197.251:8291] AH00529: /home/ditmotor/public_html/.htpasswds/.htaccess pcfg_openfile: unable to check htaccess file, ensure it is readable and that ‘/home/ditmotor/public_html/.htpasswds/’ is executable”

unable to check htaccess file, ensure it is readable and that ‘/home/ditmotor/public_html/.htpasswds/’ is executable”

– Is it?
– Have you discussed this with your hosting provider?

yes it is readable and also .htpasswds is executable
Yes, they are saying that this is issue with your uploaded website nt from their side. They r saying to erase all data and reinstall wordpress..i cant do that ??

you can check you wp-config.php if the following constants are defined correctly as per your imported database or not
define(‘DB_NAME’, ‘database-name’),define(‘DB_USER’, ‘username’),define(‘DB_PASSWORD’, ‘password’),define(‘DB_HOST’, ‘mysqlhost’)