Server :: Migrating MySql DB From Version 4.0 To Version 5.1
Nov 29, 2010
I want to upgrade mediawiki software from version 1.6 to version 1.16 . The newer version is supposed to be installed on another server. I am trying to migrate the old mediawiki mysql database with no success.
Installed Zend Server CE on 10.04 - install mostly fine. But phpmyadmin shows this error; "Your PHP MySQL library version 5.0.83 differs from your MySQL server version 5.1.41" I have followed the Zend online docs and used a DEB install. Why would these versions be different?how do I fix it so that the two are in sync?
i would like to upgrade my centos 5.3 with the oldest update from repository. (about 224 update)I would like to update all the system but keep freezed php and mysql.
I have recently installed centos 5.6an app i have needs to run php 5.3 so i upgraded by adding a repo and using yum install php53*a php -v gives me this.PHP 5.3.3 (cli) (built: Mar 30 2011 13:51:41) Copyright (c) 1997-2010 The PHP GroupZend Engine v2.3.0, Copyright (c) 1998-2010 Zend Technologiesi also need mysql 5.1 so i picked a repo that had the 5.1 version of mysql in it and um install mysql*which gives me this.[root@localhost var]# mysql -Vmysql Ver 14.14 Distrib 5.1.52, for redhat-linux-gnu (i686) using readline 5.1and then tri to run my app and it failsthe only difference i see between the server that is current working and the new one is in the phpinfo file.in the mysql section of the working one it says Client API version. 5.1.xin the new server install it says the following which is still point to the client api or 5.0
mysql MySQL Supportenabled Active Persistent Links 0
Summary: Does a discrepancy between MySQL client library 5.0.x and MySQL server of 5.1.50 cause "inconsistent behavior", as reported by phpMyAdmin? The longer version: Windows Sysadmin taking the plunge into Linux. I tried to spare you all the rookie questions and did a fair bit of reading. I'm rather happy I was able to get CentOS 5.5 installed and running, configured iptables, got the kernel updated, Apache, MySQL and PHP installed. Then upgraded PHP to 5.2 after I figured out how repos and priorities work.
I got phpMyAdmin installed and running, then decided to upgrade from 2.11 to 3.3.7 but it keeps complaining that my MySQL client libraries are something like 5.0.63, while my server is 5.1.50, and this may cause "inconsistent behavior" or something of the like. So, feeling industrious, I decided to find an updated client.
MySQL-client-community-5.1.50-1.rhel5.i386.rpm
But it wouldn't let me install it as it conflicted with the default mysql-server installation. I also couldn't remove just the old client, to update to a newer one. So I blew away everything mysql on my server and installed the above client
MySQL-server-community-5.1.50-1.rhel5.i386.rpm
and that server file. I'm assuming I'm missing dependencies now as phpMyAdmin claims it can't load the mysql extension. Attempting to 'yum' php-mysql tried to install 'mysql' as a dependency, which immediately conflicted with the files I'd installed. At this point I'm wondering if I'm closing in on successfully installing a version that phpMyAdmin doesn't complain about, or if I should even care that it is complaining and just go back to all the repo versions of everything.
# rpm -e MySQL-shared-community-5.1.50-1.rhel5.i386.rpm error: package MySQL-shared-community-5.1.50-1.rhel5.i386.rpm is not installed
I'm an absolute biginer with UBUNTU witch I just install to start trainning PHP/Mysql. I've instaled UBUNTU Desktop. Is it enough or should I install UBUNTU Server? That is, can I install PHP and MySQL on this DESKTOP version?
Has anyone tried downloading all the different releases of the mysql source code and creating a .sh script to switch between them? Will it work well? I would imagine there would be issues with library linkage and compatibility? The issue I'm having is a client was running mysql 5.0.x and I was on 5.1.x - my tests pass on my server but not on his. Both my development machine and my continuous integration server where the tests run all use the latest. Do I have to purchase a server for every combination of software configuration I want my application to support? Or can it be emulated with virtual machines or something?
Same for PHP. I want to essentially have this happen:
Basically looping thru all combination, would I have to set up a virtual machine? Or would that even work?
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:
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 have CentOS 5.4 installed with lighty and MySQL installed via yum. not a problem. The issue become when I'm having problem with the current mysql that I installed via yum which I believe its currently at version 5.1.42-2. So I'd like to upgrade it to the latest available version of mysql. Except I can't figure out whether to download the generic glibc32 version or just get the RHEL5 version or find the mysql enterprise version somewhere. So, not knowing what I'm doing, I downloaded the RHEL5 version since it's closer to CentOS 5.4. Except for whatever reason the mysqli is not installed or configured properly and I'm not sure how to fix it.
Any suggestion? Everything was working nicely when I used yum to install, except the problem with the version of mysql that's offered in the repository. So I'd like to request a suggestion on how to either somehow upgrade mysql using yum and there's a different repository that I didn't know, or perhaps download a proper latest and greatest mysql, install and have it configured so that mysqli work properly.
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.
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 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?
I have a doubt, may sound funny but wanna know whether it is possible to share DVD drive in windows [version 7] and use it in Linux system [version fedora 12]?
Which LXDE version of Linux has the newest version of Firefox and Open Office included?
I am looking for an iso file, and I am trying to run this off of a live CD for now. So I want a light version of Linux, probably LXDE, or if not, then probably XFCE. But I need a new version of Firefox and OpenOffice included.
Because, I tried burning the customizable NimbleX @ custom.nimblex.net . Pretty good, except it uses Firefox 2, and Open Office 2.3, which are outdated.
And I tried Mint XFCE, which might have been pretty good too, but it had some issue of blanking and requiring relogin after I opened hotmail frequently (user id: mint, password: blank).
The web browser and the word processing program are the most important and essential applications to me.
So are there any Linux versions in LXDE on LiveCD that include newer versions of Firefox (or at least another good browser) and Open Office (oo seems better than abi)? (Again, if no LXDE, perhaps XFCE?)
I just want to download a good version in an iso file, and burn it to a CD and get to work. Like I said the web browser and the word processing program are all important.
So really, what iso/LiveCD versions are the fastest for running on an older system, and yet have the newest browser and word processor included?
I installed debian squeeze on an old computer that I found. (Pentium 4 3.2GHz HT) I installed from the i386 version, but now the uname command shows that its an i686. I don't find many packages that I need using apt-get. Do I need to compile each package I need from source or use dpkg to install the deb of an i386 version?
Can I use the i386 version on this computer rather than the i686 version? Will it cause a signifncant performance decreaes? (I use this computer to mostly do some reading and writing and file storage, no gaming etc.) How do I force the installer to use the i386 version?
i would like to replace my Ubuntu Desktop version with the Netbook version. I dont mind losing my current data on the desktop version but if there is a way for me not too i would love to know
I bought new laptop (VOSTRO 1015) with defalut ubuntu 8.1 linux OS. i need to instal latest ubuntu version, is it possible to override old version with new version if i can over ride old version is there any problems with my laptop.When i palyed MP3 and Videos in movie player one pop message was displayed codec are not available , ubuntu version is out dated.i need to instal latest ubuntu with audio and video drivers
I have installed Ubuntu 10.10 desktop version on my Lenovo L420 laptop. Now my friend told me that if I had installed laptop version on it then it would have recognized events related to laptop like closing down the laptop screen and all.
Q1. Is there any way by which I can upgrade it to laptop version?
I've made a linux app that I'm porting to win32 winth MinGW and MSYS. It's a ticker app that reads then renders a text file to a pixmap (a tall single-line image), then it kind of scrolls the pixmap by drawing a part of it to a drawing_area, using gdk_draw_drawable() within a timeout handler set by g_timeout_add().
The problem is it works fine on linux (the scrolling is really smooth and that's the goal) but the win version is choppy and uses at least 90% of cpu resources (vs 15% with linux) like there is a big performance problem. And I'm not even sure that double buffering is set. Is it related to some mingw config or drawing_area stuff or gtk for win?
Sometimes a kernel image seems to have the same version as the backported kernel image, for example: linux-image-2.6.32-bpo.5-amd64 linux-image-2.6.32-5-amd64
Just got my AW M11x and I am following a thread on installation issues and work around. My question is should I install the desktop version or the Netbook version? Not sure the best location to post, if incorrect please move accordingly Wanting to run gimp, open office, wine to access MS office (use for school) and possibly install photoshop for raw work gimp cant handle.