mysql etoys < test.txt | more
where test.txt contains something like:
desc addresses;
desc members;
Or try
mysqldump dbname addresses members orders -d | more
That'll give you the data definition language without any data for each
table. (addresses, members and orders in the above example)
If you're not on the db server itself you'll have to add something like
mysqldump -h hostname -u root -P [port] -p[passwd] dbname ...and then the
rest of the above parameters
Hope that helps.
Mark.
-----Original Message-----
From: Don [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 24, 2001 4:41 PM
To: msql list
Subject: Command line utility?
Is there a user friendly utility that would allow one to display the
structure of a table or view the contents of one? Of course, this can
be done from within "mysql -p" but there is no way to pause at each
screen so most of my information scrolls off of the screen.
I was trying with "mysqladmin <options> | more" but no success and I
don't see any examples in the manual. Example of what I tried was:
mysqladmin my_db my_table | more
but all I get is:
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'webmail@localhost' (Using password:
NO)'
Thanks,
Don
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
