|
|
|
|
||||
|
Welcome to the GoFuckYourself.com - Adult Webmaster Forum forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact us. |
 |
|
|||||||
| Discuss what's fucking going on, and which programs are best and worst. One-time "program" announcements from "established" webmasters are allowed. |
|
|
Thread Tools |
03-22-2007, 02:00 AM
|
#1 |
|
Confirmed User
Join Date: Jun 2004
Location: buffalo, las vegas. icq: 285808879
Posts: 4,796
|
mySql DB help please. i broke my website.
i was adding products to my massive store database (db2) using a web interface. nothing unusual in that action. in the middle of adding a product the interface times out. on refresh i get an error that says "cannot connect to DB." i check my front end which uses a different DB (db1) and that returns a database error as well. when attempting to login to my hosting companies control panel (h-sphere) the login times out. so i figured the host is having problems.
well, the next day my websites still return the same error. however, i am able to log into the control panel. currently: phpmyadmin times out when connecting to db2 but not to db1 website 2 and 1 that connect to db2 and 1 return DB errors, respectively. my test subdomain that connects to db1 returns a DB error as well. the control panels "Manage MySQL Databases" times out when connecting to db2 but not the others. somewhere (i forget) it reports that db2 size is 0. i assume it returns that value because it cannot connect to it. i was able to increase the size limit for this db but that did not solve the problem. the hosts technical support sent the issue to their "senior techs." again, i am able to browse around DB1 but the site that connect to DB1 gives a DB error. DB2 times out. any ideas on how to help? |
|
|
|
03-22-2007, 02:02 AM
|
#2 |
|
So Fucking Banned
Industry Role:
Join Date: Apr 2001
Location: N.Y. -Long Island --
Posts: 122,992
|
stupid question but dont you backup the db regularlly?
|
|
|
|
|
03-22-2007, 02:02 AM
|
#3 |
|
So Fucking Banned
Industry Role:
Join Date: Apr 2001
Location: N.Y. -Long Island --
Posts: 122,992
|
also contact your hosst yo!!!!!!
|
|
|
|
|
03-22-2007, 02:03 AM
|
#4 |
|
Moo Moo Cow
Join Date: Mar 2004
Location: Washington State
Posts: 14,748
|
edit: I have no idea what I am talking about.
|
|
|
|
|
03-22-2007, 02:05 AM
|
#5 |
|
So Fucking Banned
Industry Role:
Join Date: Apr 2001
Location: N.Y. -Long Island --
Posts: 122,992
|
forget what i posted i just woke up and still in a daze
|
|
|
|
|
03-22-2007, 02:08 AM
|
#6 | |
|
Confirmed User
Join Date: Jun 2004
Location: buffalo, las vegas. icq: 285808879
Posts: 4,796
|
Quote:
|
|
|
|
|
|
03-22-2007, 02:10 AM
|
#7 | |
|
Confirmed User
Join Date: Jun 2004
Location: buffalo, las vegas. icq: 285808879
Posts: 4,796
|
Quote:
|
|
|
|
|
|
03-22-2007, 02:23 AM
|
#8 |
|
Confirmed User
Join Date: Jan 2006
Posts: 1,080
|
im here if you need help!
 179 215 851 |
|
|
|
|
03-22-2007, 02:56 AM
|
#9 | |
|
Damn Right I Kiss Ass!
Industry Role:
Join Date: Dec 2003
Location: Cowtown, USA
Posts: 32,409
|
Quote:
Are you off your meds again? |
|
|
|
|
|
03-22-2007, 03:53 AM
|
#10 |
|
Confirmed User
Join Date: Jun 2004
Location: buffalo, las vegas. icq: 285808879
Posts: 4,796
|
anyone else care to add a reply, witty or otherwise?
|
|
|
|
|
03-22-2007, 04:20 AM
|
#11 |
|
The Dirty Frenchman
Industry Role:
Join Date: Nov 2005
Location: Lost Angeles
Posts: 8,904
|
Is this off a virtual or a dedicated machine?
|
|
|
|
|
03-22-2007, 04:21 AM
|
#12 |
|
keep walking...
Industry Role:
Join Date: Jun 2002
Posts: 7,177
|
contact your host fast
__________________
|
|
|
|
|
03-22-2007, 04:21 AM
|
#13 | |
|
Confirmed User
Join Date: Jun 2004
Location: buffalo, las vegas. icq: 285808879
Posts: 4,796
|
Quote:
|
|
|
|
|
|
03-22-2007, 04:21 AM
|
#14 |
|
Confirmed User
Join Date: May 2006
Posts: 2,640
|
what is the error message
|
|
|
|
|
03-22-2007, 04:26 AM
|
#15 | |
|
Confirmed User
Join Date: Jun 2004
Location: buffalo, las vegas. icq: 285808879
Posts: 4,796
|
Quote:
|
|
|
|
|
|
03-22-2007, 04:27 AM
|
#16 |
|
So Fucking Banned
Industry Role:
Join Date: Apr 2001
Location: N.Y. -Long Island --
Posts: 122,992
|
fuzzy try rebooting the server.... cant hurt
|
|
|
|
|
03-22-2007, 04:28 AM
|
#17 | |
|
So Fucking Banned
Industry Role:
Join Date: Apr 2001
Location: N.Y. -Long Island --
Posts: 122,992
|
 Quote:
he contqacted me but i dont have a fucking clue what to do  |
|
|
|
|
|
03-22-2007, 04:30 AM
|
#18 | |
|
Confirmed User
Join Date: Jun 2004
Location: buffalo, las vegas. icq: 285808879
Posts: 4,796
|
Quote:
ur back again you owe me 10k post count increase. it's shared hosting. |
|
|
|
|
|
03-22-2007, 04:32 AM
|
#19 |
|
Confirmed User
Join Date: Jun 2004
Location: buffalo, las vegas. icq: 285808879
Posts: 4,796
|
goodnight
i'll be back in 6 hrs or so |
|
|
|
|
03-22-2007, 05:17 AM
|
#20 |
|
Confirmed User
Join Date: May 2002
Location: European Union
Posts: 3,815
|
Do you know if MySQL is installed on the same server your websites are served from? Or in other words, if you're trying to connect to the DBs, do you look for them on "localhost" or on any other server?
I'm asking cause maybe your host is using a seperate server for all their MySQL stuff, then it could be that your only problem is that this MySQL-Server is somehow fucked up. I.e. simply down, or under heavy load, etc. |
|
|
|
|
03-22-2007, 01:18 PM
|
#21 |
|
Confirmed User
Join Date: Jun 2004
Location: buffalo, las vegas. icq: 285808879
Posts: 4,796
|
my host fixed the problem, whatever it was. this resulted in an older copy of the database being restored which is a loss of about 4 hours of work for me.
|
|
|
|
