PDA

View Full Version : is mysql on comet down?


chadbo
11-15-02, 02:42 PM
I'm getting a cannot find server message when trying to access my forum that I've been putting together. Just wondering if anyone else is having the same problem....

Starr
11-15-02, 02:54 PM
mySQL on comet seems fine at this time:

Uptime: 262735 Threads: 2 Questions: 3640009 Slow queries: 1 Opens: 23833 Flush tables: 1 Open tables: 1024 Queries per second avg: 13.854

Are you still having problems connecting to your db?

chadbo
11-15-02, 03:00 PM
Yes,
I keep getting the cannot find server error.....here's the link to my forum..it's on my only database

http://www.withhope.com/forum/phpBB2

Thanks for your help

Starr
11-15-02, 03:13 PM
I restarted mySQL on comet.

If you are still experiencing trouble, you may want to double check your code or maybe someone else could offer you some assistance.

wjstev0
11-15-02, 03:22 PM
I have someone who is trying to install a database for me on pulsar. He was using phpmyadmin on the pulsar server to install a database, but because of the size of the database dump file 10Meg it kept timing out before it could upload. So he broke it up into individual components where they were under a meg each but whenever phpAdmin attempts to use them it is giving a 500 error.

What gives? Is there a problem with the server or the a limitation on the size of the dump?

Thanks
BillStevens

RadioRob
11-17-02, 09:00 AM
Originally posted by wjstev0
I have someone who is trying to install a database for me on pulsar. He was using phpmyadmin on the pulsar server to install a database, but because of the size of the database dump file 10Meg it kept timing out before it could upload. So he broke it up into individual components where they were under a meg each but whenever phpAdmin attempts to use them it is giving a 500 error.

What gives? Is there a problem with the server or the a limitation on the size of the dump? Hi Bill!

What's happening is that scripts are automatically set to "time out" after so long of running. This is so they don't get out of control and keep running forever and crash the server. (That's for the time out problem.)

As far as a 500 error... that usually means there is a problem with the script itself. You might want to double check to make sure you have installed phpMyAdmin correctly and that you also broke down your your dump file correctly.

Good luck. :)

wjstev0
11-17-02, 01:47 PM
This is a vendor and so far this is the only server he has experience with. Is there anyway to get around the timeouts. My own experience has been less than desirable. I can't tell you the number of times I've tried to do something myself only be timed out and restart another loop. It appears to me that they are set at less than 5 minutes. By the way my biggest complaint with POWWEB. You have to experience a problem numerous times only to discover its not you but a limitation that they have set and there is no documentation anywhere or work around published anywhere. Hours of wasted time.

Enough of a vent. This database is part of a piece of program that is the only reason I moved to POWWEB. Although free did not have access to scripts and server side includes.


I've tried to use a piece of software that someone else suggested phpshell to put the database online. Well I could edit anybody's website I wanted to but couldn't find the mySQL database. So I promptly removed the script. That’s a efficient but scary program in the hands of the wrong person.

Is there a program similar to phpmyadmin that allows for batch processing?

My gut tells me this is a database with numerous tables. Given 10mb probably represents a large number of tables. Probably impractical to upload a table at a time.

The database is for Hamweather is there anyone who has installed the mySQL program?

Thanks
Bill Stevens