mysql back up probs 1

[snail]

Is it possible to dump a database in to a file from
the mysql client to achieve a similar result as would be gained from using the mysqldump client.

 

[rycamor]

I don't think you can dump a whole database that way, but you can dump individual tables. Just use the SELECT INTO OUTFILE syntax. See

http://www.mysql.com/doc/S/E/SELECT.html

(I don't know if this is available on older versions of MySQL)

Also see the BACKUP TABLE syntax at

http://www.mysql.com/doc/B/A/BACKUP_TABLE.html