Welcome to WebmasterWorld Guest from 54.147.134.218

Forum Moderators: coopster & jatar k

Message Too Old, No Replies

Possible to mysql and mysqli connections during conversion?

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

Full Member

10+ Year Member

joined:Aug 5, 2003
posts: 230
votes: 5


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
8:00 am on Dec 9, 2013 (gmt 0)

Senior Member

WebmasterWorld Senior Member Top Contributors Of The Month

joined:July 19, 2013
posts:1097
votes: 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.
3:24 pm on Dec 9, 2013 (gmt 0)

Senior Member

WebmasterWorld Senior Member penders is a WebmasterWorld Top Contributor of All Time 5+ Year Member Top Contributors Of The Month

joined:July 3, 2006
posts: 3123
votes: 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?!
10:25 pm on Dec 9, 2013 (gmt 0)

Full Member

10+ Year Member

joined:Aug 5, 2003
posts: 230
votes: 5


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.
 

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members