Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

Quick question: I have created come commands that will warm-up my DB. The thing is that those selects are large. When I do such a select I get all the "jiba-jaba" into my terminal window. How can you make mysql do the select 'quietly' ? without taking ages to print all the crap into my terminal ?

share|improve this question

3 Answers 3

up vote 3 down vote accepted

You can redirect the output of any command -- not just MySQL -- by using your shell's i/o redirection operators. For example, in bash:

$ mysql mydb < commands.sql > /dev/null 2>&1

This will launch the MySQL command line client, connect it to "mydb" on the local system (assuming you have access), read SQL commands from the file commands.sql and dump all the output to /dev/null.

If you wanted to save the output for review after the fact, you could redirect it to a file rather than to /dev/null:

$ mysql mydb < commands.sql > output.txt 2>&1

The 2>&1 redirects stderr as well as stdout. If you wanted to see any errors on your terminal, you would only redirect stdout:

$ mysql mydb < commands.sql > /dev/null
share|improve this answer
  1. mysql-client:

    mysql> pager > /dev/null
    PAGER set to '> /dev/null'
    mysql> select 1;
    1 row in set (0.00 sec)
    
    mysql> \q
    Bye
    

    This way the result of the queries is not printed, only row count an timing information.

  2. IO redirection in the shell

    user@host$ mysql -e 'select 1' > /dev/null
    user@host$
    
share|improve this answer

That is working on Unix installations of mysql. Since Windows does neither has /dev/null nor a pager command in the mysql installation it will not work on mysql installed on windows.

On Windows Mysql (on Unix as well) you can use SELECT 1 INTO OUTFILE 'file_name' or set a variable and use SELECT 1 INTO @var; Check out the documentation here: http://dev.mysql.com/doc/refman/5.0/en/select.html

Keep in mind, that you cannot override an outfile so INTO Outfile will not work for repetitive selects.

share|improve this answer
    
What's wrong with > NUL:? –  Michael Hampton Oct 13 '12 at 20:18

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.