>
> 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)?
>
If your intent is to get the size 'on the fly' from within a web page, you
can use the filesystem object. I use ChiliSoft ASP but the solution is the
approximately the same for IIS ASP:
Syntax for a function to return filesize (in JScript/ASP) is:
function ShowFileSize(filespec)
{
var fs, f, s;
fs = new ActiveXObject("Scripting.FileSystemObject");
f = fs.GetFile(filespec);
s = f.Name + " uses " + f.size + " bytes.";
Response.Write(s);
}
Jay Fesco
Magical Mystery Words: database,sql,query,table
---------------------------------------------------------------------
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
