On Thursday 13 September 2001 03:12, Antoine E. Hall wrote:
> Hello,
>
> I'm new to MySQL and I was wondering if there was a command that you can
> issue to see the current size of a mysql database (in kb or MB)?
Not in MySQL as such (unless I've missed something in the meantime).
In Unix/Linux
du -k /var/mysql/database_name (or wherever your database is located (*))
will get you the total size of all files for that database in kilobytes.
(In Linux du -sh will produce an easier-to-read megabyte value if the total
is >= 1 MB). If MySQL is properly installed you will need root permissions to
read the data directory.
In Windows you can probably do something involving the mouse and some
icon-thingies, or maybe a simple DIR at the command line.
(*) If you are not sure, use the command
SHOW VARIABLES
or at the command line
mysqladmin variables
and look for 'datadir'.
Ian Barwick
--
Ian Barwick - Developer - [EMAIL PROTECTED]
akademie.de asp GmbH - http://www.akademie.de
"To query tables in a MySQL database is more fun than eating spam"
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php