Virtualmin MYSQL phpmyadmin

7 posts / 0 new
Last post
#1 Tue, 09/11/2007 - 11:57
mpolat

Virtualmin MYSQL phpmyadmin

Hello After an upgrade I have trouble with mysql. Some application does not work, because the db is not working properly.

PHPMYAdmin says that the mysql client version is 4.1.2 and the the server 3.2.23 When I check with webmin It shows me that the version of mysql 4.1.2 is.

Please help. I do not want to reinstall the entire server...

Thanks

Tue, 09/11/2007 - 12:09
Joe
Joe's picture

<div class='quote'>I do not want to reinstall the entire server...</div>

Why on earth would you reinstall the entire server? That makes no sense. ;-)

<div class='quote'>After an upgrade I have trouble with mysql. Some application does not work, because the db is not working properly.

PHPMYAdmin says that the mysql client version is 4.1.2 and the the server 3.2.23
When I check with webmin It shows me that the version of mysql 4.1.2 is.</div>

Ok, so you've left out a lot of important details in this story.

How did you do this &quot;upgrade&quot;? OS standard packages or from a tarball build? Were you replacing a package with a tarball build (bad idea, by the way, if you don't have experience with that kind of thing)? Did you do a dump of your 3.x databases and restore them into 4.x (this is the only safe way to do a major revision upgrade of MySQL)?

What OS are you running?

You're probably actually lucky that the upgrade didn't happen the way you planned, if you haven't gone through the proper procedures to change major revisions in MySQL. You could seriously damage your databases (more likely MySQL would refuse to work with them--at least I hope so).

Anyway, it sounds like what's happening is that you've installed MySQL 4 somewhere other than where MySQL 3 is installed, and MySQL 3 (the server) is still running. You've updated PHPMyAdmin to point to the MySQL 4 installation, but it's not the server that is running. So, basically, you haven't actually upgraded, you've just installed MySQL 4 somewhere on the system without actually starting up the server and importing your data into it. MySQL 3 is still running, and the MySQL 3 client is still probably somewhere on the system--you'll need it to dump your old databases.

--

Check out the forum guidelines!

Tue, 09/11/2007 - 22:33 (Reply to #2)
mpolat

hello
Thanks for the response. I am using the latest phpMyAdmin.
phpMyAdmin - 2.11.0

Regards

Tue, 09/11/2007 - 22:19
mpolat

Thanks for the response.
I am runnung the Redhat EL4. Yesterday there was an infos that there are some new updates when I logged in webmin. I did the upgrades.
Could you please advice me how to act is this case?

Regards

Pol

Tue, 09/11/2007 - 22:28 (Reply to #4)
Joe
Joe's picture

OK, so phpMyAdmin is drunk. RHEL4 only ever had MySQL 4.1.x, assuming you've always used RHEL packages, and there's no way for a MySQL 3 client to exist on that system (again, assuming you've always only ever used RHEL provided packages).

I'm not very familiar with phpmyadmin, so I'm not sure, but I'm guessing it's just mis-configured. I'll do a local test install and see if I can figure out how you're getting the error you're getting from it. (In the meantime, what are you trying to accomplish with phpMyAdmin? The Webmin MySQL module is more powerful in almost every way.)

--

Check out the forum guidelines!

Wed, 09/12/2007 - 04:26
mpolat

I uninstalled phpmyadmin and installed it again. Now it shows the correct mysql server 4.1.2. client is same.

Ich have had application that allows to upload files. Now I can not upload add any files. Submit does not work...

Pol

Thu, 09/13/2007 - 07:45
mpolat

Hi

I have had problems with all databases. It was not possible to uploads docs...

I reinstalled the Redhat and virtualmin. In this way my problem has been solved.

Thanks
Pol

Topic locked