List:General Discussion« Previous MessageNext Message »
From:Curtis Maurand Date:March 26 2006 8:18pm
Subject:Re: How to take dump of a query instead of table / database
View as plain text  
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:curtis@stripped
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" <mail@stripped> 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
>
>
>
>
Thread
How to take dump of a query instead of table / databaseabhishek jain24 Mar
  • Re: How to take dump of a query instead of table / databaseDominik Klein24 Mar
  • Re: How to take dump of a query instead of table / databasePure Web Solution24 Mar
    • Re: How to take dump of a query instead of table / databaseCurtis Maurand26 Mar