2009/10/29 Michael Dykman <mdyk...@gmail.com>: > mysqldump is not really a data manipulation tool.. as the name > implies, it is a dumper. > > What you are trying to accomlish can be done rather elegantly via the > SELECT .. INTO OUTFILE syntax > > http://dev.mysql.com/doc/refman/5.1/en/select.html > > and then loaded into your new structure via LOAD INFILE > > http://dev.mysql.com/doc/refman/5.1/en/load-data.html
Yes, in fact, you can still do it from the command line with mysql command line client: mysql -urxxxt -pxxx db_name -e "SELECT [any, column, you, want] INTO OUTFILE '/var/www/folder/table_name.txt' FROM table_name WHERE [any, filter, you, want] ORDER BY [any, order, you, want]" -- Jaime Crespo MySQL & Java Instructor Warp Networks <http://warp.es> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org