But changing the active DB on an open connection is a trivial operation in MySQL. I'd still suggest using mysql_select_db(); mysql_query(); instead of tying up two connections for this.
-Rasmus On Mon, 22 Apr 2002, Matthew Walker wrote: > They're not quite identical, in my mind at least. They use different DBs > on the same host. I'm writing a script to translate a bunch of data in > one DB into a new DB format. We run shopping cart software, and just > overhauled our system. To minimize the downtime for the transition, I > need a PHP script to do the data copying. I was hoping to just have > multiple connections open, and read from one, and write to the other. > *blinks* > > *light goes on over head* > > Just figured out how I can still do that. (Another user for the second > connection) > > *runs off to right code again* > > Matthew Walker > Senior Software Engineer > ePliant Marketing > > > -----Original Message----- > From: Rasmus Lerdorf [mailto:[EMAIL PROTECTED]] > Sent: Monday, April 22, 2002 5:53 AM > To: Matthew Walker > Cc: Markus Fischer; [EMAIL PROTECTED] > Subject: RE: [PHP-DEV] Major Bug in multiple MySQL Connections? > > Just curious, why do you need multiple identical connections? > > On Mon, 22 Apr 2002, Matthew Walker wrote: > > > Ahhh. Delighted to hear that. I'll upgrade as soon as there's an RPM > > available for RH7.1. (I'd compile it, but I always forget something, > and > > I can't afford downtime on that server.) > > > > Thanks for everyone's help. May I never need it again. (I only mail > > developers when it's a /major issue.) > > > > Matthew Walker > > Senior Software Engineer > > ePliant Marketing > > > > > > -----Original Message----- > > From: Markus Fischer [mailto:[EMAIL PROTECTED]] > > Sent: Monday, April 22, 2002 6:50 AM > > To: Matthew Walker > > Cc: [EMAIL PROTECTED] > > Subject: Re: [PHP-DEV] Major Bug in multiple MySQL Connections? > > > > Hello Matthew, > > > > you should read my commect on this bug report too. 4.2.0 > > which will be released soon contains already a workaround for > > this limitation. > > > > - Markus > > > > On Mon, Apr 22, 2002 at 06:41:44AM -0600, Matthew Walker wrote : > > > I believe I may have found a major bug in the use of multiple MySQL > > > connections. Please see my bug report at HYPERLINK > > > > > > "http://bugs.php.net/bug.php?id=16730"http://bugs.php.net/bug.php?id=167 > > > 30. If I?m wrong about this, please tell me how to fix it. This is a > > > showstopper bug for the software I?m currently working on. > > > > > > Matthew Walker > > > Senior Software Engineer > > > ePliant Marketing > > > > > > > > > --- > > > Outgoing mail is certified Virus Free. > > > Checked by AVG anti-virus system (http://www.grisoft.com). > > > Version: 6.0.345 / Virus Database: 193 - Release Date: 4/9/2002 > > > > > > > > > -- > > > PHP Development Mailing List <http://www.php.net/> > > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > -- > > Please always Cc to me when replying to me on the lists. > > GnuPG Key: http://guru.josefine.at/~mfischer/C2272BD0.asc > > "Mind if I MFH ?" "What QA did you do on it?" "the usual?" "ah... none > > :)" > > > > > > --- > > Outgoing mail is certified Virus Free. > > Checked by AVG anti-virus system (http://www.grisoft.com). > > Version: 6.0.345 / Virus Database: 193 - Release Date: 4/9/2002 > > > > > > -- > > PHP Development Mailing List <http://www.php.net/> > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > -- > PHP Development Mailing List <http://www.php.net/> > To unsubscribe, visit: http://www.php.net/unsub.php > > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.345 / Virus Database: 193 - Release Date: 4/9/2002 > > -- PHP Development Mailing List <http://www.php.net/> To unsubscribe, visit: http://www.php.net/unsub.php
