Apache2 is only an platform for running web based aplication in our server. The language intrepreter is a must. The common language for server is php. So my local server is lack oh php. Cause when I ran php file, it show the entire content,…

Nah maksud saya sih, bagaimana menulis perintah dalam command line linux untuk menyisipkan sebuah atau banyak data ke dalam database sql. Begini penampakan skrip yang saya tulis sambil membaca beberapa tutorial : !#/bin/bash mysql -uusername -ppassword -e “USE mydatabase; INSERT INTO firsttable(id,value) VALUES(‘1′,’datasatu’);” Dan tentunya…

Here is my bash script to execute msyql command !/bin/bash tglblk=$(date –date=”8 days ago” +%Y-%m-%d) tglhapus=”$tglblk 23:00:00″ SQL=”DELETE FROM Events WHERE EndTime<=’$tglhapus’;” MYSQL_USER=”root” MYSQL_PASS=”” MYSQL_DB=”mydb” echo $SQL | mysql –user=$MYSQL_USER –password=$MYSQL_PASS $MYSQL_DB Then I put it into crontab to run at specific time.