Reliable Penguin

To replace all whitespace with single spaces pipe the text through:

tr -s [[:space:]] " "

Execute the following commands:

DBCC SHRINKFILE(pubs_log, 2)
BACKUP LOG pubs WITH TRUNCATE_ONLY
DBCC SHRINKFILE(pubs_log,2)


This will reduce the transaction log for the "pubs" database to 2MB.

Here's a great article that describes some of the things that can be done to make a plesk server pass PCI compliance scans:

http://www.linux-advocacy.org/web-servers/making-plesk-more-pci-compliant

Create cpbackup-exclude.conf in the user's home directory (/home/user-id) to exclude files from a cPanel backup. This file is only used if you make a complete site back up from cPanel. Here are the basic rules for the content of the file:

• Each item to skip must be on it’s only line in the file.
• Directories should not have a trailing slash.
• Each entry must have the full path to the file or directory.

A "here document" is a method for specifying a multi-line string literal in many programming languages. Here are some examples:

Perl
print <<"END";

MULTIPLE LINES OF TEXT HERE

END


PHP
echo <<<EOF

Bash
cat << EOF