vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   Downgrade (https://vborg.vbsupport.ru/showthread.php?t=108517)

hadog 02-21-2006 09:14 AM
Downgrade
 
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 02-21-2006 11:28 AM
Quote:
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 02-21-2006 01:10 PM
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 02-21-2006 01:47 PM
Quote:
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.


All times are GMT. The time now is 06:35 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01465 seconds
  • Memory Usage 1,714KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (4)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete