5 Oct
2010
5 Oct
'10
9:07 a.m.
On 04-10-2010 15:00:58 +0200, Sjoerd Mullender wrote:
On 2010-10-04 14:17, Mark Bucciarelli wrote:
Is there a way to user mclient to dump the db schema without dumping the data?
I tried creating a one line SQL file with
\d <tablename>
and piping to mclient stdin, but it didn't work.
Instead of mclient, use msqldump --describe
alternatively your original approach didn't work, because the \X commands are only recognised in interactive mode. If you'd force the client to go interactive (-i), it should recognise the \d command.