Downgrade

[hadog]

Hi

I am runing vb3.5, no problems.

Is it possible to downgrade mysql?? From 5 to 4 and not have any problems?

[Marco van Herwaarden]

Originally Posted by hadog

Hi

I am runing vb3.5, no problems.

Is it possible to downgrade mysql?? From 5 to 4 and not have any problems?

Unfortunatly there is a bug in MySQL that will prevent you to downgrade from:
- 5.x => 4.x
- 4.1 => 4.0 or 3.x

Best is to stick with the current major version. If you really have no other option (ie. new host don't support your old version and can not upgrade), then there is an option, but it requires some (a lot??) manual work, and no 100% garantuee.

[hadog]

HI
Well that figures!!

Can I do this.....install mysql 4 on a machine. Then dump/export the vb3.5 database that is in mysql 5 (on another machine) then import that database into the version 4??

My reason is that I have a progm that will only run on version 4... I want to keep my present vb setup and have this other progm too.

[Marco van Herwaarden]

Originally Posted by hadog

Can I do this.....install mysql 4 on a machine. Then dump/export the vb3.5 database that is in mysql 5 (on another machine) then import that database into the version 4??

No, you can not. That is just what this whole bug (MySQL don't call it a bug, but a limitation to the functionality ) is about.

To migrate to a previous version, you will need to use the compatible parameter. Once you use the compatible parameter, there will be no information about AUTO INCREMENT columns in your dump anymore, making the database unusable for vBulletin after a restore (see MySQL bug: http://bugs.mysql.com/bug.php?id=14515)

You can also find threads about this at vbulletin.com.