Hey everyone, I'm hoping I'm not the only one who has had this issue before.
Basically my "PROD" forum is being hosted using php5 and MySQLi. The site is running fine...no issues. I've decided to make a "DEV/UAT" site. I had some free space on another hosting service. Unfortunately, this hosting service uses php4 e(extentions are .php) and MySQL. I loaded VBulletin on "DEV" using .php insteadof .php5. I have the site loaded fine into "DEV" however, when I tried to do a dump from "PROD" into "DEV" I ran into issues. Obviously this didn't work becasue although the database came up OK in "DEV" all the links on my site now refrence .php5. I thought I would be slick and open the "dump" file in Word Pad and do a find/replace on .php5 and replace it with .php. Well, this worked I got all my threads and forums up, but I lost a lot all of my nav bars and other things here and there. There must have been "logic" code in the database and I changed all .php5 refrences and I shouldn't have.
This leave me with this questions....
Is there anyway to import a .php5 database into a .php installation and have it work properly?? If so is there a tool/script to convert the table data??
Pleae let me know, if this doesn't work I think I'm going to have to scrap the whole idea.
Im sorry but that doesnt make any sense. Vbulletins PHP code is cross portable between PHP4/5 and should not have anything to do with your problems.
However SQL code ported between 1 mySQL server setup and other very often will create problems if they are parts of the SQL code that are incompatible with each other.