[SOLVED] [MySQL Server] stopped failed.

Post your questions about Web Server usage and Apache + PHP + MySQL/SQLite web applications.
Post Reply
stinhambo
Starting out
Posts: 39
Joined: Tue Sep 16, 2008 10:29 am
Location: Cairns

[SOLVED] [MySQL Server] stopped failed.

Post by stinhambo »

I am getting this message in the logs. I typed ps in SSH to see if the service was running but I can't see it.

I'm also getting this message on the login page on PHPMyAdmin - #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)
Last edited by stinhambo on Mon Jul 27, 2009 10:58 am, edited 2 times in total.
stinhambo
Starting out
Posts: 39
Joined: Tue Sep 16, 2008 10:29 am
Location: Cairns

Re: [HELP] [MySQL Server] stopped failed.

Post by stinhambo »

I have backed up all my important data to a USB drive so will it help if I just reset the server and restored my data?

Alternatively, is there a way to just reinstall MySQL?
User avatar
fribse
Experience counts
Posts: 2090
Joined: Mon Feb 11, 2008 2:50 am
Location: Greve, Denmark
Contact:

Re: [HELP] [MySQL Server] stopped failed.

Post by fribse »

What happens if you go into the NAS via Putty and issue

Code: Select all

/etc/init.d/mysqld.sh stop
/etc/init.d/mysqld.sh start
?

Do you see any errors?

You should see two tasks if you do a

Code: Select all

ps -A | grep mysql
Best regards
Fribse

NO, RAID is NOT backup - Use RAID-Certified 24x7 drives for raid
HOWTO's:
Make automatic backup of ALL MySQL databases http://forum.qnap.com/viewtopic.php?f=32&t=15628

NAS-659 Pro II (3 GB Ram), Raid1, Survailance station, local backup destination + NAS-853A (16 GB Ram), Virtualization Station, Plex, iDrive
Network: Fritz!Box 7560 + 24p SG200 + 2x8p SG200 + 8p POE EdgeCore + 300/300 mbit Internet
stinhambo
Starting out
Posts: 39
Joined: Tue Sep 16, 2008 10:29 am
Location: Cairns

Re: [HELP] [MySQL Server] stopped failed.

Post by stinhambo »

On the first one I get:

Code: Select all

Shutting down MySQL/etc/init.d/mysqld.sh: line 366: kill: (1167) - No such process
............................... ERROR!
I then typed in

Code: Select all

/etc/init.d/mysqld.sh start
Followed by

Code: Select all

ps -A | grep mysql
and I get

Code: Select all

14429 admin       500 S   grep mysql
stinhambo
Starting out
Posts: 39
Joined: Tue Sep 16, 2008 10:29 am
Location: Cairns

Re: [SOLVED] [MySQL Server] stopped failed.

Post by stinhambo »

Thank you to Fan who remotely logged in and fixed this issue :)

A1 support guys!
mori
New here
Posts: 3
Joined: Mon Jan 04, 2010 9:02 am

Re: [SOLVED] [MySQL Server] stopped failed.

Post by mori »

Hi folks.
I've got a similar (exactly the same) problem with my new TS-210, with the latest firmware (Version 3.1.2 build 1014T).

I've tried nuking the drives and reinstalling (mirrored 2x2g).
a very non descript error, and i've put too much work into the config to reinstall again! :(

I can open up a port if someone could help me out?

Brian
User avatar
fribse
Experience counts
Posts: 2090
Joined: Mon Feb 11, 2008 2:50 am
Location: Greve, Denmark
Contact:

Re: [SOLVED] [MySQL Server] stopped failed.

Post by fribse »

Contact them via Skype or MSN, that should get you in touch with the correct person to solve this.
Best regards
Fribse

NO, RAID is NOT backup - Use RAID-Certified 24x7 drives for raid
HOWTO's:
Make automatic backup of ALL MySQL databases http://forum.qnap.com/viewtopic.php?f=32&t=15628

NAS-659 Pro II (3 GB Ram), Raid1, Survailance station, local backup destination + NAS-853A (16 GB Ram), Virtualization Station, Plex, iDrive
Network: Fritz!Box 7560 + 24p SG200 + 2x8p SG200 + 8p POE EdgeCore + 300/300 mbit Internet
Post Reply

Return to “Web Server & Applications (Apache + PHP + MySQL / SQLite)”