[CentOS] Upgrading MySQL
Hi; Upon trying to run django, I get this error: ImproperlyConfigured: MySQLdb-1.2.1p2 or newer is required; you have 1.2.1 If I run yum update mysql I don't upgrade (expected). What do? TIA, Jack ___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
[CentOS] Upgrading MySQL
Hi; I'm trying to install django and got this error: django.core.exceptions.ImproperlyConfigured: MySQLdb-1.2.1p2 or newer is required; you have 1.2.1 So then I tried yum upgrade mysql and got this: No Packages marked for Update Please advise. TIA, Susan ___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
Re: [CentOS] Upgrading MySQL
From: Jack Fredrikson > Upon trying to run django, I get this error: > ImproperlyConfigured: MySQLdb-1.2.1p2 or newer is required; you have 1.2.1 > If I run yum update mysql I don't upgrade (expected). What do? Why are you trying to update mysql when the error says 'MySQLdb'? Check also the version... mysql is 5.x; not 1.x. # yum whatprovides */MySQLdb ... MySQL-python-1.2.1... on CentOS 5 MySQL-python-1.2.3... on CentOS 6. How did you install django? There are django packages from repoforge and elrepo... JD ___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
Re: [CentOS] Upgrading MySQL
On 28/06/2010 18:21, Susan Day wrote: > Hi; > I'm trying to install django and got this error: > > django.core.exceptions.ImproperlyConfigured: MySQLdb-1.2.1p2 or newer is > required; you have 1.2.1 > > So then I tried yum upgrade mysql and got this: You should go and talk about this in the django lists, you clearly need very basic help. Also, that message indicates you need a newer MySQL-python package, not mysql. Have you considered starting with a very basic tutorial on django and python first ? Getting some of the concepts right, early on, will help make sure you go a lot further. - KB ___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
Re: [CentOS] Upgrading MySQL
2010/6/28 Susan Day > Hi; > I'm trying to install django and got this error: > > django.core.exceptions.ImproperlyConfigured: MySQLdb-1.2.1p2 or newer is > required; you have 1.2.1 > > So then I tried yum upgrade mysql and got this: > > No Packages marked for Update > > Please advise. > TIA, > Susan > > ___ > CentOS mailing list > CentOS@centos.org > http://lists.centos.org/mailman/listinfo/centos > > Hi, you can use package MySQL-python from CentOS Testing repo - there is newer version (1.2.2) which works ok. I'm using it without any problems -- Jakub Jedelský e-mail: jakub.jedel...@gmail.com ___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
Re: [CentOS] Upgrading MySQL
> django.core.exceptions.ImproperlyConfigured: MySQLdb-1.2.1p2 or newer is > required; you have 1.2.1 To identify what package contains a specific file, you can use yum search. For example: yum search MySQLdb returns MySQL-python.x86_64 : An interface to MySQL therefore MySQLdb can be updated by updating MySQL-python. M ___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
[CentOS] upgrading Mysql 5.0.95
Hi All, I'm getting things ready to upgrade my aging installation of MySQL 5.0.95 on my CentOS 5 LAMP server. With the impending EOL date of 3.31 fast approaching my sense of doom and urgency is increasing. I see that the necessary packages are available in @base and @updates - mysql51 and mysql55 respectively but from all the information I've read on the matter so far I'm left with a few questions I don't yet have answers to.' What I've done so far and thankfully was able recover from: 1. installed and enabled to epel repo - ran yum remove mysql - this command wanted to remove a few things I wanted to keep in place like dovecot and a few php53 packages. I didn't want to have to go back and clean up any messes that would create. So, I used the rpm -e --nodeps command to remove the MySQL packages. - because this was a redhat repo it installed the binaries in a total different place AND tossed all my existing data directories. and yes I spit coffee all over my laptop screen and yes, I did have data dir backups and a dump of MySQL data. HOLY CRAP! 2. removed the epel packages - disabled this repo - for ever at least for now... 3. reinstalled the old MySQL 5.0.95 packages - because I was hyper-ventilating - reset roots password - imported all the databases from the dump and checked my web apps - everything working again. - I did have to recreate the mysql.servers table to be able to flush privileges. I understand that mysql51 is available in @base for the sole purpose of upgrading old MySQL and mysql55 is in updates for getting to 5.5, however here is where things get a little fuzzy for me: Steps for Upgrading (as I understand them): 1. Take a dump of all mysql database using mysqldump --add-drop-database --all-databases 2. Stop mysql services 3. make a backup of data directories: /var/lib/mysql (but its not _supposed_ to remove the data directories.) 3. yum remove mysql mysql-server (again, it will include a few things I don't want removed. so, i'll have to use rpm -e --nodeps and list the packages for removal then issue yum clean all.' 4. yum install mysql51 5. start mysql service 6. run command mysql_upgrade... (here's where things start getting fuzzy) Question #1: is this command to be run from the commandline or should I log into mysql as root user and run the command? Question #2: at this point I will have mysql 5.1 installed and running but to get up to 5.5 am I expected to yum remove 5.1 and then yum install 5.5 from @updates and repeat steps 5 and 6 OR simply run the command yum update mysql51* to catch all already installed mysql51 packages to and then run the mysql_update command to bring data up to date with the current mysql install? THank you for your kind attention... -- Mark ___ CentOS mailing list CentOS@centos.org https://lists.centos.org/mailman/listinfo/centos
Re: [CentOS] upgrading Mysql 5.0.95
On Sun, Mar 19, 2017 at 08:32:38AM -0400, Mark Weaver wrote: > I'm getting things ready to upgrade my aging installation of MySQL > 5.0.95 on my CentOS 5 LAMP server. With the impending EOL date of 3.31 > fast approaching my sense of doom and urgency is increasing. It isn't clear to me, but are you migrating away from CentOS 5 as part of this MySQL update? -- Jonathan Billings ___ CentOS mailing list CentOS@centos.org https://lists.centos.org/mailman/listinfo/centos
Re: [CentOS] upgrading Mysql 5.0.95
On 03/19/2017 10:00 AM, Jonathan Billings wrote: On Sun, Mar 19, 2017 at 08:32:38AM -0400, Mark Weaver wrote: I'm getting things ready to upgrade my aging installation of MySQL 5.0.95 on my CentOS 5 LAMP server. With the impending EOL date of 3.31 fast approaching my sense of doom and urgency is increasing. It isn't clear to me, but are you migrating away from CentOS 5 as part of this MySQL update? Heavens no... I love my CentOS 5 server. I going to try and keep it around as long as possible. I've got another machine in the rack that I've got CentOS 7 installed on, but there are differences in that OS and the items running on it that I don't like at all. SELinux comes to mind... No, I definitely have plans on running CentOS5 for while long. Mostly because there's an issue with one of the web apps I'm running on my C5 server that is having problems running correctly on C7. I haven't figured out why yet. ___ CentOS mailing list CentOS@centos.org https://lists.centos.org/mailman/listinfo/centos
Re: [CentOS] upgrading Mysql 5.0.95
On Sun, Mar 19, 2017 at 10:24:27AM -0400, Mark Weaver wrote: > On 03/19/2017 10:00 AM, Jonathan Billings wrote: > >On Sun, Mar 19, 2017 at 08:32:38AM -0400, Mark Weaver wrote: > >>I'm getting things ready to upgrade my aging installation of MySQL > >>5.0.95 on my CentOS 5 LAMP server. With the impending EOL date of 3.31 > >>fast approaching my sense of doom and urgency is increasing. > > > >It isn't clear to me, but are you migrating away from CentOS 5 as part > >of this MySQL update? > > > > Heavens no... I love my CentOS 5 server. I going to try and keep it around > as long as possible. I've got another machine in the rack that I've got > CentOS 7 installed on, but there are differences in that OS and the items > running on it that I don't like at all. SELinux comes to mind... > > No, I definitely have plans on running CentOS5 for while long. Mostly > because there's an issue with one of the web apps I'm running on my C5 > server that is having problems running correctly on C7. I haven't figured > out why yet. I figured that since you mentioned the EOL date of 3.31, you understood that meant no new updates for CentOS 5. No more support for CentOS 5. That means you'd be putting in all this work to migrate mysql on a platform that isn't supported anymore. Why bother updating mysql then? Its going to be living on an unsupported platform anyway, with no bug fixes or security patches. -- Jonathan Billings ___ CentOS mailing list CentOS@centos.org https://lists.centos.org/mailman/listinfo/centos
Re: [CentOS] upgrading Mysql 5.0.95
On 03/19/2017 10:43 AM, Jonathan Billings wrote: On Sun, Mar 19, 2017 at 10:24:27AM -0400, Mark Weaver wrote: On 03/19/2017 10:00 AM, Jonathan Billings wrote: >On Sun, Mar 19, 2017 at 08:32:38AM -0400, Mark Weaver wrote: >>I'm getting things ready to upgrade my aging installation of MySQL >>5.0.95 on my CentOS 5 LAMP server. With the impending EOL date of 3.31 >>fast approaching my sense of doom and urgency is increasing. > >It isn't clear to me, but are you migrating away from CentOS 5 as part >of this MySQL update? > Heavens no... I love my CentOS 5 server. I going to try and keep it around as long as possible. I've got another machine in the rack that I've got CentOS 7 installed on, but there are differences in that OS and the items running on it that I don't like at all. SELinux comes to mind... No, I definitely have plans on running CentOS5 for while long. Mostly because there's an issue with one of the web apps I'm running on my C5 server that is having problems running correctly on C7. I haven't figured out why yet. I figured that since you mentioned the EOL date of 3.31, you understood that meant no new updates for CentOS 5. No more support for CentOS 5. That means you'd be putting in all this work to migrate mysql on a platform that isn't supported anymore. Why bother updating mysql then? Its going to be living on an unsupported platform anyway, with no bug fixes or security patches. I think I explained that above... There are issues with one of my main web applications on my CentOS 7 box that are taking a lot more time resolving then was anticipated, so I'd like to upgrade MySQL on the CentOS 5 server while I'm working things out. Guess I'll stumble through this as well... ___ CentOS mailing list CentOS@centos.org https://lists.centos.org/mailman/listinfo/centos
Re: [CentOS] upgrading Mysql 5.0.95
On 03/19/2017 07:32 AM, Mark Weaver wrote: I'm getting things ready to upgrade my aging installation of MySQL 5.0.95 on my CentOS 5 LAMP server. With the impending EOL date of 3.31 fast approaching my sense of doom and urgency is increasing. Packages don't disappear after 3/31. They just get moved to vault.centos.org, where they will remain, never to be updated again. Heck, you can still get CentOS 2.1 packages from there. -- Bob Nichols "NOSPAM" is really part of my email address. Do NOT delete it. ___ CentOS mailing list CentOS@centos.org https://lists.centos.org/mailman/listinfo/centos
Re: [CentOS] upgrading Mysql 5.0.95
On 03/19/2017 01:06 PM, Robert Nichols wrote: On 03/19/2017 07:32 AM, Mark Weaver wrote: I'm getting things ready to upgrade my aging installation of MySQL 5.0.95 on my CentOS 5 LAMP server. With the impending EOL date of 3.31 fast approaching my sense of doom and urgency is increasing. Packages don't disappear after 3/31. They just get moved to vault.centos.org, where they will remain, never to be updated again. Heck, you can still get CentOS 2.1 packages from there. -- Bob Nichols "NOSPAM" is really part of my email address. Do NOT delete it. It's ok... its all a mute point because earlier today I did everything in true linux tradition: I fixed it until I broke it and I broke it but good. MySQL no longer runs on that LAMP server. Now it's just a LA_P server. :-) and doing a fine job running Sendmail I might add. I've just had to move all the databases over to the host I'm migrating to a little earlier than I'd planned. Mark ___ CentOS mailing list CentOS@centos.org https://lists.centos.org/mailman/listinfo/centos
Re: [CentOS] upgrading Mysql 5.0.95
On Sun, 2017-03-19 at 10:24 -0400, Mark Weaver wrote: > Heavens no... I love my CentOS 5 server. I going to try and keep it > around as long as possible. I like and admire C5 too. Httpd applications on C5 also run, without problems in my experience, on C6. -- Regards, Paul. England, EU. England's place is in the European Union. ___ CentOS mailing list CentOS@centos.org https://lists.centos.org/mailman/listinfo/centos
[CentOS] Upgrading MySQL from 4.1 to 5
Hello All, I am trying to upgrade MySQL on CentOS 4.5 but having a hard time. I need to go from MySQL 4.1 to 5. I downloaded the following two files: mysql-server-5.0.58-1.el4.centos.i386.rpm mysql-5.0.48-2.el4.centos.i386.rpm I tried to do: yum install mysql-server-5.0.58-1.el4.centos.i386.rpm And get: Setting up Install Process Setting up repositories Reading repository metadata in from local files Parsing package install arguments Examining mysql-server-5.0.58-1.el4.centos.i386.rpm: mysql-server - 5.0.58-1.el4.centos.i386 Marking mysql-server-5.0.58-1.el4.centos.i386.rpm as an update to mysql-server - 4.1.20-3.RHEL4.1.el4_6.1.i386 Resolving Dependencies --> Populating transaction set with selected packages. Please wait. ---> Package mysql-server.i386 0:5.0.58-1.el4.centos set to be updated --> Running transaction check --> Processing Dependency: libmysqlclient.so.15 for package: mysql-server --> Processing Dependency: libmysqlclient.so.15(libmysqlclient_15) for package: mysql-server --> Processing Dependency: libmysqlclient_r.so.15 for package: mysql-server --> Processing Dependency: libmysqlclient_r.so.15(libmysqlclient_15) for package: mysql-server --> Processing Dependency: mysql = 5.0.58-1.el4.centos for package: mysql-server --> Finished Dependency Resolution Error: Missing Dependency: libmysqlclient.so.15 is needed by package mysql-server Error: Missing Dependency: libmysqlclient.so.15(libmysqlclient_15) is needed by package mysql-server Error: Missing Dependency: libmysqlclient_r.so.15 is needed by package mysql-server Error: Missing Dependency: libmysqlclient_r.so.15(libmysqlclient_15) is needed by package mysql-server Error: Missing Dependency: mysql = 5.0.58-1.el4.centos is needed by package mysql-server I then did yum update mysql and it update the current MySQL files but on the same version and not to 5. How do I get libmysqlclient.so.15 installed if I have libmysqlclient.so.10 installed because it looks like that is what it needs to be able to complete or at least go through my upgrade. Thanks, T ___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
Re: [CentOS] Upgrading MySQL from 4.1 to 5
Tito Valentin wrote: I am trying to upgrade MySQL on CentOS 4.5 but having a hard time. I need to go from MySQL 4.1 to 5. I downloaded the following two files: mysql-server-5.0.58-1.el4.centos.i386.rpm mysql-5.0.48-2.el4.centos.i386.rpm I tried to do: yum install mysql-server-5.0.58-1.el4.centos.i386.rpm The command to use here would be rpm -Uvh, as these packages are not in the yum system. You would need to uninstall the current mysql first, however - and to migrate any data, you need to use mysqldump --all --opt before that, and then import it back after 5.x is installed. Last time I checked, you could not use the same database files for different major versions of MySQL - I could be wrong on this point, however. -- Cheers, Morten ___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
Re: [CentOS] Upgrading MySQL from 4.1 to 5
If I am going to run "rpm -Uvh" then why would I need to remove the current mysql server? If I remove the current mysql, shouldn't I run "rpm -ivh" instead? Thanks for the help so far. On Tue, Apr 15, 2008 at 6:24 PM, Morten Nilsen <[EMAIL PROTECTED]> wrote: > Tito Valentin wrote: > > > I am trying to upgrade MySQL on CentOS 4.5 but having a hard time. I > > need to go from MySQL 4.1 to 5. I downloaded the following two files: > > > > mysql-server-5.0.58-1.el4.centos.i386.rpm > > mysql-5.0.48-2.el4.centos.i386.rpm > > > > I tried to do: > > > > yum install mysql-server-5.0.58-1.el4.centos.i386.rpm > > > > The command to use here would be rpm -Uvh, as these packages are not in > the yum system. > > You would need to uninstall the current mysql first, however - and to > migrate any data, you need to use mysqldump --all --opt before that, and > then import it back after 5.x is installed. > > Last time I checked, you could not use the same database files for > different major versions of MySQL - I could be wrong on this point, however. > > -- > Cheers, > Morten > ___ > CentOS mailing list > CentOS@centos.org > http://lists.centos.org/mailman/listinfo/centos > ___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
Re: [CentOS] Upgrading MySQL from 4.1 to 5
Tito Valentin wrote: If I am going to run "rpm -Uvh" then why would I need to remove the current mysql server? If I remove the current mysql, shouldn't I run "rpm -ivh" instead? If a package isn't already installed -U does the same as -i. In most cases you can use -U without bothering to check if one is already installed or not. -- Les Mikesell [EMAIL PROTECTED] ___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
Re: [CentOS] Upgrading MySQL from 4.1 to 5
Gotcha!...thanks for that info. On Tue, Apr 15, 2008 at 7:33 PM, Les Mikesell <[EMAIL PROTECTED]> wrote: > Tito Valentin wrote: > > > If I am going to run "rpm -Uvh" then why would I need to remove the > > current mysql server? If I remove the current mysql, shouldn't I run "rpm > > -ivh" instead? > > > > If a package isn't already installed -U does the same as -i. In most > cases you can use -U without bothering to check if one is already installed > or not. > > -- > Les Mikesell > [EMAIL PROTECTED] > > > ___ > CentOS mailing list > CentOS@centos.org > http://lists.centos.org/mailman/listinfo/centos > ___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
Re: [CentOS] Upgrading MySQL from 4.1 to 5
I still have problems installing even after I have removed the old mysql: [EMAIL PROTECTED] tmp]# rpm -Uvh mysql-5.0.48-2.el4.centos.i386.rpm error: Failed dependencies: libmysqlclient.so.15 is needed by mysql-5.0.48-2.el4.centos.i386 libmysqlclient.so.15(libmysqlclient_15) is needed by mysql-5.0.48-2.el4.centos.i386 mysql-libs = 5.0.48-2.el4.centos is needed by mysql-5.0.48-2.el4.centos.i386 [EMAIL PROTECTED] tmp]# rpm -Uvh mysql-server-5.0.58-1.el4.centos.i386.rpm error: Failed dependencies: libmysqlclient.so.15 is needed by mysql-server-5.0.58-1.el4.centos.i386 libmysqlclient.so.15(libmysqlclient_15) is needed by mysql-server-5.0.58-1.el4.centos.i386 libmysqlclient_r.so.15 is needed by mysql-server-5.0.58-1.el4.centos.i386 libmysqlclient_r.so.15(libmysqlclient_15) is needed by mysql-server-5.0.58-1.el4.centos.i386 mysql = 5.0.58-1.el4.centos is needed by mysql-server-5.0.58-1.el4.centos.i386 I can't find that library anywhere to install it On Tue, Apr 15, 2008 at 7:36 PM, Tito Valentin <[EMAIL PROTECTED]> wrote: > Gotcha!...thanks for that info. > > > On Tue, Apr 15, 2008 at 7:33 PM, Les Mikesell <[EMAIL PROTECTED]> > wrote: > > > Tito Valentin wrote: > > > > > If I am going to run "rpm -Uvh" then why would I need to remove the > > > current mysql server? If I remove the current mysql, shouldn't I run "rpm > > > -ivh" instead? > > > > > > > If a package isn't already installed -U does the same as -i. In most > > cases you can use -U without bothering to check if one is already installed > > or not. > > > > -- > > Les Mikesell > > [EMAIL PROTECTED] > > > > > > ___ > > CentOS mailing list > > CentOS@centos.org > > http://lists.centos.org/mailman/listinfo/centos > > > > ___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
Re: [CentOS] Upgrading MySQL from 4.1 to 5
On Tue, Apr 15, 2008 at 7:53 PM, Tito Valentin <[EMAIL PROTECTED]> wrote: > I still have problems installing even after I have removed the old mysql: > > [EMAIL PROTECTED] tmp]# rpm -Uvh mysql-5.0.48-2.el4.centos.i386.rpm > error: Failed dependencies: > mysql-libs = 5.0.48-2.el4.centos is needed by > mysql-5.0.48-2.el4.centos.i386 You need mysql-libs-5.0.48-2.el4.centos.i386.rpm If you read the above message with attention, you'll see it's quite explicit there what's the missing dependency. You'll probably have to upgrade all RPMs at once, so run rpm -Uvh and then pass all the rpms as parameters on the same line. HTH, Filipe ___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
Re: [CentOS] Upgrading MySQL from 4.1 to 5
Tito Valentin wrote: Hello All, I am trying to upgrade MySQL on CentOS 4.5 but having a hard time. I need to go from MySQL 4.1 to 5. I downloaded the following two files: mysql-server-5.0.58-1.el4.centos.i386.rpm mysql-5.0.48-2.el4.centos.i386.rpm You do notice, those are two different versions? one is 5.0.58-1 and the other 5.0.48-2, you can't mix these. and, as others have said, you need more RPMs than just that. ___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
Re: [CentOS] Upgrading MySQL from 4.1 to 5
On Tue, Apr 15, 2008 at 3:19 PM, Tito Valentin <[EMAIL PROTECTED]> wrote: > > I am trying to upgrade MySQL on CentOS 4.5 but having a hard time. I need > to go from MySQL 4.1 to 5. Having gone through this process about 7 months ago: It's not recommended to do a "binary upgrade", that is, to simply install the newer mysql server and attempt to continue using the same database files. Depending on which storage engines you're using, it can fail rather spectacularly. Instead you should: - stop all clients accessing the mysql 4 server - flush tables and run a full mysqldump - shut down the mysql 4 server - make a backup of /var/lib/mysql - completely remove /var/lib/mysql - remove mysql 4 and install 5 (you can do this in one operation with "rpm -Uvh ...") - start up the mysql 5 server and configure root password etc. - reload the dump from the first step - follow the instructions in the online mysql documentation to update grants etc. Also pay careful attention to the changes in timestamp column behavior, default characters sets and collations, etc. There's extensive documentation on the mysql website, but it's not really all in one place and may take some digging. ___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos