On Thu, 3 Jun 2004 11:54 , McKeever Chris <tech-mail@stripped> sent:
>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
>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
>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
I think it has something to do with the dual tables, and the query - so now the question
becomes how can I do something like what I am doing?
>If you want to reply directly to me, please use cgmckeever--at--prupref---dot---com
>Prudential Preferred Properties
>http://www.prupref.com">Chicago and Illinois NorthShore Real Estate Experts
>---- Prudential Preferred Properties www.prupref.com
>MySQL General Mailing List
>For list archives: http://lists.mysql.com/mysql
>To unsubscribe: http://lists.mysql.com/mysql\?unsub=1
---- Prudential Preferred Properties www.prupref.com