[SOLVED] Carry out mysql commands directly from the ubuntu command line interface

mrpurple · 03-10-2011, 04:56 PM

Is it possible to carry out mysql commands directly from the ubuntu cli rather than open mysql?

eg to create a database I would normally type

Code:

user@localhost:~$ mysql -u root -p

then INSIDE the mysql CLI I would type

Code:

mysql> create database db_name;
mysql> quit;

How would I do this (or any other) mysql task directly from the ubuntu CLI?

I want to be able to cut and paste lines and lines of commands into the ubuntu cli and then at a later date write those commands to a sript.sh
I'd rather not write a seperate sql script then import it in my ubuntu cli but if thats the only way then so be it.

hda7 · 03-10-2011, 05:32 PM

You can get commands to mysql by piping in input, or by redirecting input from a file. For example:

Code:

echo "drop db.table" | mysql -u root -p

will drop table "db.table" (mysql should still read passwords from the terminal, though). Similarly

Code:

mysql -u root -p <sqlscript.sql

will read commands from "sqlscript.sql".

hda7 · 03-10-2011, 05:36 PM

You can also embed a larger sql script in a shell file by using something like this:

Code:

#!/bin/bash
mysql -u root -p <<EOF
/* sql code goes here... */
EOF

mrpurple · 03-10-2011, 06:07 PM

Thanks very much. Just what I was after. I never thought of piping it.