/bin/log

Log my thoughts

Home About GitHub

21 Aug 2012
241

[root@p2401058 charged.fm]# du -hs * 20K anonftp 12K cgi-bin 20K conf 5.4G emaillists 56K errordocs 59M httpdocs 3.3M httpsdocs 131M librarycharged2011 29M librarycms 84K libraryfacebook 2.2G logs 4.0K pd 8.0K private 357M statistics 8.0K subdomains 47M tests

 

 

[root@p2401058 bureauapi.com]# du -hs * 20K anonftp 4.0K bin 142M bureauapi.com.tar 129M bureauapi.com.tar.gz 12K cgi-bin 16K conf 56K errordocs 31M httpdocs 372K httpsdocs 4.0K kar 4.0K mivadata 24K nbproject 4.0K pd 8.0K private 12K ram 4.0K rr 4.0K rsyncmedia.log 4.0K sathish 112M standards 4.6M standards.tar 69M statistics 4.0K subdomains 4.0K test 4.0K webusers

 

 

< mysql> SELECT tableschema "DB Name", sum( datalength + indexlength ) / 1024 / 1024 "DB Size in MB" FROM informationschema.TABLES GROUP BY tableschema;
+--------------------+---------------+
| DB Name | DB Size in MB |
+--------------------+---------------+
| charged | 4939.38602161 |
| chargedcms | 769.40978718 |
| chargedmigrate | 773.51776981 |
| informationschema | 0.00390625 |
| meadowlandsparking | 4610.54962635 |
| mysql | 0.52672958 |
| phpmyadmin | 0.00781250 |
| somersetpatriots | 0.68125534 |
+--------------------+---------------+
8 rows in set, 1 warning (0.06 sec)

mysqldump --host=172.23.3.244 -u root -p chargedcms > chargedcms.sql
mysqldump --host=172.23.3.244 -u root -p chargedmigrate > chargedmigrate.sql
mysqldump --host=172.23.3.244 -u root -p charged > charged.sql


Carpe diem,
JZR at 15:12

Home About GitHub