Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Monty Loree
June 27, 2007, 10:06 pm
rate this thread
I would like to dump the tables in portions so that it's a little
easier to work with...
Can somebody suggest a way to do a mysqldump table query
ie.. mysqldump -u user -p database="MYDATABASE" Query="SELECT * FROM
TABLE WHERE State='NV';"
I'm pretty sure this is possible... I have no idea how to do it.
Thanks in advance.
Re: mysqldump select query
the statement does not look right so i am not as sure as you are;
however, you can run something like this to backup table at a time:
mysqldump -p -u username databasename tablename > tablename.sql
once you run this, it'll ask you for your password, type it in and
voila, you get a text file of a backed up table.
lark -- email@example.com
To reply to me directly, delete "despam".
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum