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 > >> >>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]
