InnervamP
12-01-2005, 03:09 PM
Hey,
A while ago, I opened up a new website on my webhosting account that required a mysql database, but I didn't have enough, so I had to delete one, to make the new one. I closed a site anyway, so I figured I'd delete the old databases, and accidently deleted a database I still wanted to have on there. So here's where the problem comes in - I don't know how to get the database working on my site again.
The users at the forum for my webhost tried to help, and we got somewhere, but not far. Someone recommended to go to PhpMyAdmin and upload the Mysql databse backup I had, so I proceeded to do so, and got this error:
Can't connect to the database (databasename). MySQL said:
Access denied for user (database user)@'localhost' to database (database name)
So another person recommended I just create a new user, and set the settings to link the database and the user.
And that's how far we got - it's been over a month and nobody replied, heh.
Here's the error I get when I visit the webpage where the database was called (it's a blog, by the way):
Your SQL query:
SELECT * FROM b2posts WHERE post_category > 0 AND post_date <= '2005-12-01 14:56:38' ORDER BY post_date DESC LIMIT 1
MySQL said:
Table (table name) doesn't exist
Anybody have ANY idea what I can do? I'd really like to get that blog back up, heh.
Thanks a lot!
-InnervamP
A while ago, I opened up a new website on my webhosting account that required a mysql database, but I didn't have enough, so I had to delete one, to make the new one. I closed a site anyway, so I figured I'd delete the old databases, and accidently deleted a database I still wanted to have on there. So here's where the problem comes in - I don't know how to get the database working on my site again.
The users at the forum for my webhost tried to help, and we got somewhere, but not far. Someone recommended to go to PhpMyAdmin and upload the Mysql databse backup I had, so I proceeded to do so, and got this error:
Can't connect to the database (databasename). MySQL said:
Access denied for user (database user)@'localhost' to database (database name)
So another person recommended I just create a new user, and set the settings to link the database and the user.
And that's how far we got - it's been over a month and nobody replied, heh.
Here's the error I get when I visit the webpage where the database was called (it's a blog, by the way):
Your SQL query:
SELECT * FROM b2posts WHERE post_category > 0 AND post_date <= '2005-12-01 14:56:38' ORDER BY post_date DESC LIMIT 1
MySQL said:
Table (table name) doesn't exist
Anybody have ANY idea what I can do? I'd really like to get that blog back up, heh.
Thanks a lot!
-InnervamP