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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]