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]
