Main Control Panel: Including SSH Backup & Restore Through Your AdminCP!

-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
Main Control Panel Hack, by N9ne \\ Created on March 15th 2003. \\ Copyright N9ne, 2003+.
-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
Description: This hack will add a page to the adminCP. On this page, there are many settings.
You can set which userids can access this page and its options in config.php
-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
Options available on page:
- Overwrite database with a backup
- Create backup
- Reset post counts
- Include Administrators?
- Delete 0 posters
- Prune all threads and posts
- Prune all PMs
- Delete all smilies
- Delete all icons
- Delete all custom avatars
- Delete all avatars
- Delete all attachments
- Delete all announcements
- Delete all forums
-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
You require SSH or telnet access on your server in order to run this hack. It will be running
mysql < and mysqldump > commands, so they must be installed. This may not work on all
windows systems. If you want to run this on localhost with a windows OS, you will need to add
chdir commands before mysql and mysqldump executions.
-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
Level of hacking: Easy
-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
Time Taken: 1 minute.
-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
Files to modify:
admin/index.php
admin/adminfunctions.php
admin/config.php
-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
Files to upload:
admin/maincontrol.php
-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
In the attached .zip file you can find: A screenshot of some of the options \\ Instructions for installation \\ maincontrol.php

[N9ne]

I mentioned that it might not work on a windows server. It should work on unix systems though.

AllMadden: Please post the code on and around that line.

Schorsch: What are the details of your server? What is the OS being used? Try executing this command from an SSH window on your server:

mysqldump --opt -uDBUSERNAME -pDBPASSWORD DBNAME > /path/to/backup/file.sql

Tell me if that works.

[Derek]

How can I make it so that I automatically have the folder I want my backups to go in remembered? I tried placing it in the code, but it didn't work... ideas?

[N9ne]

Today at 07:22 PM Derek said this in Post #22
How can I make it so that I automatically have the folder I want my backups to go in remembered? I tried placing it in the code, but it didn't work... ideas?

Open maincontrol.php

Find:

PHP Code:

  makeinputcode("Full path to folder where you want to create the backup file (<b>With</b> trailing slash)","dumpfilepath",""); 


Replace with:

PHP Code:

makeinputcode("Full path to folder where you want to create the backup file (<b>With</b> trailing slash)","dumpfilepath","/path/to/backup/folder/"); 


Change the path, and it should work.

[Schorsch]

Yesterday at 08:15 PM N9ne said this in Post #21
Schorsch: What are the details of your server? What is the OS being used? Try executing this command from an SSH window on your server:

mysqldump --opt -uDBUSERNAME -pDBPASSWORD DBNAME > /path/to/backup/file.sql

Tell me if that works.

I use SuSE Linux 8.1

the mysqldump command works without problems (used this many times before).

[N9ne]

Well I'm really no expert on SSH/telnet or servers...so I guess the problem is out of my hands, and I suppose that's a feature you won't be able to use, until I somehow figure out a way to make it work. Sorry .

[alkatraz]

awesome!!!!!!!!!!! I've been waiting for something like this for a long time
thx!

[Areku]

Any screenie?

[Schorsch]

Today at 01:21 PM Areku said this in Post #27
Any screenie?

look in the zip file

[N9ne]

Today at 09:06 AM alkatraz said this in Post #26
awesome!!!!!!!!!!! I've been waiting for something like this for a long time
thx!

hehe no problem . I'm glad there's quite a bit of enthusiasm for this hack, version 1.1 may be on its way soon though, with some fixes.

[romanticyao]

great! many thanx!