On Thu, 3 Jun 2004 12:11 , McKeever Chris <[EMAIL PROTECTED]> sent: > > >On Thu, 03 Jun 2004 12:07 , gerald_clark [EMAIL PROTECTED]> sent: > >> >> >>McKeever Chris wrote: >> >>>MYSQL 4.0.13 >>> >>>I must be doing something wrong - I am trying to do a mysql dump and it keeps >>>yelling that tables dont exist whenever I put a where clause >in.. >>>it runs fine when I leave the where clause off - any help here? >>> >>>mysqldump -u root -p hotswap EmailDatabase_k EmailMessage_k >>>"--where=EmailDatabase_k.Account='kvanoni' and >>>EmailDatabase_k.id=EmailMessage_k.id" > kvanoni.db >>> >>mysqldump -u root -p hotswap EmailDatabase_k EmailMessage_k >>--where="EmailDatabase_k.Account='kvanoni' and >>EmailDatabase_k.id=EmailMessage_k.id" > kvanoni.db >> > >gerald thanks for the response - but > >that is what I had - different quote placement - but same results nonetheless .. >does this dual table/where clause work for you > >>
this is what the output is - it cant pull the where from the single table - -- -- Dumping data for table `EmailDatabase_k` -- -- WHERE: EmailDatabase_k.Account='kvanoni' and EmailDatabase_k.id=EmailMessage_k.id >>> >>>if I make it just a single clause, it then says that table doesnt exist etc... >>> >>>as I said, I take out the where and it works...thanks >>> >>>------------------------------------------- >>>Chris McKeever >>>If you want to reply directly to me, please use cgmckeever--at--prupref---dot---com >>>http://www.prupref.com";>www.prupref.com> >>>Prudential Preferred Properties >>>http://www.prupref.com";>Chicago and Illinois NorthShore Real Estate Experts >>> >>> >>> >>>---- Prudential Preferred Properties www.prupref.com >>>Success Driven By Results >>> Results Driven By Commitment >>> Commitment Driven By Integrity >>> We Are Prudential Preferred Properties >>> >>> >>> >>> >> >> >> > > > >---- Prudential Preferred Properties www.prupref.com >Success Driven By Results > Results Driven By Commitment > Commitment Driven By Integrity > We Are Prudential Preferred Properties > > >-- >MySQL General Mailing List >For list archives: http://lists.mysql.com/mysql >To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > ---- Prudential Preferred Properties www.prupref.com Success Driven By Results Results Driven By Commitment Commitment Driven By Integrity We Are Prudential Preferred Properties -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
