Uncategorized

Mysql: Table size query

Posted on

    SELECT TABLE_NAME, table_rows, data_length, index_length, ROUND(((data_length + index_length) / 1024 / 1024),2) ‘Size in MB’ FROM information_schema.TABLES WHERE table_schema = ‘mallagroup_mautic’ ORDER BY ROUND(((data_length + index_length) / 1024 / 1024),2) DESC ;

Uncategorized

Openbravo: Latest Version Install

Posted on

We have an old Community Version of Openbravo, which is super buggy and corrupted, so starting this new year, we’re interested on trying the latest version of OB. In this case we’ll be installing Openbravo Community Edition PR18Q4.1.  Additionally one of the reasons we want to install this is that we are going to install it […]

Uncategorized

Vmware: GhettoVCB

Posted on

This script was created by William Lam (https://www.virtuallyghetto.com) and is a great tool to backup your VMs with a Script.  Download the Script to your datastore Configure the Shell Create a file with the names of the VMs you want to backup (for example vmbackup) After this run the command ./ghettoVCB.sh -f vmbackup    

Uncategorized

PFSense: Turn off Interface with Script

Posted on

  On our office, we have a USB Stick as a backup for our internet. The problem is that after reviewing the log, every night it consumes about 4gb of data (not sure why).  So, for the time being, I would like to programatically disable the Interface every night and enable it every morning, this […]

Uncategorized

Script to Rotate Backups

Posted on

Delete all files except the ones the first day of the month.  root@DiskStation:/volume1/homes/scripts# find /volume1/NetBackup/Servers/MIA/Asterisk/Admin/Cron/ -type f -mtime +7 ! -name ‘*01-*’ -exec rm -rf {} \;