BetaArchive Logo
Navigation Home Screenshots Image Uploader Server Info FTP Servers Wiki Forum RSS Feed Rules Please Donate
UP: 24d, 8h, 44m | CPU: 68% | MEM: 5934MB of 12227MB used
{The community for beta collectors}

Post new topic Reply to topic  [ 16 posts ] 
Author Message
 PostPost subject: mysql problem urgent help needed. fear for my life.        Posted: Sun Nov 11, 2007 5:43 pm 
Reply with quote
FTP Access
Offline

Joined
Wed Aug 23, 2006 2:42 pm

Posts
632

Location
c:\tmp\*

Favourite OS
Server 2003
Hi all.

got another flipping problem with my mums server, and this time i'm fearing for my life.

the mysql thing isnt working, and been trying to fix it all day.

the error it is giving is : ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

I reset permissions then found out that the "/var" partition (?) was full. I have now cleared a bit of space on it, but i can't get mysql running at all.

can someone please help? if you could sort it for me that'd be great (cash can be involved if needed)

cheers

servers running fedora core btw.


Top  Profile  WWW
 PostPost subject:        Posted: Sun Nov 11, 2007 5:49 pm 
Reply with quote
Staff
User avatar
Offline

Joined
Wed Apr 11, 2007 2:11 pm

Posts
2607

Location
Germany, Earth

Favourite OS
Windows 10
I think you only have to start the service mysqld

_________________
MS vNext: Windows 10 ESD Database - Windows 10 Build Labs - Windows 10 Update Archive - Office 2016 Version Tracker - Office Downloader


Top  Profile  WWW
 PostPost subject:        Posted: Sun Nov 11, 2007 5:51 pm 
Reply with quote
FTP Access
Offline

Joined
Wed Aug 23, 2006 2:42 pm

Posts
632

Location
c:\tmp\*

Favourite OS
Server 2003
how? lol


Top  Profile  WWW
 PostPost subject:        Posted: Sun Nov 11, 2007 5:53 pm 
Reply with quote
Staff
User avatar
Offline

Joined
Wed Apr 11, 2007 2:11 pm

Posts
2607

Location
Germany, Earth

Favourite OS
Windows 10
At etc/rc.d/init.d/ type ./mysqld start I think.

_________________
MS vNext: Windows 10 ESD Database - Windows 10 Build Labs - Windows 10 Update Archive - Office 2016 Version Tracker - Office Downloader


Top  Profile  WWW
 PostPost subject:        Posted: Sun Nov 11, 2007 5:53 pm 
Reply with quote
FTP Access
Offline

Joined
Wed Aug 23, 2006 2:42 pm

Posts
632

Location
c:\tmp\*

Favourite OS
Server 2003
just did "/sbin/service mysqld start" but it says it failed to start mysql


Top  Profile  WWW
 PostPost subject:        Posted: Sun Nov 11, 2007 5:56 pm 
Reply with quote
Staff
User avatar
Offline

Joined
Wed Apr 11, 2007 2:11 pm

Posts
2607

Location
Germany, Earth

Favourite OS
Windows 10
Have a look at this. Maybe it helps.

_________________
MS vNext: Windows 10 ESD Database - Windows 10 Build Labs - Windows 10 Update Archive - Office 2016 Version Tracker - Office Downloader


Top  Profile  WWW
 PostPost subject:        Posted: Mon Nov 12, 2007 5:56 am 
Reply with quote
FTP Access
Offline

Joined
Wed Aug 23, 2006 2:42 pm

Posts
632

Location
c:\tmp\*

Favourite OS
Server 2003
just talked to web company. parantly its because i upgraded mysql to version 5.

how do i downgrade it again?


Top  Profile  WWW
 PostPost subject:        Posted: Mon Nov 12, 2007 6:26 am 
Reply with quote
FTP Access
Offline

Joined
Wed Aug 23, 2006 2:42 pm

Posts
632

Location
c:\tmp\*

Favourite OS
Server 2003
hes sent me an sql script which he reckons will sort it out.

wtf do i do with the blooming thing? just enter it into a console?

or do i have to use some stupid thing like phpmyadmin?


Top  Profile  WWW
 PostPost subject:        Posted: Mon Nov 12, 2007 9:14 am 
Reply with quote
Donator
Offline

Joined
Sat Aug 19, 2006 1:25 am

Posts
590

Location
Israel
You pipe it into the MySQL console. For example:
Code:
cat script | mysql -u root -p

Then enter your MySQL (not system) root password.

This could be problematic, though. You have to have the MySQL daemon running for the console to work.

Basically, to downgrade something, you have to use your package manager (yum in your case) to either replace the installed version with an older one, or to completely erase the current version, then install the older one from scratch. I'm not sure whether the MySQL 5.0 storage engines convert your data to a newer, backward-incompatible format, so research a bit before you downgrade.


Top  Profile
 PostPost subject:        Posted: Mon Nov 12, 2007 3:31 pm 
Reply with quote
Administrator
User avatar
Offline

Joined
Fri Aug 18, 2006 11:47 am

Posts
12459

Location
Merseyside, United Kingdom

Favourite OS
Microsoft Windows 7 Ultimate x64
Makes me feel glad I use a Windows server :)

_________________
Image

BetaArchive Discord: https://discord.gg/epK3r6A


Top  Profile  WWW
 PostPost subject:        Posted: Mon Nov 12, 2007 4:34 pm 
Reply with quote
Donator
Offline

Joined
Sat Aug 19, 2006 1:25 am

Posts
590

Location
Israel
Andy wrote:
Makes me feel glad I use a Windows server :)

Let me see you write a one-liner to automatically turn on a backup MySQL server when one on another computer crashes. On Windows.

Hard, isn't it?

On Linux (or any other System V-based UNIX, for that matter), that would be:
Code:
while mysql -B -e ";" -h other_server; do sleep 1; done; /etc/init.d/mysql start

Took me about 40 seconds to read the MySQL help message and write this script.

EDIT: regarding my previous post on this thread (about downgrading MySQL), I dare you to uninstall DirectX 9 from Windows XP without messing with the registry or manually replacing DLLs.

EDIT2: Sorry if it sounds like I'm trying to start a flamewar. I'm not. I'm just proving my point :D


Last edited by ppc_digger on Mon Nov 12, 2007 9:37 pm, edited 1 time in total.

Top  Profile
 PostPost subject:        Posted: Mon Nov 12, 2007 4:36 pm 
Reply with quote
Administrator
User avatar
Offline

Joined
Fri Aug 18, 2006 11:47 am

Posts
12459

Location
Merseyside, United Kingdom

Favourite OS
Microsoft Windows 7 Ultimate x64
ppc_digger wrote:
Andy wrote:
Makes me feel glad I use a Windows server :)

Let me see you write a one-liner to automatically turn on a backup MySQL server when one on another computer crashes. On Windows.


On Windows I've never had to. MySQL doesn't randomly decide to crash out. It never has, and has no reason to start now.

_________________
Image

BetaArchive Discord: https://discord.gg/epK3r6A


Top  Profile  WWW
 PostPost subject:        Posted: Mon Nov 12, 2007 4:42 pm 
Reply with quote
Donator
Offline

Joined
Sat Aug 19, 2006 1:25 am

Posts
590

Location
Israel
Andy wrote:
ppc_digger wrote:
Andy wrote:
Makes me feel glad I use a Windows server :)

Let me see you write a one-liner to automatically turn on a backup MySQL server when one on another computer crashes. On Windows.


On Windows I've never had to. MySQL doesn't randomly decide to crash out. It never has, and has no reason to start now.

I didn't say MySQL crashes randomly. The original poster said it was due to an upgrade. I've been using MySQL for ages and I've never seen it crash. I meant a kernel panic, a power failure, etc.

Besides, on Windows, the whole system tends to crash for no good reason.


Top  Profile
 PostPost subject:        Posted: Mon Nov 12, 2007 4:47 pm 
Reply with quote
Administrator
User avatar
Offline

Joined
Fri Aug 18, 2006 11:47 am

Posts
12459

Location
Merseyside, United Kingdom

Favourite OS
Microsoft Windows 7 Ultimate x64
I know that but its the impression given. I didn't upgrade to MySQL 5 because I have no need to. Upgrades should be done if needed, not because you can.

Also, Ive not had my Windows servers crash for no reason. However I have heard of Linux systems randomly Kernel panicing with no prior warning.

However, fanboyism isn't allowed so we'll keep opinions of the OS to ourselves otherwise a flame war will start. I'll just say that for servers, Windows is my bitch any day :)

_________________
Image

BetaArchive Discord: https://discord.gg/epK3r6A


Top  Profile  WWW
 PostPost subject:        Posted: Mon Nov 12, 2007 4:53 pm 
Reply with quote
Donator
Offline

Joined
Sat Aug 19, 2006 1:25 am

Posts
590

Location
Israel
Andy wrote:
I'll just say that for servers, Windows is my bitch any day :)

Yeah, well, considering your avatar, it's hard to think otherwise :wink:

EDIT: gave me an idea :D


Last edited by ppc_digger on Mon Nov 12, 2007 9:59 pm, edited 1 time in total.

Top  Profile
 PostPost subject:        Posted: Mon Nov 12, 2007 4:56 pm 
Reply with quote
Administrator
User avatar
Offline

Joined
Fri Aug 18, 2006 11:47 am

Posts
12459

Location
Merseyside, United Kingdom

Favourite OS
Microsoft Windows 7 Ultimate x64
ppc_digger wrote:
Andy wrote:
I'll just say that for servers, Windows is my bitch any day :)

Yeah, well, considering your avatar, it's hard to think otherwise :wink:


Yeah, that does kinda give it away. I manage 7 windows servers at work, and 4 for personal use.

_________________
Image

BetaArchive Discord: https://discord.gg/epK3r6A


Top  Profile  WWW
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 16 posts ] 




Who is online

Users browsing this forum: No registered users and 5 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
Jump to:  

All views expressed in these forums are those of the author and do not necessarily represent the views of the BetaArchive site owner.

Powered by phpBB® Forum Software © phpBB Group

Copyright © 2006-2018

 

Sitemap | XML | RSS