doing a site backup

Hangin' Around Joined: May 19, 2006 Posts: 39

Is there a idiots noob guide to doing a phpnuke website backup somewhere? So if your site got hacked or somthing you could simply fall back to the backup.

Sells PC To Pay For Divorce Joined: Posts: 5661

eh...when you go to admin configuration....you never noticed the function Backup db ?

Posted: Mon Jun 19, 2006 2:44 pm

I've found the 'Backup db' option in the Nuke admin panel is a bit buggy, so you could use PHPMYADMIN, or there are also a number of stand alone scripts out there that backup the database and email it to you.

Depending on how busy your site is will determine how often you need to back it up.

Always backup before you change anything on your site, just incase an upgrade, or new MOD screws things up.

Posted: Mon Jun 19, 2006 3:47 pm

Ive never done a backup.... Sad

Do I just press the backup button and it saves my present website to my hard dirve or somthing? or somewhere in cpanel?

also there is a backup button in nuke admin and in cpanel?

Posted: Mon Jun 19, 2006 3:49 pm

just click the backup button and see if it works for you..
and save the file on your computer..

Posted: Mon Jun 19, 2006 4:06 pm

ok I did it, It saved 1 file in notepad... Is that it?
seems to easy but Ive never done it lol I guess we all have to start somewhere.

Posted: Mon Jun 19, 2006 4:07 pm

nice..but try to view it...
if its to big open it in wordpad.

Posted: Mon Jun 19, 2006 4:13 pm

Here is just a small sample of the top of it - its about 3MB in size.... let me know if looks right to you

# ========================================================
#
# Database : Wink

# On 06-19-2006 at 18:11 by !
#
# ========================================================

# --------------------------------------------------------
#
# Table structure for table 'pnc_authors'
#

CREATE TABLE pnc_authors (
`aid` varchar(25) NOT NULL,
`name` varchar(50),
`url` varchar(255) NOT NULL,
`email` varchar(255) NOT NULL,

Posted: Mon Jun 19, 2006 4:15 pm

yes it looks fine..
but do take out your database name...rdinfan_nuke2
no need to publsh it here..

Posted: Mon Jun 19, 2006 4:16 pm

from this post you mean? is it unsecure info?

Posted: Mon Jun 19, 2006 4:17 pm

yes from this post...lol
nobody needs to know it...

Posted: Mon Jun 19, 2006 4:20 pm

ok I edited it, thanks for the help man.... So say I need to do a restore with this backup.. is it just as easy?

Posted: Mon Jun 19, 2006 4:24 pm

yes....its ok i guess....most people that see it the first time understand quickly how it works...
you can read here....
http://www.hitwalker.com/nukemanual-restore-php-nuke-from-backup.html

Posted: Mon Jun 19, 2006 4:52 pm

wow great link. Ok thanks.

This is a little off topic, but that appears to be your website, do you mind if I use your paypal donation button to replace my bland looking one?

Posted: Fri Jun 23, 2006 5:26 pm

Ok I tryed to do restore the backup since my site was allready hacked again since I posted this.... Here are the probs I had during the restore of the backup.

I was at "SQL query" of phpMyAdmin I selected browse "Browse" found the backup on my desktop and selected it then clicked go

after a minute or 2 I got this error and everything on the website looks the same. Like i said before this is my first time trying to d this

Error

SQL query:

#
# Dumping data for table 'tp_users'
#
# --------------------------------------------------------
#
# Table structure for table 'vwar'
#
CREATE TABLE vwar(
`warid` smallint( 5 ) unsigned NOT NULL AUTO_INCREMENT ,
`gametypeid` smallint( 5 ) DEFAULT '0' NOT NULL ,
`matchtypeid` smallint( 5 ) DEFAULT '0' NOT NULL ,
`gameid` smallint( 5 ) DEFAULT '0' NOT NULL ,
`mailgroupid` smallint( 5 ) DEFAULT '0' NOT NULL ,
`report` text NOT NULL ,
`publicreport` smallint( 5 ) DEFAULT '1' NOT NULL ,
`ownplayers` text NOT NULL ,
`opplayers` text NOT NULL ,
`oppid` smallint( 5 ) DEFAULT '0' NOT NULL ,
`serverid` smallint( 5 ) DEFAULT '0' NOT NULL ,
`playerperteam` tinyint( 2 ) ,
`serverpassword` varchar( 100 ) NOT NULL ,
`info` text NOT NULL ,
`publicinfo` smallint( 5 ) DEFAULT '1' NOT NULL ,
`resultbylocations` smallint( 1 ) DEFAULT '0' NOT NULL ,
`status` smallint( 1 ) DEFAULT '0' NOT NULL ,
`dateline` int( 11 ) DEFAULT '0' NOT NULL ,
`repeat_mod` varchar( 6 ) NOT NULL ,
`repeat_number` varchar( 10 ) NOT NULL ,
`repeat_saveas` smallint( 1 ) DEFAULT '0' NOT NULL ,
`addedby` smallint( 5 ) DEFAULT '0' NOT NULL ,
`addedtime` int( 11 ) DEFAULT '0' NOT NULL ,
`changedby` smallint( 5 ) DEFAULT '0' NOT NULL ,
`changedtime` int( 11 ) DEFAULT '0' NOT NULL ,
PRIMARY KEY ( warid )
);

MySQL said: Documentation
#1050 - Table 'vwar' already exists