Thursday, August 29, 2013

MySQL - Using mysqladmin to do some jobs outside the mysql terminal

You can do some mysql jobs outside the mysql terminal using mysqladmin util:

For example:

1. Drop a table:

$ mysqladmin -u myuser -p'myuser_password' -f drop mytable

The '-f' parameter is to proceed the command without prompting (y/N).

2. Create a new table:

$ mysqladmin -u myuser -p'myuser_password' create my_newtable


For more use cases,  read this article: http://www.tecmint.com/mysqladmin-commands-for-database-administration-in-linux/