![]() |
|
|
|
|
|||||||
| Forums | Portal | Register | Forum Rules | FAQ | Contribute | Members List | Arcade | Search | Today's Posts | Mark Forums Read |
| UNIX for Dummies Questions & Answers If you're not sure where to post a UNIX or Linux question, post it here. All UNIX and Linux newbies welcome !! |
|
|
||||
| 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 08:20 AM |
| unix command to find the version of Informix database | sureshg_sampat | Shell Programming and Scripting | 4 | 11-02-2007 02:12 AM |
| command to find out total size of a specific file size (spread over the server) | abhinov | SUN Solaris | 3 | 08-08-2007 03:48 AM |
| Loading values into a MYSQL database | kshelluser | Shell Programming and Scripting | 2 | 12-05-2006 11:10 AM |
| 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 11:16 AM |
|
|
Submit Tools | LinkBack | Thread Tools | Search this Thread | Display Modes |
|
#1
|
|||
|
|||
|
command(s) to find size of mysql database?
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. |
| Forum Sponsor | ||
|
|
|
#2
|
||||
|
||||
|
Code:
du -sk /dirpath |
|
#3
|
|||
|
|||
|
size
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..?
|
|
#4
|
|||
|
|||
|
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.
|
|
#5
|
||||
|
||||
|
It shows you db size in KB, 400500/1024 gives u size in MB i.e. 391 MB
Regards, Tayyab |
||||
| Google The UNIX and Linux Forums |