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)
[SOLVED] [MySQL Server] stopped failed.
-
- Starting out
- Posts: 39
- Joined: Tue Sep 16, 2008 10:29 am
- Location: Cairns
[SOLVED] [MySQL Server] stopped failed.
Last edited by stinhambo on Mon Jul 27, 2009 10:58 am, edited 2 times in total.
-
- Starting out
- Posts: 39
- Joined: Tue Sep 16, 2008 10:29 am
- Location: Cairns
Re: [HELP] [MySQL Server] stopped failed.
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?
Alternatively, is there a way to just reinstall MySQL?
- fribse
- Experience counts
- Posts: 2090
- Joined: Mon Feb 11, 2008 2:50 am
- Location: Greve, Denmark
- Contact:
Re: [HELP] [MySQL Server] stopped failed.
What happens if you go into the NAS via Putty and issue
?
Do you see any errors?
You should see two tasks if you do a
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
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
-
- Starting out
- Posts: 39
- Joined: Tue Sep 16, 2008 10:29 am
- Location: Cairns
Re: [HELP] [MySQL Server] stopped failed.
On the first one I get:
I then typed in
Followed by
and I get
Code: Select all
Shutting down MySQL/etc/init.d/mysqld.sh: line 366: kill: (1167) - No such process
............................... ERROR!
Code: Select all
/etc/init.d/mysqld.sh start
Code: Select all
ps -A | grep mysql
Code: Select all
14429 admin 500 S grep mysql
-
- Starting out
- Posts: 39
- Joined: Tue Sep 16, 2008 10:29 am
- Location: Cairns
Re: [SOLVED] [MySQL Server] stopped failed.
Thank you to Fan who remotely logged in and fixed this issue
A1 support guys!
A1 support guys!
-
- New here
- Posts: 3
- Joined: Mon Jan 04, 2010 9:02 am
Re: [SOLVED] [MySQL Server] stopped failed.
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
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
- fribse
- Experience counts
- Posts: 2090
- Joined: Mon Feb 11, 2008 2:50 am
- Location: Greve, Denmark
- Contact:
Re: [SOLVED] [MySQL Server] stopped failed.
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
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