homepage Welcome to WebmasterWorld Guest from 50.16.130.188
register, free tools, login, search, subscribe, help, library, announcements, recent posts, open posts,
Pubcon Platinum Sponsor 2014
Home / Forums Index / Code, Content, and Presentation / PHP Server Side Scripting
Forum Library, Charter, Moderators: coopster & jatar k

PHP Server Side Scripting Forum

    
Possible to mysql and mysqli connections during conversion?
ianevans




msg:4628650
 6:44 pm on Dec 7, 2013 (gmt 0)

I have a common include file in my php files that connects via mysql_connect to my DB.

I'm using the mysqli converter tool to finally make the jump to using mysqli instead of the deprecated mysql driver.

To minimize my downtime, is it safe to assume that I can run both a mysql AND a mysqli connection to the DB while I run the converter?

Thanks

 

JD_Toims




msg:4628929
 8:00 am on Dec 9, 2013 (gmt 0)

I don't think it should be an issue, but idk for sure -- I used a bulk find/replace when I switched, so the switch for me was find/replace, upload, up-and-running -- Personally, in your situation I'd throw up a test subdomain and check it out to see what happened if I used both driver types in the file. Then there's no question or possible "goofy glitches" between different hosts and server settings.

penders




msg:4628991
 3:24 pm on Dec 9, 2013 (gmt 0)

...is it safe to assume that I can run both a mysql AND a mysqli connection to the DB while I run the converter?


Are you applying this "converter tool" to a live / "whilst it is being accessed" website?!

ianevans




msg:4629087
 10:25 pm on Dec 9, 2013 (gmt 0)

Not to the whole site...I was just going to do a private test directory. As it is...I ended up just putting the site in maintenance mode and did the conversion in about a minute. Now will go back and do tweaks for better performance, etc.

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / PHP Server Side Scripting
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved