MySQL related problems

[toukie]

I am trying again. What does this mean?

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

[Ubi]

it means you buggered up something and you should report

Code: Select all

/etc/init.d/mysql status

and also

Code: Select all

tail -n 40 /var/log/mysql.log

[toukie]

The first command gives some information the second doesn't give anything. What is the relevant information supposed to be?

If I try to open the log with FileZilla it is "permission denied". I would do reinstall of the system but I have Word Press running and I don't know how one does a backup of the database or the .sql files that I have there. The database will be gone with reinstall, I don't want to lose my Word Press site.

[Ubi]

The first command gives some information the second doesn't give anything. What is the relevant information supposed to be?

Well maybe if you bloody posted the info that did come from the status report then I would be able to tell you, but as you seem to be such an expert on linux admin you knew in advance that the information was not relevant.

If you want to back up the DB just turn off mysql and copy the binary data from the files. But I guess you know this already.

[toukie]

Server version 5.1.49-3
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/run/mysqld/mysqld.sock
Uptime: 17 hours 43 min 22 sec

Threads: 8 Questions: 15885 Slow queries: 0 Opens: 828 Flush tables: 1 Open tables: 64 Queries per second avg: 0.248.

Does that contain any relevant information? I can't help but the other command didn't give anything.

I have B3 since a month and I have done this databasemess for about two weeks. I have never seen such a thing as database before. I can follow simple step by step instructions if I can take the steps a couple of times back and forth. That's how I moved WP to this new server. It cost me my upgrades from Exito, they are off: "Failed to access MySQL with default root login, unable to continue with upgrade" That is the problem.

It would be nice to know the exact command for doing back-up of the database. Command line is new to me. I am a semi-illiterate computer user. I got what I wanted with B3, the problem is that the software updates are gone.

[RandomUsername]

There are plenty of posts about the update issue. If you set a password on MySQL root the web updates don't work. You can, however, still update from the command line using apt-get or aptitude.

To back up databases, google is you friend - http://www.devshed.com/c/a/MySQL/Backin ... -Database/

[toukie]

OK then I am just a few minutes from the solution.

I have to learn how to take away the root password or I have to learn how I can apt-get Excitos software updates if that is possible to do. I think that the root@localhost account was necessary for the creation of an other non-root user, before that it was "access denied" all the time.

That's how I got to the database anyway. So now I have the root with its password blocking my software updates.

What is the command to take away the root user password?

I need the exact commands because I am completely new to this.

Thx for the back-up information RandomUsername! It seems to be clear and simple with all the commands written out. Google is you friend, yes, but most often you get so many different friends that it becomes a nuisance.

[RandomUsername]

OK then I am just a few minutes from the solution.

I have to learn how to take away the root password or I have to learn how I can apt-get Excitos software updates if that is possible to do. I think that the root@localhost account was necessary for the creation of an other non-root user, before that it was "access denied" all the time.

That's how I got to the database anyway. So now I have the root with its password blocking my software updates.

What is the command to take away the root user password?

I need the exact commands because I am completely new to this.

Try this:

http://bit.ly/yEv4UV

Or failing that, this:

http://bit.ly/zYx72g

[toukie]

OK, backing up the database works fine with those more or less precise instructions. Now I have to pick up one of those thousands of Google-friends for to find a solution for the remaining problem. I guess that by next week the problem will be solved.

The preconfigured B3 saves you a lot of time (if you know all the rest from before)

[toukie]

By the way, apt-get can't be the same as Excitos software updates. I want to get Excitos B3 updates back and then apt-get whatever I want to pick up from debian.

[RandomUsername]

By the way, apt-get can't be the same as Excitos software updates. I want to get Excitos B3 updates back and then apt-get whatever I want to pick up from debian.

Apt in the B2 / B3 is configured to look in Exito's own repositories first. Any packages specifically configured by them will be installed as will any packages required from the public Debian repositories.

Just do this as root:

Code: Select all

aptitude update
aptitude upgrade

Maybe, depending on if you have a B2 or B3 (I can't remember) and what version you're currently on, followed by

Code: Select all

aptitude dist-upgrade

This will want to remove some packages too most likely but it should be safe to allow it.

OK, backing up the database works fine with those more or less precise instructions. Now I have to pick up one of those thousands of Google-friends for to find a solution for the remaining problem. I guess that by next week the problem will be solved.

Also, the answers to all your questions can be found in the top two or three results from the links I posted. Just requires about five minutes of research that will help you understand things better than us just shouting commands at you.

[toukie]

thx RandomUsername, now I know even how the updates work! I have B3 (since about 1 month) and I updated to 2.4 when it came. The rest is no problem, I'll check the accounts and passwords. Anyway, I use a non-root account for WP in the database. I understand that the root has to be without password for to get updates from Excito. The problem is more or less solved.

[RandomUsername]

thx RandomUsername, now I know even how the updates work! I have B3 (since about 1 month) and I updated to 2.4 when it came. The rest is no problem, I'll check the accounts and passwords. Anyway, I use a non-root account for WP in the database. I understand that the root has to be without password for to get updates from Excito. The problem is more or less solved.

If you use the command line method it doesn't matter if you have a root password set in mySQL or not. That only applies to updates through the web interface.

[toukie]

I tried to update from the command line. I think it works but there was nothing to update this time. Right or wrong?

root@b3:/home/anon# aptitude update
Hit http://ftp.se.debian.org squeeze Release.gpg
Ign http://ftp.se.debian.org/debian/ squeeze/main Translation-en
Hit http://b3.update.excito.org elvin Release.gpg
Hit http://ftp.se.debian.org squeeze Release
Ign http://ftp.se.debian.org squeeze/main armel Packages
Ign http://b3.update.excito.org/ elvin/main Translation-en
Hit http://ftp.se.debian.org squeeze/main armel Packages
Hit http://b3.update.excito.org upstream_squeeze Release.gpg
Ign http://b3.update.excito.org/ upstream_squeeze/main Translation-en
Hit http://b3.update.excito.org elvin Release
Hit http://b3.update.excito.org upstream_squeeze Release
Ign http://b3.update.excito.org elvin/main armel Packages
Hit http://b3.update.excito.org elvin/main armel Packages
Ign http://b3.update.excito.org upstream_squeeze/main armel Packages
Hit http://b3.update.excito.org upstream_squeeze/main armel Packages

root@b3:/home/anon# aptitude upgrade
No packages will be installed, upgraded, or removed.
0 packages upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
Need to get 0 B of archives. After unpacking 0 B will be used.

[RandomUsername]

Well yeah, if you're on 2.4 then you're already on the latest release.