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
>
>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
><A href="http://www.prupref.com">www.prupref.com</A>
>Prudential Preferred Properties
><A href="http://www.prupref.com">Chicago and Illinois NorthShore Real Estate
> Experts</A>
>
>
>
>---- Prudential Preferred Properties www.prupref.com
>Success Driven By Results
> Results Driven By Commitment
> Commitment Driven By Integrity
> We Are Prudential Preferred Properties
>
>
>
>
