User Name
Password
AppleNova Forums » Programmer's Nook »

MySQL database disabled, how to "restart" it?


Register Members List Calendar Search FAQ Posting Guidelines
MySQL database disabled, how to "restart" it?
Thread Tools
drewprops
Bastard
 
Join Date: May 2004
Location: Atlanta
 
2005-12-30, 23:57

I didn't want to muck up the WordPress thread with this problem because it's way too specific. I'm building a new personal website for myself using WordPress and tonight my MySQL database started acting wonky, tossing up a line errorcodes (always showing "Errorcode: 28"). At first the errorcodes were intermittent, occasionally the data would load and the posts (all TWO of my test posts) were working. I eventually logged into the MySQL admin panel with my hosting company and see that the MySQL server "is not running, Please ask your administrator to start MySQL".

I'm completely unschooled with MySQL and need to know: Am I the Adminstrator?

I see that the PMA Database is... not OK, and that "The additional Features for working with linked Tables have been deactivated." If I am in fact the one to "reactivate" these additional features is there something I have to do? Before I go any farther with WordPress (1.5.x) I need to know if this is something that I've caused to happen. For the last 10 days I have not made ANY changes to the two posts in this test site, I've only been working with templates, XHTML and CSS, crafting the site to my needs. Everything has been running like a peach until tonight.

So tonight I've been integrating my own home-brewed photo album into the test site with much good luck. The photo album doesn't write anything, it doesn't even TOUCH the MySQL database because I've written it to just read old-fashioned tab-delimited text-only "control" files that I've made by hand.

Here is the entire text of the error message:
Code:
WordPress database error: [Can't create/write to file '/tmp/#sqlb3a_35a67d_0.MYI' (Errcode: 28)] SELECT DISTINCT * FROM wp_posts WHERE 1=1 AND post_date_gmt <= '2005-12-31 04:31:59' AND (post_status = "publish" OR post_author = 1 AND post_status != 'draft' AND post_status != 'static') GROUP BY wp_posts.ID ORDER BY post_date DESC LIMIT 0, 10
(I'll be jiggered, the damned site just started working AGAIN).... could this mean that the host is yoinking their servers around?
Thanks to any/all who have advice on this....

Steve Jobs ate my cat's watermelon.
Captain Drew on Twitter
  quote
pmazer
Member
 
Join Date: May 2005
Location: Atlanta, GA
Send a message via AIM to pmazer  
2005-12-31, 11:07

Are you hosting this site on your own computer? If so, how did you install MySQL?

I installed it using a binary which included a prefPane for my System Preferences which allows me to stop and start it with a click of a button.
  quote
drewprops
Bastard
 
Join Date: May 2004
Location: Atlanta
 
2005-12-31, 18:45

Nope, I'm using a host with all the bells & whistles... they must've been doing some sort maintenance last night. I'll give MySQL more inspection during 2006, will brave having PHP and MySQL running locally for testing porpoises eventually... one day.

Steve Jobs ate my cat's watermelon.
Captain Drew on Twitter
  quote
pmazer
Member
 
Join Date: May 2005
Location: Atlanta, GA
Send a message via AIM to pmazer  
2005-12-31, 19:17

You can set firewalls and preferences so that MySQL and Apache aren't accessible from anything other than 127.0.0.1. This isn't 100% guaranteed secure, but it most likely is.

If it's a hosted server, you most likely cannot restart it.

Last edited by pmazer : 2005-12-31 at 19:38.
  quote
Posting Rules Navigation
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Post Reply

Forum Jump
Thread Tools
Similar Threads
Thread Thread Starter Forum Replies Last Post
Tiger Mail junk filter database Bill M Genius Bar 3 2005-12-27 14:46
Basic PHP / mySQL question Moogs Programmer's Nook 15 2005-11-19 16:56
MySQL 5.0 Install on OS X v.10.4.1- need help with socket error DogMom Genius Bar 1 2005-07-11 17:00
Microsoft Access? Messiahtosh Third-Party Products 26 2004-11-18 08:56
Anybody out there familiar with MySQL commands? LoCash General Discussion 5 2004-07-06 19:52


« Previous Thread | Next Thread »

All times are GMT -5. The time now is 03:39.


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright ©2004 - 2020, AppleNova