Name
msqladmin
Synopsis
msqladmin [options
]command
Performs operations that affect the database server as a whole. This utility is used to shut down the database server, add and delete entire databases, and other administrative functions.
Commands
- copy database newdatabase
Create an exact duplicate of a database under a different name.
- create database
Create a new blank database.
- drop database
Remove a database and destroy its contents.
- move database newdatabase
Rename a database.
- reload
Reread the configuration files.
- shutdown
Terminate the database server.
- stats
Display statistics about the database server. This shows who is currently connected to the server, what database they are using and how many queries they have sent, among other things.
- version
Display the version information for the database server.
Options
- -f file
Use an alternate configuration file.
- -h hostname
Connect to a database server on a remote host.
- -q
Do not ask for verification of commands.
Get MySQL and mSQL now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.