command(s) to find size of mysql database?

sbourgeois · #1 (**permalink**) 06-10-2006

hello,

i'm trying to figure out the size of a mysql database shelling into my server with putty / command line.

is there / are there any commands that will return the size of a database, in MB?

thanks.

tayyabq8 · #2 (**permalink**) 06-11-2006

Code:

du -sk /dirpath

sbourgeois · #3 (**permalink**) 06-11-2006

thanks, if I enter du -sk /var/lib/mysql and the output is 400500 what is the total MB usage? /var/lib/mysql should contain the mysql db, i believe..?

sbourgeois · #4 (**permalink**) 06-11-2006

i guess this means 40MB? Strange, if i ftp in with GlobalSCAPE, the mysql folder in the directory above (which does indeed contain the mysql db) is 86MB... not sure what he 400500 figure represents..... thanks.

tayyabq8 · #5 (**permalink**) 06-12-2006

It shows you db size in KB, 400500/1024 gives u size in MB i.e. 391 MB

Regards,
Tayyab

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
PHP mySQL Database Wrapper Class 1.1.2 (Default branch)	iBot	Software Releases - RSS News	0	04-01-2008 11:20 AM
unix command to find the version of Informix database	sureshg_sampat	Shell Programming and Scripting	4	11-02-2007 05:12 AM
command to find out total size of a specific file size (spread over the server)	abhinov	SUN Solaris	3	08-08-2007 06:48 AM
Loading values into a MYSQL database	kshelluser	Shell Programming and Scripting	2	12-05-2006 02:10 PM
MYSQL command to take a backup of the database in Redhat linux 7.2	bache_gowda	UNIX for Advanced & Expert Users	4	01-21-2004 02:16 PM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by