PDA

View Full Version : MySQL Errors! How splendid they are...


Amarach
10-26-03, 10:09 PM
Greetings,
I have noted that PowWeb has been backing up my mysql database daily and this makes me happy... but mySQL being down makes me angry. How do I restore from the powweb backup?

Also, could someone please clarify what the exact problem is? Thanks. www.drakianblade.com

tbonekkt
10-26-03, 10:13 PM
Seems as if you've used 'localhost' for your mysql server. You should use your real mysql server instead - ex. mysql03.powweb.com

bdoc
10-26-03, 10:14 PM
What is your mySQL server?

Looks like you are trying to connect to localhost instead of the mySQL server.

Amarach
10-26-03, 10:17 PM
Wow, quick responses. Thanks guys.

Well, I don't really know my server name and I've never had problems with using local host until Saturday or Friday, but I know I do connect to meteor.powweb.com. Where in the ops would I find the info, exactly?

tbonekkt
10-26-03, 10:18 PM
It'll be on the MySQL tab.

Amarach
10-26-03, 10:21 PM
mySQL

Your mySQL database AmarachsSQL is hosted on PowWeb's server meteor.powweb.com run mysqld version 4.0.12-log. Your database users and privileges are shown below. All changes are made in real time.


That's the header of my mySQL page. Followed by users/priveledges section and the backup section.

bdoc
10-26-03, 10:38 PM
In your configuration file for your site or whatever you have connecting to your database you will want to use "meteor.powweb.com" instead of "localhost".

Amarach
10-26-03, 10:56 PM
Thanks for the help, everyone. Problem fixed. I really appreciate it.

Thanks again, and feel free to visit me at Eversad.