Web Hosting Talk : Web Hosting Main Forums : Dedicated Server : MySQL space?

[happyhappy]

Just wondering, how do I check how much web space my MySQL database occupies?

[driverdave]

http://phpmyadmin.sourceforge.net/

I know this tells you EVERYTHING you'd ever want to know about MySQL, and more.

[happyhappy]

I should have just asked my provider. They said that they had to modify the config file to enable this feature with phpmyadmin.

But thanks for your help anyway.

[afriq]

Originally posted by happyhappy
Just wondering, how do I check how much web space my MySQL database occupies?

Log into your server (telnet or SSH) and do the following:

su -
(enter password)
cd /home/mysql
du -k
exit
(this will return you to the admin user account)

You'll get a listing of all the databases, with the space (in KB) that each uses ...

rgrds,

Johan