Exclude folders zip
zip -r myarchive.zip dir1 -x “dir1/ignoreDir1/*” “dir1/ignoreDir2/*”
Dump Dumping from a remote database Restore or in one line mysql -u username -p db_name < /path/to/table_name.sql Dump and restore a single table from a compressed (.sql.gz) format Dump Restore
Objective This articles describe on installing the paravirtualized drivers on a linux operating systems like centos, redhat, ubuntu Instructions 1. Insert the XenTools ISO in the DVD drive of the Linux VM2. Mount the DVD drive to /mnt using : “mount /dev/xvdd /mnt”It says , mount : block device /dev/xvdd is write-protected, mounting read-only The…
Listing sizes in AWS S3 Buckets Getting the whole bucket size aws s3 ls s3://$BUCKETNAME/ –recursive –human-readable –summarize | tail -n2 Tail is used because otherwise all files will be printed on screen (but you may want that for some reason). Getting the size of a specific directory/file You just need to add the path…
Restore MySQL databases with innodb_force_recovery Why use the innodb_force_recovery option? A higher rate of database restore failures have been observed in MySQL 5.7 and higher versions, after innodb_file_per_table became the default tablespace option. This is due to the data consistency standards that InnoDB adheres to. In short, when an attempt is made to restore a database, the…
Way to the Web Ltd and Configserver.com has closed down permanently on 31 August 2025. ConfigServer Security & Firewall (CSF) is an iptables-based firewall that provides high-level security to the Linux system. CSF includes a wide range of features, such as IP blocking, port blocking, and DoS protection. It also supports advanced security measures, such as rate…
Go to system/startup.php and find following lines of code: if (!ini_get(‘date.timezone’)) { date_default_timezone_set(‘UTC’); } Replace with following lines of code by changing to your timezone date_default_timezone_set(‘Australia/Sydney’); Synchronize PHP and Database Timezone The query we use to set database timezone if you are super admin is below: SET time_zone=’offset’; But everyone has no super admin access…