I'm running MySQL 5.0 on a production server and I require to upgrade mysql to version 5.5 to get a new collation support. What is the best procedure to follow? I cannot find MySQL 5.5 on the standard repositories. A yum install would be the safest, correct?
View 2 RepliesI 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 RelatedMy existing MySQL database is running on 11.1. I plan to do a fresh install of 11.3 in order to utilize the trimming feature for SSD drives. How should I install my MySQL database to the new version? Do I perform a backup then restore to the new install? Or can I just save the mysql db files to a cd and somehow attach it to the new install?
View 2 Replies View RelatedI 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
I 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]...
When I attempt to do the following:
Code:
sudo apt-get update
sudo apt-get upgrade
[code]....
I want to upgrade Apache, PHP, and MySql from a default version I'm having in my installed Slackware. What is the proper step to do this? Will it cause some problem if I upgrade them?
View 13 Replies View RelatedI am trying to install php-mysql but I am getting conflicts. I manually installed
MySQL-shared-community-5.1.32-0.rhel5
MySQL-client-community-5.1.32-0.rhel5
MySQL-server-community-5.1.32-0.rhel5
and I can not seem to find a php-mysql that works with MySQL 5.1
I followed the below thread and added the CentOS-Testing.repo and did a yum update php and it updated 30 packages, but when I try to install php-mysql I get :
[URL]
yum install php-mysql
Setting up Install Process
Parsing package install arguments
Resolving Dependencies
[Code].....
Where can I find a php-mysql that works with MySQL 5.1? I checked the mysql website and can not seem to find any matches.
i am using fedora 12i want to bakup my mysql database and extract it in my solaris 10 machine.in my fedora machine i gave
mysqldump (database-name) > bakup.sql
in my solaris machine i gave
mysql (newly created dbname) < bakup.sql
[code]....
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.
Recently upgraded to Centos 5.5 and was suprised to see that the distro still is running php 5.1.6.Anyone know when Centos RH plans on upgrading php in future distros?
View 4 Replies View RelatedThis is my first post, I hope I'm the the right place. I installed mysql mysql-server php-mysql perl-DBD-mysql libdbi-dbd-mysql via "yum install -y" on a server running CentOS 5.3 X86_64 The install completes successful with no errors, but once I start mysqld via "chkconfig --level 35 mysqld on" ; "service mysqld start" There are no errors in /var/log/mysqld.log netstat shows mysqld listening on 3306 and localhost is in /etc/hosts
[Code]...
I have two Centos 5 servers one running Asterisk with PHP installed and another sever running as a MySql Database server, at the moment when I try run simple script to see if I can connect to the remote server I get the following error.Quote:Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
View 2 Replies View RelatedI would like to change my username (or login name) and am wondering what the safest route to do so is. The install is on a headless server, which I just use ssh.There's a) using usermod -l newname oldname. The line in the usermod man that says that changing the login name doesn't change anything else, which makes me think that something else is bound to break. I've also considered b) creating a new user, moving the contents of my home directory to the new user, and deleting the old user. This is kind of cumbersome, but would this be the recommended way to ensure everything goes well (considering I still have to redo some config files).
View 5 Replies View RelatedThe latest kernel(2.6.32.9-67) is causing problems for my laptop.What are the best practices for safely removing a kernel?( Yum wants to remove gcc and friends also...)How can one prevent Software Update from relisting the bad boy?
View 6 Replies View RelatedSo what is the easiest way to install Ubuntu with win7 also on the computer?I'm asking because last time I ran Ubuntu it was Wubi'd into XP and then it broke, breaking XP's bootkernel and then keeping me from booting into anything...
View 5 Replies View RelatedWant to know if using a live CD, say Knoppix, gives a good level of protection when moving money about? I am very unsophisticated on the subject of security.This question has been addressed before on this site Code:if you have enough RAM you can ignore your local disks all together, and avoid the security risk of a swap file
How you do that then?Perhaps it would be better to use an operating system inside the software computer, virtual box, that only ever gets used for this b*nking purpose?
I have a script which when invoked will generally su into being a number of different users (for those that have read other threads from me, you will know.I am building my own user based package management system).Whilst 75 - 80% of the time there will be no need to be anyone other than the original user, there are times when the root password is required. Currently this is presented to the administrator at exactly the point in the script that it is required.At times this may be more than once and it may also happen for multiple users in a row.
What would be the best / safest method (in your opinion) of capturing the password at the start of the script and then delivering it when required?I have looked at expect ( I am not at all familiar ), but on the examples dealing with passwords, that I could find, they all seem to store the password in a simple bash like variable (which does not excite me at all from a security point).I can also potentially go down the sudo road, but the issue here is that I would either have to find a list of commands that an entire group can have access to without passwords (doesn't sound safe) or I am back to square one of then requiring a password for each individual user to be entered, which if at the start would still need to be captured and saved until necessary.So as I have said, I am open to any and all (constructive) advice
I need to run fsck on a large partition on my server on a periodic basis. In many cases, however, files are left open on the partition, e.g. XMing sessions are often left open for weeks at a time because connection is hit-or-miss, or jobs are left running.
My first thoughts are to shut down the daemons I know are using the partition, then traverse lsof for processes that have files open on the partition and do a SIGHUP, SIGTERM, SIGKILL sequence on them. One problem I see with this is that in some cases a script might be running a loop that performs a process on the partition. For example, suppose loop.sh is running from ~ and it loops process.sh over the files in /data (i.e. the partition in question.) The first signal would end process.sh, but loop.sh wouldn't be touched, which would allow it to proceed to the next iteration, etc. until the final instance of process.sh would get the SIGKILL and yet another iteration would start. Killing process groups might help here, however.
Ideally I would just go to init 1, check the filesytem (maybe run a backup,) then go back to init 4 (running Kubuntu, so no init 3.) I'm not exactly sure how to pull that off without the filesystem check happening every time the server goes to init 1, however.
how to upgrade from mysql5.1 to mysql5.5 version. Pls guide me in briefly.I did upgrade with the help of this url
http://www.ovaistariq.net/490/a-step...-to-mysql-5-5/ but i got error like this error:2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) when trying to connect FATAL ERROR: Upgrade failed
In /etc/my.cnf , i didnt get like this. Is this is the error
user = mysql; socket = /var/run/mysqld/mysqld.sock; port = 3306; basedir = /usr/local/mysql; datadir = /usr/local/mysql/data; tmpdir = /tmp; log_error = /var/log/mysql/error.log
When connecting to a database in a php script, where would be the safest place to store the connect.php file. I am thinking it should not be in public_html, but is it safe in sub folders or is there a method people generally use to keep such files secure and inaccessible.
The file I mean is one including the database name, user and password etc.
I would like to attempt creating a cron job to backup my root (/dev/sda1) & home (/dev/sda3) partitions to an external USB drive.I have been using Clonezilla to make image backups but, I have to physically do it, when I remember or have the time. I have never created a cron job, and worse, I have never created a .sh file which, I think, is what I need to do.
View 12 Replies View RelatedI have been using Centos on a VPS for about a year and love the speed and simplicity. So, I would like to convert my home computer to Centos 5.5 Currently, the computer is running Ubuntu 10.4 x64. The drive has 3 partitions (a main partition that I would want to format and install the Centos Base), a swap partition which can be formatted and used as is and a third partition that boots to /home.
I have a few concerns: 1-If I edit the third partition in the Centos install as "boot to /home," Will everything (theoretically) work? The only applications that concern me are E-Mail (evolution) and OpenOffice. I know that Centos 5.5 uses Evolution 2.1.x and Ubuntu uses 2.2.x but just shouldn't be too much of a problem. (I can copy the mail folders from a backup to the .evolution directory.)
2-My /home partition uses ext4. Is using this on Centos 5.5 "looking for trouble"?
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]...
Having read several threads and received excellent previous advice there are just a couple of points I want to check please before proceeding on laptop. I want to upgrade to 11.4 from 11.2. My disk setup is as follows:-
Disk /dev/sda: 120.0 GB, 120034123776 bytes
240 heads, 63 sectors/track, 15505 cylinders
Units = cylinders of 15120 * 512 = 7741440 bytes
Disk identifier: 0x462d462c
[Code]..
If I select existing /home root and swap partitions, format root but prevent formatting of /home and use a different user ID I believe that will leave my existing data intact and will allow me to trial new os. Is this correct approach? If all goes well and when I have new system working correctly, what is best way make old user id date accessible. Can I simply create my old id on new system and will that allow me to access data when I log on with that id?
Second question; at present I have the ability to boot to openSUSE, OS/2 and windoze. (It used to be done entirely by Boot Manager but during my last Linux installation I messed this up a bit so now machine boots to grub and this offers all three operating systems but chain loads Boot Manager if I select OS/2)
When I do the new installation what should I select to retain this setup so that I still have access to windoze and OS/2 but when selecting linux have new 11.4 system run.
Is i possible to upgrade from a point release, like 5.3, to another point release, like 5.4, using yum ? Or, even if it is possible, is it better to just do an install of 5.4 and choose the upgrade option on top of my 5.3 installation ?
View 3 Replies View Relatedi 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.
I am planning to install 10.4 when it arrives. And am not going to upgrade because i upgraded from 9.04 to 9.10 so now i need to refresh the system.But I have all my partitions except root using lvm2 logical volumes. My question is : What is the safest procedure to install 10.4 on an existing lvm2 without losing my files/partitions
View 2 Replies View Relatedhow to upgrade from centos 5.6 to 6?
View 14 Replies View RelatedI recently upgraded from centos 5.2 to 5.3 ( using yum) two desktop computers with a similar configuration (different hardware but similar software configuration). In both cases I saw that yum-updatesd has stopped working. The daemon start at boot and remain silent for a while (an hour or more, without signaling the presence of any update package) then suddenly the process dies without any messages in the log. Using lsof i saw that the daemon open a lot of file and library, but it newer try to connect to any repository.Now i have just launched it in foreground and debug mode (yum-updatesd -f -d) and i'm waiting for some useful debug messages.. Has someone had a similar experience ? What else can i try ?
View 2 Replies View Related