Server :: How To Upgrade Php And MySQL.
May 4, 2010I tried upgrading mySQL and PHP using up2date and what did it do? Downgraded me from mySQL 4.0.26-standard to 3.23.58 and did nothing with PHP.
[Code]....
ADVERTISEMENT
Server :: Upgrade MySQL From 5.0 To 5.1?
Jul 24, 2010I have mysql server 5.0 installed via binary package on RHEL 5 where I have big databases running on it.
I want to upgrade mysql server to 5.1 without backup/restore of DBs. what is the best way to do this?
I tried yum update mysql-server but RH repo doesnt provide mysql 5.1 yet. and I tried to download mysql-server 5.1 binary packages from mysql.com but I got errors when I did rpm -Uvh mysql-5.1.
Server :: Postfix Standalone To Mysql Upgrade?
Feb 16, 2011I did a basic U9.10 server install of postfix with the minimal config. Added a test user and things worked after a few minutes. I now want to setup a few new things and want to switch to use mysql as the back-end. I have mysql installed, setup postfix.admin which in turn setup the database/tables. Now when I logged in to that admin, the original test user is not there (which is fine), but I created the test domain again, created a user and an outside test failed saying user unknown.
Now I looked through the main.cf page and don't see anything obvious to say hey, put backend is mysql, here is the info. I then noticed via apt that postfix-mysql was not installed, so installed that, I see my .cf was backed up, but still don't see anywhere to connect the 2. So currently mail is still accepted from the test1 user running local. I don't mind wiping everyhing, but is there a simple place to just make a change or 2?
CentOS 5 Server :: Upgrade MySQL 5.0.77-3 To 5.1 For A Web Application
Dec 11, 2009I have to upgrade MySQL 5.0.77-3 to 5.1 for a webaplication.
If I write in Putty "# yam update" , it wont found a newer version of MySQL. how can I update my MySQL Version?
OpenSUSE Network :: ERROR 2002 (HY000): Can't Connect To Local MySQL Server Through Socket '/var/mysql/mysql.sock
Jun 7, 2011I think this goes here, but I'm not sure. I decided that XAMPP had been troublesome enough. MySQL never worked. So I decided to instal the LAMP stack offered by YaST. I went about installing it thinking that it would all work. But it seems that I was wrong. So I try to start mysql, and here's what I get:
Code:
the-matrix:~ # mysql start
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (2) or
Code:
the-matrix:~ # rcmysql start
Starting service MySQL warning: /var/mysql/mysql.sock didn't appear within 30 seconds
chmod: cannot access `/var/run/mysql/mysqld.pid': No such file or directory
[Code]...
General :: Can't Connect To Local MySQL Server Through Socket '/var/lib/mysql/mysql.sock' (2)
Jun 2, 2010i am using liferay5.2(mysql included in the download pack) on fedora. while liferay is working fine but i cannot connect to mysql.i am getting the error
[
[root@localhost ~]# ln -s /var/lib/mysql/mysql.sock /tmp
[root@localhost ~]# /etc/init.d/mysqld start
Timeout error occurred trying to start MySQL Daemon.
[code]....
i didnt find the mysql.sock file in the location /var/lib/mysql/mysql.sock. i cannot find the portal-ext.properties file also to make intial settings.
Ubuntu Installation :: Lucid Upgrade Hangs When Upgrading MySQL Server
May 2, 2010When this happens you have to open a terminal, get the process id for mysql-server-5 then kill that process. Like this:
Code:
ps -A
then from the list of processes that it spits out look at the process id (the number at the beginning of the line) for mysql-server-5.
Now type
Code:
sudo kill -9 XXXXX
where XXXXX is the process id for mysql-server, and enter your password. The upgrade process should now resume.
Ubuntu Servers :: Home Server 10.04 - Upgrade Hangs On Mysql / Resolve This?
Aug 11, 2010Been trying to upgrade home server for several days and it keeps hanging on the mysql upgrade. Here's the what apt-get says code....
View 3 Replies View RelatedUbuntu Servers :: Can't Reinstall Mysql-server After Power Failure During Aptitude Safe-upgrade
Jun 2, 2010A week or so ago I ran an aptitude safe-upgrade and while it was updating mysql I suffered a power-failure. Now, this never really happens in Holland but of course this once it happened at the worst possible time.
I've tried a lot of different things to get mysql working again, but am running into all kinds of problems. First mysql won't shut off properly (it does startup with the computer but I can't connect to it at all) during an aptitude purge. If I kill the process mysql seems to purge properly, but I guess this is not the case because I wasn't able to install it then.
Things seem to have gone a bit more smoothly this time, however:
Code:
snek@snek-server:~$ sudo aptitude install mysql-server
Reading package lists... Done
Building dependency tree
Reading state information... Done
[Code].....
Software :: Upgrade From Mysql-5.0.77-4.el5_4.2 To MySQL 5.1.47?
Jun 3, 2010I've installed MySQL using yum on CentOS 5. I'd like to upgrade mysql-5.0.77-4.el5_4.2 to MySQL Community Server 5.1.47. What is the best way to upgrade?
View 2 Replies View RelatedUbuntu Servers :: Mysql Error Stopping MySQL Database Server Mysqld?
Jun 17, 2010I have installed Mysql in Ubuntu 9, for the use of roundcube database.After installing iam getting the error like this
* Stopping MySQL database server mysqld [ OK ]
* Starting MySQL database server mysqld [ OK ]
* Checking for corrupt, not cleanly closed and upgrade needing tables.
So because of this in the roundcube configuration its giving the error message that MYSQL is not installed. So Kindly give me a idea how to solve this.
Software :: Connecting To Mysql Database - Can't Connect To Local MySQL Server Through Socket
Aug 25, 2010I'm having problems connecting to the mysql database on my system. I first noticed this when I was trying to set up the program anymeal. I subsequently tried using MySQL Administrator (mysql-admin), but had no luck. It gives my the following feedback:
Code:
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Click the 'Ping' button to see if there is a networking problem. I press the ping button, and it seems to connect.
Code:
Fedora :: MYSQL Error 2002 (HY000): Can't Connect To Local MySQL Server Through Socket?
Feb 22, 2011I've been attempting to set up a LAMP for local web development, which meant installing mysql-server. But now have a problem when trying to run mysql, I get:-
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
When trying to downgrade mysql-server I saw that there are dependency problems between the various modules (but can't recall which). But whichever route I truied the results are always the same.
Thought about trying XAMPP but I note that even has it's problems, is there any way I can get a lamp set up on FC14, or must I give it up as a bad job.
Howver, just been trying to again to fix the problems with downgrading mysql and get:-
Error: Package: mysql-server-5.1.55-1.fc14.i686 (@updates)
Requires: mysql(x86-32) = 5.1.55-1.fc14
Removing: mysql-5.1.55-1.fc14.i686 (@updates)
mysql(x86-32) = 5.1.55-1.fc14
Server :: Mysql 'Table 'mysql.user' Doesn't Exist'?
Aug 2, 2010I'm trying to setup wordpress on my server, which of course I need mysql for. I setup a database the other day, which worked perfectly, but I had to start again as I put some information in wrong. Now, I can create a database fine, but when I run
Code:
GRANT ALL ON wordpress.* TO wordpress@localhost IDENTIFIED BY "password";
I get the output:
[code]...
CentOS 5 :: Error: Mysql Conflicts With Mysql-server-community
Jun 4, 2009I have MySQL 5.1.34 and PHP 5.1.6 installed on my system, how do I install php-mysql? Each time I try, it says
mysql-5.0.45-7.el5.i386 from base has depsolving problems
-- > mysql conflicts with mysql-server-community
error: mysql conflicts with mysql-server-community
Ubuntu :: Reinstalling MySQL Server - Still Have My Databases At /lib/var/mysql
Jun 18, 2010I was having issues with MySQL Server and uninstalled it. I still have my databases at /lib/var/mysql.
My question: if I install MySQL Server (same version, 5.1) again, will it delete my databases, or will they still work?
Ubuntu :: Remove Everything Related To Mysql / Mysql-server?
May 23, 2011How can I really, really remove everything related to mysql / mysql-server. I read and tried all kinds of things, but on every reinstall there is still old mysql stuff there, for example an existing password. Even resetting the password does not help.
Reason of removal: it looks like the mysql setup is really corrupt, so I want to remove, and then do a fresh install. Running Ubuntu 11.04 64-bit
sander@R540:~$ sudo apt-get purge mysql-server
Reading package lists... Done
Building dependency tree
Reading state information... Done
Package mysql-server is not installed,
[Code]....
Server :: Recover MySQL Innodb From /var/lib/mysql/ Backup?
Jan 30, 2011I installed mediawiki the other day and went with the default innodb option. However a week later something went wrong. And since I have scripts that nightly backup /var/ I just copied the backup of /var/lib/mysql/wikidb/ (as I've done with MyISAM). Then when I connect the wikidb database. I can see the tables (via "show tables"), but when I do any query with them (check table X, select * from X) I get:
Code:
Table 'wikidb.X' doesn't exist I've since read that can can't just copy the database directory like MyISAM, and there appears to be no way that I can find to restore or fix Innodb, without a dump of the data. And I never got a chance to do a mysqldump of the data. So has anybody got any idea how I can at least view the "page" table from the files I've backed up in /var/lib/mysql/wikidb/ ?
CentOS 5 Server :: MySQL On Cent OS 5.2, Error In MySQL
Mar 3, 2009I just configured a complete Cent OS 5.2 system for use as a web server. I can configure Apache and PHP but MySQl seems to be causing some issues -
[mysqld]
datadir=/var/lib/mysql
socket = /var/lib/mysql/mysql.sock
user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
[Code]...
CentOS 5 Server :: MySQL Setup Without 'mysql.server'
Jul 14, 2010I am using CentOS5 and installed the MySQL for server during the installation. I can set up and use MySQL databases. But I cannot make it startup everytime the server restarts. And quite a lot of methods need this folder "support-files/mysql.server", while my set up cannot find this. I am wondering if my installation of the MySQL for server is complete or not.
View 4 Replies View RelatedCentOS 5 :: Upgrade Existing MySQL 5.0.77 Version On CentOS 5 Red Hat To MySQL 5.1.x
Aug 31, 2010I want to upgrade existing MySQL 5.0.77 version on CentOS 5 Red Hat Linux to MySQL 5.1.x. Is anybody have list of patches or upgrades to upgrade to MySQL 5.1.x?
View 6 Replies View RelatedUbuntu Installation :: Cannot Start Mysql - "Can't Connect To Local MySQL Server Through Socket:"?
Mar 15, 2010I am getting the following error when starting mysql using 'sudo /etc/init.d/mysql start':
Mar 15 16:33:56 MoodFishDev /etc/init.d/mysql[18317]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Mar 15 16:33:56 MoodFishDev /etc/init.d/mysql[18317]: ^G/usr/bin/mysqladmin: connect to
[code]....
Server :: MySQL Setup Without "mysql.server" In CentOS5
Jul 14, 2010I am using CentOS5 and installed the MySQL for server during the installation. I can set up and use MySQL databases. But I cannot make it startup everytime the server restarts. And quite a lot of methods need this folder "support-files/mysql.server", while my set up cannot find this. I am wondering if my installation of the MySQL for server is complete or not.
View 3 Replies View RelatedDebian :: How To Upgrade MySQL From 5.0.51 To 5.1
Aug 23, 2010I have 5.0.51 on my development box, which just happens to be the one release not supported by my CMS software. I have messed with a few attempts to upgrade, but I don't know what I'm doing in that regard. Fortunately I have a virtual machine for testing.
View 4 Replies View RelatedServer :: Server Slow : Apache Mysql Fine Tuning Server For Faster And More Responsive?
Apr 21, 2011I'm running a linux cloud server with the following config
1.2ghz Processor allocation
752MB Ram
The site loads slow and clicking a link almost freezes the page for a second. Also, the page loads could be much faster. We've been running mysqltuner and have pretty much optimized all slow queries. Is there anything we can do to fine tune the server for faster and more responsive?
Httpd.conf
Timeout 20
KeepAlive Off
MaxKeepAliveRequests 100
KeepAliveTimeout 5
<IfModule prefork.c>
code....
Programming :: Error ""Can't Connect To Local MySQL Server Through Socket" In Connecting To MySQL In C Language
Sep 29, 2010I wrote a code in C to connect to MySQL by using mysql_real_connect function but I recieved error "Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)" (by using mysql_error function).
I also did the following things: in mysql I typed 'SHOW VARIABLES LIKE '%SOCKET%'', it returned /var/lib/mysql/mysql.sock I typed 'mysql_config --socket' in shell, it returned /var/lib/mysql/mysql.sock I modified /etc/my.cnf file
Software :: Upgrade To The Latest MySQL?
Jul 23, 2010how i can upgrade to the latest MySQL? I have not set up any DB so it should not be any problem in migrating. but i just don't know the basic commands to do this
View 1 Replies View RelatedCentOS 5 :: Upgrade Mysql 5.0 To 5.1 Or Higher?
May 13, 2010I have downloaded MySQL-server-community-5.1.46-1.rhel5.i386.rpm But am not sure how to upgrade my existing mysql5.0 with out damaging anything.
Below is PHP, MYSQL & Apache Versions installed on my Centos box.
Using YUM to upgrade mysql 5.0 to 5.1 I get this;
yum upgrade mysql-server
Loaded plugins: fastestmirror, priorities
Loading mirror speeds from cached hostfile
* addons: mirror.steadfast.net
[Code].....
Ubuntu Installation :: Upgrade To 10.04 Causes MySQL Headaches?
May 26, 2010After upgrading to 10.04 on a server, MySQL does not start. I have tried multiple things from posts. Nothing has worked. So, I down to reinstalling MySQL. That doesn't even work. It freezes w/ the following log:
Setting up libdbd-mysql-perl (4.012-1ubuntu1) ...
Setting up mysql-client-core-5.1 (5.1.41-3ubuntu12.1) ...
Setting up mysql-client-5.1 (5.1.41-3ubuntu12.1) ...
Setting up mysql-server-core-5.1 (5.1.41-3ubuntu12.1) ...
Setting up mysql-server-5.1 (5.1.41-3ubuntu12.1) ...
100526 10:41:12 [Note] Plugin 'FEDERATED' is disabled.
100526 10:41:12 InnoDB: Started; log sequence number 0 44233
[Code]....
Ubuntu :: Mysql Will Not Start - Upgrade To Lucid
Jun 2, 2010I cannot get mysql to start since updating to Lucid. It seems to be utterly silent, no log entries anywhere I can see or anything.
I've tried reinstalling the ubuntu install to no avail.
Here's the /etc/mysql/my.cnf:
(default from upgrade I suspect) this is also the debian.cnf
Code:
# Automatically generated for Debian scripts. DO NOT TOUCH!
[client]
host = localhost
user = debian-sys-maint
[Code].....
I'm just getting utterly nothing in any log.
root@linuxbox:/etc/mysql# sudo start mysql
start: Job is already running: mysql
but there isn't! top/ps show nothing at all
root@linuxbox:/etc/mysql# sudo restart mysql (or stopping) just sit there, hung on something.