size of database

[Scunningham99]

Hi

I want to know the size of my vowkrs database.

I am trying to run the command


function getDbSize(vworks){
$size=shell_exec("du -b /var/lib/mysql/vworks");
$size=explode(' ',$size);
return $size[0];
}

but am unsure if it is correct and where to run it from?

As you can tell I have no experience of mysql at all so please be gentle


Sy UK

 

[KarveR]

This

function getDbSize(vworks){
$size=shell_exec("du -b /var/lib/mysql/vworks");
$size=explode(' ',$size);
return $size[0];
}

is a php function, specifically for a *nix platform.






______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.

 

[Scunningham99]

Great thanks

Does anyone have syntax for linux?



Sy UK

 

[KarveR]

du -h /path/to/database_dir

______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.

 

[guelphdad]

just so you know that when folks specify *nix, they generally mean UNIX, LINUX, Mac OSX etc.