Creating a different version MySQL database...

L

lazywolfy

Verified User
Joined
Sep 8, 2007
Messages
18
Hi, I'm trying to install vsp stats for my clan forum...it's basically a web page that shows kills/deaths/otherstuff based on gameserver log files it retrieves from my gameserver....

problem is, vsp is not compatible with a 5.x dbase and needs a v4.x mysql version database instead.

How can I find my mysql version information and if in fact it is 5.x, how can I create a 4.x database without messing anything else up?

Thanks
 
Code: 
# mysqld --version
and how exactly would I go about doing that...where or how would I use that command?
 
you have to login to your server through ssh. If not, you can login to your DirectAdmin as admin level and go to "System Information", everything is listed there.
 
Oh ok...thx....this is what's there:
Code: 
MySQL 5.0.19 Running

So now my question is how do I go about using that command line above that jlasman mentioned? :confused:
I'm guessing thru phpmyadmin somehow, but I've never used that. -_-

btw: Just to clear up any confusion on my end....I already have a functional forum that's running on mysql 5.x, can I even have different version of mysql databases running simultaneously? Or am I misunderstanding this whole thing? Thx.
 
Last edited:
You already know the version number; no need to run the command I posted; it simply tells you the version number and exits.

Instructions for downgrading versions of MySQL may be found here. Note that you'd be going from 5.x to 4.x, so you may have to backup and restore your databases as explained on that page.

If you're not familiar with how to even understand shell commands, you might want to hire someone to do it for you.

But before you do, you should find out how you ended up using 5.x. I haven't done an install in a while, but the DirectAdmin page here explains you get a choice. Why was 5.x chosen? Did someone need one of it's features?

Jeff
 
I didnt have a choice between version 4.x and 5.x....I ordered the webspace thru my gameserver provider and it already came with mysql 5.x!

I'll try backing up my databases and give this downgarde a decent try. wish me luck! :confused:
 
....so what if I didn't have any mysql tables at all and wanted to downgrade the mysql version from 5.x to 4.x.....how can I do that...or where can I read about how to do that? It should be easier right cuz i wouldn't have to do a mysqldump on current tables and all that mess???

I have a separate webspace account (small & very cheap..$1/month) that I basically just use for file storage and such that I want to try downgrading the mysql version on. Unfortunately my provider doesn't offer any kind of support (which explains the cheap price) or else I'd just ask them to downgrade the version.

thanks
 
Last edited:
Let's understand something.

You can't downgrade your MySQL version if all you have is an account on a server.

You can only downgrade MySQL if you have full root rights to the server.

If you have root control of your server but it's a VPS, then you may or may not be able to change the MySQL version, depending on how your provider does their mount points.

Some VPS systems all share the same daemon installs between users.

Jeff
 
thats what I was afraid of....what I should've asked for is instructions to change the mysql version so I can pass them onto my provider if at all possible. Thanks

maybe I can convicne them to give it a try, but then they'd have to change the version for everyone they've given accounts to which I'm not sure they'd be cool with that. oh well. thanks for your help anyways.
 
when you say vsp needs ver4 sql what do you mean?

Have you tried creating the tables within the database using the mysql-create.sql file

when I set it up for cod a few years ago thats what I did

if you want you can msn me @ [email protected]
 
when you say vsp needs ver4 sql what do you mean?
Click to expand...
what I mean is that VSP requires MySQL v4.x and is not compatible with MySQL 5.x

Have you tried creating the tables within the database using the mysql-create.sql file
Click to expand...
nope...the only thing I've tried is installing vsp stats with mysql 5.x running and so far I can see the stats but I think their innacurate, and the mini-awards don't show up on the left which is a common error when using an incompatible version of mysql.

I'd send you a pm but I don't have msn...xfire maybe. :rolleyes:
 
have you checked out the website

there was something on the forums about php5 & mysql compatability
 
Ya I checked out the site but they say it's not compatible with mysql 5.x but I can't tell if people have found a workaround or not, even if there is...........
 
You must log in or register to reply here.
Back
Top