MySQL Admin Commands and MySQl Administration
Web Hosting Tutorials, Web Hosting August 6th, 2007MySQL 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
* 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
By hostingcomments.com
WordPress database error: [Table 'wp_comments' is marked as crashed and should be repaired]
SELECT * FROM wp_comments WHERE comment_post_ID = '118' AND comment_approved = '1' ORDER BY comment_date
