See the corresponding tip in the
section ???Useful mysql Tips??? for more information about this option.
676 CHAPTER 27 ?– THE MANY MYSQL CLIENTS
??? --vertical, -E: Causes mysql to display all query results in a vertical format.
This format is often preferable when you??™re working with tables that contain
several columns. See the corresponding tip in the section ???Useful mysql Tips???
for more information about this option.
??? --xml, -X: Causes all results to be output in XML format. See the corresponding
tip in the section ???Useful mysql Tips??? for more information about this option.
The mysqladmin Client
The mysqladmin client is used to carry out a wide array of administrative tasks, perhaps
most notably creating and destroying databases, monitoring server status, and shutting
down the MySQL server daemon. Like mysql, you need to pass in the necessary
access credentials to use mysqladmin.
For example, you can examine all server variables and their values, by executing:
%>mysqladmin -u root -p variables
Enter password:
If you??™ve supplied valid credentials, a long list of parameters and corresponding
values will scroll by. If you want to page through the results, you can pipe this output
to more or less if you??™re using Linux, or more if you??™re using Windows.
mysqladmin Commands
While mysql is essentially a free-form SQL shell, allowing any SQL query recognized
by MySQL, mysqladmin??™s scope is much more limited, recognizing a predefined set of
commands, many of which are introduced here:
??? create databasename: Creates a new database, the name of which is specified by
databasename.
Pages:
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773