The UNIX and Linux Forums  

Go Back   The UNIX and Linux Forums > Top Forums > UNIX for Dummies Questions & Answers
Google UNIX.COM


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 !!

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 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

Reply
 
Submit Tools LinkBack Thread Tools Search this Thread Display Modes
  #1  
Old 06-10-2006
Registered User
 

Join Date: Jun 2006
Posts: 3
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.
Reply With Quote
Forum Sponsor
  #2  
Old 06-10-2006
tayyabq8's Avatar
Moderator
 

Join Date: Nov 2004
Location: Bahrain
Posts: 555
Code:
du -sk /dirpath
Reply With Quote
  #3  
Old 06-11-2006
Registered User
 

Join Date: Jun 2006
Posts: 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..?
Reply With Quote
  #4  
Old 06-11-2006
Registered User
 

Join Date: Jun 2006
Posts: 3
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.
Reply With Quote
  #5  
Old 06-11-2006
tayyabq8's Avatar
Moderator
 

Join Date: Nov 2004
Location: Bahrain
Posts: 555
It shows you db size in KB, 400500/1024 gives u size in MB i.e. 391 MB

Regards,
Tayyab
Reply With Quote
Google The UNIX and Linux Forums
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes




All times are GMT -7. The time now is 03:21 AM.


Powered by: vBulletin, Copyright ©2000 - 2006, Jelsoft Enterprises Limited.
The UNIX and Linux Forums Content Copyright ©1993-2008. All Rights Reserved.Ad Management by RedTyger Visit The Complex Event Processing Blog

Content Relevant URLs by vBSEO 3.2.0