> 1) I'll assume you use myisam tables, as your version is kinda outdated. > 2) I'll assume you want the total DISK space required for your > database. (could be rows, could be tables, could be space used by the > rows and tables, all of those are different, different storage engines > use space differently, a innodb table could use 1GB in your disk, and > 800MB on rows) > 3) I'll assume that you KNOW how to get the size of a given > file/directory on your Operating System.
> If I'm wrong in any assumption, please let me know. > Locate your "data" directory, if you don't know where it is, or don't > have access to it, you just can't do this (you can always take a look > at the manual, windows is usually the "data" directory, linux is > somewhere in /var/lib, YMMV). Into this directory, you'll see a new > directory for every database, getting the size of the directory you > see how much disk space the database has taken. > > -- > Daniel da Veiga > Computer Operator - RS - Brazil Hence on linux, if your database folder is /var/lib/mysql/mydb, then execute : du -sh /var/lib/mysql/mydb Regards, Rithish. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
