Here's a dumb question, but I am unable to find the relevant spot in the
online docs, and am coming to the group asking my (pathetically) little dumb
question (which I should know the answer to!)
I can take data into a database from an sql file with:
mysql -u USER -p DBNAME < dump.sql
But how do I send data out of an sql table, to an sql-type text file? Don't
I simple change the redirection symbol from "less than," to "greater to," as
follows:
mysql -u USER -p DBNAME dump.sql
Whenever I do this, however, it just hangs (even on tiny databases, so I
must have something syntactically wrong here). Can anyone point me in the
right direction on this please? Thanks, Ike