Main | Search

Question
Sort: Ascending / Descending
Change your table prefix
Protect subdirectories
Run a cronjob to backup database

Answer
Change your table prefix

If you are going to install a fresh CPG-Nuke driven website we advise that you change $prefix and $user_prefix to something of your own choosing.

If you forgot to do that, or you already have a running CPG-Nuke site, just follow these instructions...

First BACKUP your database

Then, in the below script, change "NEWPREFIX" to the new prefix you'd like to use. Save and upload this script, execute it from your browser, and run the listed SQL commands in phpMyAdmin. Once you have run these commands DELETE this file!
PHP:
<?php
define('CPG_NUKE', true);
require_once('config.php');

mysql_connect($dbhost, $dbuname, $dbpass, $dbname);
$result = mysql_list_tables($dbname);
while ($row = mysql_fetch_row($result) or die(mysql_error())) {
    $table = $row[0];
    if (eregi($prefix, $table)) {
        echo "ALTER TABLE $row[0] RENAME ".eregi_replace($prefix,"NEWPREFIX",$table).";<br />";
    }
}

Then open your config.php and change the values of $prefix and $user_prefix to match the new prefix you chose in the script. Save and upload the new config.php.

Good Luck!

Protect subdirectories

CPG-Nuke 8.2 and above has a .htaccess in the subdirectories which protects every PHP file to run on it's own (for ex. modules/Your_Account/register.php)

This could give a conflict when a module/add-on asks a file like that in the browser.
Now you can create a new .htaccess file which allows to run (only) that file from a subdirectory.
Code:
<filesmatch "\.php$">
Allow from all
</filesmatch>

It's better to change the link for that specific file then to use above script to keep security.

Run a cronjob to backup database

You can run a 'cronjob' to make a backup each day/week/month of your database to keep a backup even when you get hacked.
create a shell file with following
Code:
#! /bin/sh
FILE=DBNAME-`date +%Y%m%d%H%M`.sql
DIR=/PATH/TO/YOUR/ROOT
mysqldump -f -hHOSTNAME -uUSERNAME -pPASSWORD DBNAME --add-drop-table | gzip -9c >${DIR}${FILE}.gz

'/PATH/TO/YOUR/ROOT' for example /home/mydom.com/backup
don't put in '/home/mydom.com/public_html' for security reasons.

HOSTNAME: for example 'localhost'
USERNAME: the name you use to connect with database
PASSWORD: the password of the user
DBNAME: name of the database

These are actualy the same as in config.php

Upload the file to your root (ex. /home/mydom.com/dbbackup.sh )
Then in your cPanel/Ensim create a cronjob for it.

Don't forget to download the backups and delete them once in a while to keep your serverspace

stopsoftwarepatents.eu petition banner
User Info [x]

Welcome Anonymous
Nickname
Password
(Register)

Languages [x]

Community [x]

Support for DragonflyCMS in a other languages:

• Deutsch
• Español

X-links [x]
UltraEdit Browse Happy logo Firefox MySQL PostgreSQL Valid CSS! Valid XHTML 1.0! Unicode Encoded Badge NukeBiz Resources Raven DragonflyCMS Dedicated Now InsideSupport Lampe Berger

Preview theme [x]
Each user can view the site with a different theme.
Themes marked with a * also change the forum look.


You are seeing squares or questionmarks on this page?

All content of this website is copyrighted by the Creative Commons NC-SA
The logos and trademarks used on this site are the property of their respective owners
We are not responsible for comments posted by our users, as they are the property of the poster.
Our server runs on a P3 1.2GHz with 512MB RAM with no accelerators
Support GoPHP5.org
This page generated in 0.1086 seconds with 8 DB Queries in 0.0137 seconds
Memory Usage: 1.49 MB
Interactive software released under GNU GPL, Code Credits, Privacy Policy