I 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 RepliesI'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 RelatedI can't get mysql to update from lenny (mysql-5.0) to squeeze (5.1). apt tries to start the server but comes up with some kind of configuration script error.
View 1 Replies View RelatedI 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 RelatedI 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.
I 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]....
I 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]...
how 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 RelatedI 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].....
i 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.
After 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]....
I 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.
I'm totally new to MySQL / PHPAdmin and have been dropped in at the deep end regarding getting MySQL and phpMyAdmin upgraded... When I look at the RPM's I see:
php-mysql-4.2.2-17.2
php-4.2.2-17.2
php-imap-4.2.2-17.2
php-ldap-4.2.2-17.2
But when I go to the GUI I see: Welcome to phpMyAdmin 2.5.7-pl1 MySQL 4.0.16-standard-log running on localhost as root@localhost So to start with I'm not totally sure what version I'm running! I need to get these upgrades done due to PCI requirements so they are saying to upgrade to at least 4.0.25 I'm currently running RedHat9 so ideally need to know the easiest way to upgrade to a later 4.0 or 4.1 version.
I 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?
There is a known bug with MySQL 5.1.42 that prohibits the QMYSQL driver from functioning properly. I finally found it on the MythTV bug tracker, which links it to the MySQL site. There is a patch available, but the bug was fixed in 5.1.43. To fix it on my system, I grabbed the all of -current/source/ap/mysql except for the actual source, and downloaded the latest version (5.1.44) from [URL].
View 2 Replies View RelatedI 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?
I've just upgraded to 9.10, and mysql fails to start. When I do an /etc/init.d/mysql start, I just get
* Starting MySQL database server mysqld ...fail!with no additional errors or information to say what went wrong. I saw this thread http://ubuntuforums.org/showthread.php?t=1322070 but the fix mentioned does not apply, as I don't have the #skip bsd line in my config file.
I'm running Lucid, and after one apt-get upgrade I get hangs with the mysql package: Preparing to replace mysql-server-5.1 5.1.41-3ubuntu11 (using .../mysql-server-5.1_5.1.41-3ubuntu12_i386.deb) ... no matter what I do I can't get it to remove or install the mysql package. I've tried doing:
sudo dpkg --remove --force-remove-reinstreq mysql-server-5.1 but even that just hangs forever. I just want to remove the package so I can install the other updates
I upgraded from Kubuntu 9.10 to 10.04. 32 bit. The install had not finished as it barked at tripwire config. I have had to stop it and continue from command prompt. More or less the install went OK. After the install, mysql 5.1 does not want to start or stop. Commands
/etc/init.d/mysql stop ( or 'stop mysql' , or service mysql stop' )
/etc/init.d/mysql start
Do not finish - do not return to command prompt. No log messages insyslog or mysql logs. Say, I do 'service mysql start', the command does not return, I click Ctrl+C, then repeat the command. This displays :
'start: Job is already running: mysql'.
Of course mysql is not running. I've tried to remove and reinstall the packages. No result. There is 'stop mysql' command in one of install scripts that hangs.
I am trying to determine which version of Ubuntu we have installed on our Webfusion VPS in order to see how to update to specific php and mysql versions needed for installing some software.
uname -a gives this:
Linux [hostname] 2.6.18-028stab070.2 #1 SMP Tue Jul 6 14:34:09 MSD 2010 x86_64 GNU/Linux
I don't see anything that matches up to any of the Ubuntu releases. Is there any other way to determine what we have?
We have Plesk 9.5.2 on the machine.
Certain software we need to install requires PHP 5.2.10+ and Mysql 5.2+ but we currently have PHP 5.2.4-2ubuntu5.12 with Suhosin-Patch 0.9.6.2 and Ver 14.12 Distrib 5.0.51a
how to get the required versions of php and mysql (without breaking Plesk)? I tried editing /etc/apt/sources.list to add a new repository and using apt-get upgrade php but I probably did not add the correct repository.
I've just upgraded my 9.4 to 9.10 on my 64bit desktop PC. Shortly afterwards I noticed that MySQL had gone away. There was no mysqld running. I tried a restart to no effect. So tried an un-install and re-install with the Package Manager. This failed! There was quite an extensive message in details, which started:-
invoke-rc.d initscript mysql, action "start" failed
dpkg: error processing mysql-server-5.1 (--configure):
subprocess installed post-installation script returned error exit status 1
dpkg: dependency problems prevent prevent configuration of mysql-server
And it goes on, but that's the essence of it. I subsequently tried a complete removal and re-install, to no avail.I notice that /var/log/messages contains:
Apr 12 01:10:15 Mintaka kernel: [ 2538.821153] type=1505 audit(1271031015.407:259): operation="profile_replace" pid=9328 name=/usr/sbin/mysqld
Followed by many:
Apr 12 01:10:15 Mintaka kernel: [ 2538.885370] type=1503 audit(1271031015.477:260): operation="open" pid=9355 parent=9354 profile="/usr/sbin/mysqld" requested_mask="r::" denied_mask="r::" fsuid=0 ouid=0 name="/sys/devices/system/cpu/"
When 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.
Been 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 RelatedThe Payment Card Institute (PCI) is requiring our site to upgrade to the latest versions of Apache, Mysql, OpenSSL, and PHP to fix known bugs that can compromise securityI can build all these from source, but when I do "make install" they don't mimic at all what is installed (directory format, files, etc) when I do apt-get install (of whatever old versions are in the dist).How can I find out how the packages are build via configure/make so that I can replicate the files, directory structure, etc, just with the current versions.
View 9 Replies View RelatedA 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].....
I have installed debian on my laptop and included during the installation the webserver version. Now I want to develop a page locally to test it before I put it on the web. I first had an old reflex, jumping straight away and installing xampp. But then I thought that I already all that it takes as I installed the webserver feature of debian. I installed phpmyadmin ( with the command #apt-get install phpmyadmin) as to be able to create and attribute databases but when I try to log in I have the following message:
"Error
#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)"
I googled but I cannot find the mysql.conf (I searched using "find") but with no result. It is all very blury what is going on with this webserver option running on my laptop...
I'm trying to install mysql on Lenny. I managed to get apache and php going just fine but i'm getting this error for mysql at the mo: The following packages have unmet dependencies.
mysql-client: Depends: mysql-client-5.1 but it is not going to be installed
mysql-server: Depends: mysql-server-5.1 but it is not going to be installed
E: Broken packages
I don'thave a cluse how to fix this. I've read that adding a line in sources.
I'm currently trying to set up FreeRADIUS with DaloRADIUS and I'm stuck at FreeRADIUS getting clients (as NAS-es) from the MySQL database.
FreeRADIUS will no longer start after uncommenting the following line in my /etc/freeradius/sql.conf (which is supposed to let it use the MySQL database):
Code: Select allreadclients = yes
I have ran "freeradius -X" to find out what's going on with this output:
Code: Select allrlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked
rlm_sql (sql): Attempting to connect to radius@localhost:/radius
rlm_sql (sql): starting 0
rlm_sql (sql): Attempting to connect rlm_sql_mysql #0
rlm_sql_mysql: Starting connect to MySQL server for #0
[Code] ....
So it seems that the radius user is not authenticated. However I have verified that the login details I entered in my sql.conf are the correct ones (I even tried manually logging in with them and it worked).
I've just installed mysql-server (apt-get install mysql-server) in my debian vps, it ask for password of which i had provided. However after the install finishes, i run the command "mysql -u root -p", i entered my password but says "ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES".
View 3 Replies View RelatedI am not sure whether I ask this question on the right forum. My debian mailserver is depending on a MySQL database. Every reboot it takes around 30 minutes to boot because of the database check. I could not find the right command or setting to boot without this check. Do you know how to do this.
View 1 Replies View Related