[OT] MySQL Table size to CSV file

[Oliver Marshall]

Found the tee command which can be used within the mysql prompt to log to
txt.




On 12 March 2013 14:39, Oliver Marshall <oliver.marshall at g2support.com>wrote:

> Hi
>
> I have a DB with about 600 tables. I want to know the size of the tables
> in descending size order but it's not workable to have this in a shell
> window.
>
> Does anyone know of a way to run a query in mysql that will output to a
> csv file or even a text file?
>
> Olly
>

-- 
Network Support
Online Backups
Server Management

Tel: 0845 307 3443
Web: http://www.g2support.com
Twitter: g2support <http://twitter.com/home?status=@g2support>
Google+: http://www.g2support.com/plus
Facebook: http://www.facebook.com/g2support
Mail: Unit H, Hove Technology Centre, Hove, Sussex, BN3 7ES

Have you said something nice about us to a friend or colleague ? Let us say 
thanks. Find out more at www.g2support.com/referral

G2 Support LLP is registered at Mill House, 103 Holmes Avenue, HOVE
BN3 7LE. Our registered company number is OC316341.

      
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.ubuntu.com/archives/ubuntu-users/attachments/20130312/75949031/attachment.html>