MySQLDump Shell script for backup Rumi, April 21, 2013 You can use the following script to dump mysql database and can add to crontab entry for daily backup! #!/bin/sh DAY=`/bin/date +%Y%m%d` TFILE="/backup/MYDB.$DAY.gz" mysqldump -u root -p'MYPASSWORD' MYDB | gzip > $TFILE echo "cache dump completed, dump script by rumi (hasan.emdad@mango.com.bd)" Related Scripts MySQL
How to empty Table in MySQL database Daily with cronjobs September 3, 2013 you can create a php script. truncatetable.php Example: <? $db_host = "localhost"; $db_user = "username"; $db_pass = "password"; $db_name = "databasename"; $connect = @mysql_connect($db_host,$db_user,$db_pass); @mysql_select_db($db_name); // Empty table $query = "TRUNCATE TABLE TableName01"; mysql_query($query); ?> Then setup the cronjob Related Read More
How to quickly stress test a web server November 13, 2017 The Curl syntax allows you to specify sequences and sets of URL’s. Say for example we’re going to run a load stress test against Google we can run… curl -s “http://google.com?[1-1000]” This will make 1000 calls to google i.e. Related Read More
Installer for jitsi-meet, jigasi and jibri November 19, 2022 Found this lovely code base (that actually worked) on github, supported on a debian 10/11 or ubuntu 20+ versions- The script (jitsi_setup.sh) can be used to install stable version of all 3 on a stand-alone server. This is simply a script version of quick-install document at https://jitsi.github.io/handbook/docs/devops-guide/devops-guide-quickstart It Installs below… Read More