PHP Spam Scripts

PHP Spam Scripts I finally decided this topic deserves its own page. To find the script sending spam Plesk Ver -11.0 Ver 11.5+ WHM cPanel View the results Joomla This file often appears in /tmp/sysNNNNNNNN.php file 1. /tmp is 777 2. the sysNNNNNNNN.php is usually accompanied by a .zip file 3. .php and .zip are … Read more

Zero Out Log File

or if you want to be more eloquent, will empty logfile (actually they will truncate it to zero size). You can also use to be perfectly explicit or, if you don’t want to, (applications usually do recreate a logfile if it doesn’t exist already). However, since logfiles are usually useful, you might want to compress … Read more

Optimize only fragmented tables in MySQL

When you are using MySQL, you will (likely) have tables that can be fragmented. In MySQL terms this is called “OPTIMIZE”. You could simply OPTIMIZE every table in every database, but during an OPTIMIZE, the tables are locked, so writing is not possible. To minimize the time that MySQL will be locked (and results cannot … Read more

Mysql Report

Another tool of a similar nature is the MySQLReport tool which can be found at http://hackmysql.com. Information can be found here about how to read and analyse the report that is produces from this link http://hackmysql.com/mysqlreportguide. You can load it up remotely and build it on your server in a similar way making use of … Read more

Using Mysqltuner

Download/Installation Simple You can download the entire repository by using ‘git clone’ followed by the cloning URL above. The simplest and shortest method is: Change the permissions you can execute it without calling perl directly. [stextbox id=”warning”]——– Recommendations —————————————————–[/stextbox] General recommendations: Run OPTIMIZE TABLE to defragment tables for better performance MySQL started within last 24 … Read more

Mysql Check/Repair Database

Check a Specific Table in a Database If your application gives an error message saying that a specific table is corrupted, execute the mysqlcheck command to check that one table. The following are some of the key options that you can use along with mysqlcheck. -A, –all-databases Consider all the databases -a, –analyze Analyze tables -1, –all-in-1 Use … Read more

rsync from one server to another

Basically, Synchronize Files From Local to Remote (Plesk to cPanel) Synchronize Files From Remote to Local )cPanel to Plesk) Here is a short summary of the options available in rsync. Please refer to the detailed description below for a complete description. -v, –verbose increase verbosity -q, –quiet suppress non-error messages –no-motd suppress daemon-mode MOTD (see … Read more