Jaime Crespo Rincón schrieb: > 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]" > > I prefer mysql -BAN .... It has the advantage that you do not need to fiddle with headers etc.
re, wh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
