#!/bin/sh
mysql -u'user' -p'pwd' -D'db' </var/www/vhosts/mydomain/httpdocs/optimize.sql

OPTIMIZE TABLE `this_table`

#!/bin/sh
mysql -u'user' -p'pwd' -D'db' </var/www/vhosts/mydomain/httpdocs/truncate.sql

TRUNCATE TABLE `this_table`

#!/bin/sh
echo "truncate table this_table" | mysql -u'user' -p'pwd' -D'db'

nano .my.cnf

[mysql]
user=your_user
password=the_super_secret_password

#!/bin/bash
`mysql --defaults-file=/path/to/.my.cnf -e "truncate table this_table;"`