Print Add to Favorites   Back
MySQL Admin Commands


Article Information
Article ID: 79
Author: Support @ CCS
Created: 11/15/2007
Modified: 11/15/2007
Views: 3,878
CCS-Leeds-Logo

MySQL Admin Commands

Just a useful reminder of a few MySql Admin Commands:

 

* Statistics: [prompt]$ mysqladmin version
* List database environment: [prompt]$ mysqladmin variables
* Show if database is running: [prompt]$ mysqladmin ping
* Show databases available:

[prompt]$ mysqlshow

OR

mysql> SHOW DATABASES;

* Delete database: mysql> drop database databasename;
* Show list of active threads in server:

[prompt]$ mysqladmin -h localhost -u root -p processlist

* Delete a database: [prompt]$ mysqladmin drop database-name
* Execute SQL from Linux command line interface:
[prompt]$ mysql -h localhost -u root -p -e “select host,db,user from db” mysql
* Execute SQL command file from Linux command line interface:

[prompt]$ mysql -h localhost -u root -p database-name

 

For details of the options available for  CCS Cheap Web Hosting click here


This URL: http://tickets.ccsleeds.co.uk/Customer/KBArticle.aspx?articleid=79