Is it possible to view the size of a MySQL database..? how??
Depends on which size you mean. If you mean the space it takes on disk, then search for where your MySQL database stores it's data, and simply list that directory. There should be a file of the same name as the database/table that you are using.
Yes, I ment the size it takes on the server... hmm.. didn't find it the way you told me.. possible I did someting wrong.. but.. first I typed whereis mysql... and then i checked those dirs as were listed..
The files are out there, you'll have to investigate a little further. :-) But, if you don't have root access, you may not have read permission in the directory where the files are stored.
In many Linux distributions the files in /usr/local/mysql/data/the_name_of_the_table/ directory.
You can easly get information of a table size with the du unix command.
du /usr/local/mysql/data/the_name_of_the_table/
