MySQL console: Redirect standard output

April 2018

Intro

MySQL client command must be common to you (mysql), with this small tip you should be able to redirect the output commands to any program?

To do this, simply use the pager command, followed by the name of the program to redirect the output.
Example:

mysql>pager more 
PAGER set to 'more' 
mysql>

The next time the result of a command exceeds one page, you simply press the space bar to move from page to page:)

To return to the default pager, use the command "nopager":

mysql> nopager 
PAGER set to stdout 
mysql>

In order to search an item, ... in the output:
- ```
  mysql>pager vi - 
```
To view only the tables with a particular name (no case sensitive).
- ```
  mysql>pager grep -i name 
```

mysql>show tables;

Published by jak58. Latest update on May 3, 2010 at 09:16 AM by deri58.

Installing MySQL on Gentoo Linux

Backup/Restore MySQL database