select <criteria> into outfile <name of output file>
The path for the output file must be writeable by the user underwhich
mysql is running.
--
Curtis Maurand
mailto:[EMAIL PROTECTED]
http://www.maurand.com
On Fri, 24 Mar 2006, Pure Web Solution wrote:
you can manipulate mysqldump using the where clause (check the man)
You might find the following usefull, but would not be so good for restoring.
from the command line....
mysql --database=db_name --execute="select * from users" -u username
-ppassword > output.file
Pure Web Solution
http://www.purewebsolution.co.uk
PHP, MYSQL, Web Design & Web Services
"abhishek jain" <[EMAIL PROTECTED]> wrote:
Dear Friends,
I need to take the backup of a query, is it possible.
If yes how.
--
Regards
Abhishek jain
www.smsengine.co.uk
Pure Web Solution
http://www.purewebsolution.co.uk
PHP, MYSQL, Web Design & Web Services
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
