Re: How to take dump of a query instead of table / database

2006-03-26 Thread Curtis Maurand
select into outfile 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

Re: How to take dump of a query instead of table / database

2006-03-24 Thread Pure Web Solution
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://ww

Re: How to take dump of a query instead of table / database

2006-03-24 Thread Dominik Klein
I need to take the backup of a query, is it possible. If yes how. man mysqldump: -w|--where= dump only selected records; QUOTES mandatory! Regards, Dominik -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]