Clan Themes, We Make Clans Look Good!

CT on Facebook

Latest Product

Battlefield 3 Stats Module

User Box

Anonymous

38.107.179.218

PND Downloads Feed

How to Delete or Reset yo...

Lost your admin password ?Â Cant login to your admin account ?This sh...

Back Online & Stuff

Look at us with our nifty website back up and running… Seriousl...

How to edit the admins in...

Here is a way to make someone admin in your forums on your Evo site. I...

Demo Splash Screen

Ped @ Clan Themes has released a simple splash screen entrance hack.Â ...

Free Phpnuke Business The...

This is the 6th Business theme for Phpnuke that Clan Themes has releas...

Tricked Out Slider

We have seen some great new things come out of Tricked Out News and th...

Phpnuke Downloads

Custom Work

www.clanthemes.com :: View topic - Automatic mysql database backup

Automatic mysql database backup

7 Replies / 1934 Views


www.clanthemes.com Forum Index » General PhpNuke	View previous topic :: View next topic

LORAXX
Reputation: 6.5
Local time: 9:10 AM

Armour Whore

0.03 posts per day
Medals: 0

Joined: Jan 17, 2008
Last Visit: 18 Dec 2008
Posts: 43
Points: 718

Automatic mysql database backup Posted: Tue Jan 29, 2008 2:30 pm
Shop Purchases:Multi Gaming (Warrior) Theme · Clan Roster v1.7 Php Nuke Module

Are there any scripts to add to your site to get automatic MySql database backups every day or so. I have the manual module for backup but it would be nice to get an automatic backup also. Thoughts???

Thanks

DoC
Reputation: 90.1
votes: 5
Local time: 2:10 PM
Location: UK

0.24 posts per day
Medals: 3 (View more...)

Forums Moderator

Joined: Feb 07, 2007
Last Visit: 30 Jun 2011
Posts: 430
Points: 4451

Automatic mysql database backup Posted: Tue Jan 29, 2008 5:40 pm
Shop Purchases:Clan Roster v1.7 Php Nuke Module · Clan Roster 2.0

Hey Loraxx,

Yep there sure is buddy and its located right here at CT LMAO

http://www.clan-themes.co.uk/downloaddetails-9-171-advanced-nuke-backup.html#dldetails

I have not used this but from what i have read it certainly seems what you are after.

DoC

LORAXX
Reputation: 6.5
Local time: 9:10 AM

Armour Whore

0.03 posts per day
Medals: 0

Joined: Jan 17, 2008
Last Visit: 18 Dec 2008
Posts: 43
Points: 718

Automatic mysql database backup Posted: Fri Feb 01, 2008 1:18 pm
Shop Purchases:Multi Gaming (Warrior) Theme · Clan Roster v1.7 Php Nuke Module

This is an excellent script. However, is it possible to change the format of the database backup? The database seems complete howerver, I think there is too much information since 1 - the file 50% larger than typical db backups (db exports), and 2 - the file does not import correctly.

Anyone else have this problem and solve it?

Recommend another automatic backup script?

Thanks

LORAXX
Reputation: 6.5
Local time: 9:10 AM

Armour Whore

0.03 posts per day
Medals: 0

Joined: Jan 17, 2008
Last Visit: 18 Dec 2008
Posts: 43
Points: 718

Automatic mysql database backup Posted: Sun Feb 03, 2008 2:41 pm
Shop Purchases:Multi Gaming (Warrior) Theme · Clan Roster v1.7 Php Nuke Module

This advanced autoback is a great tease idea great but mysql file does not import even after changing TYPE=mysiam to ENGINE=myisam. I noticed floppy was on http://nukecoder.com/ site also looking for good auto backup script.

Anybody. Really want a good automatic backup script. Advanced backup is to dated and does not export correctly for import today.

Floopy what are you using? Did you get a work around.

Many thanks.

Ped
Reputation: 62.2
votes: 35
Local time: 3:10 PM
Location: Great British Empire

Site Founder

2.32 posts per day
Medals: 2 (View more...)

Theme Guru

Joined: Nov 13, 2006
Last Visit: 09 Feb 2012
Posts: 4449
Points: 180705

Re: Automatic mysql database backup Posted: Sun Feb 03, 2008 3:06 pm
Shop Purchases:Clan Roster 2.0 · Bad Company 2 Vietnam Xtreme Theme

We use Nukecoders here, and it works fine we have it emailed to us daily

What are you having problems with exactly ?

LORAXX
Reputation: 6.5
Local time: 9:10 AM

Armour Whore

0.03 posts per day
Medals: 0

Joined: Jan 17, 2008
Last Visit: 18 Dec 2008
Posts: 43
Points: 718

Automatic mysql database backup Posted: Sun Feb 03, 2008 6:53 pm
Shop Purchases:Multi Gaming (Warrior) Theme · Clan Roster v1.7 Php Nuke Module

Ped,

The db doesnot import into phpadmin without error. So I found this on a forum post on nukecoders.

To fix this, open up includes/dump.php

Find

Code:
$structure .= ") TYPE=".$statusrow['Type'];

Change to

Code:
$structure .= ") TYPE=".$statusrow['Engine'];

I made these changes but it still does not import without error. The error is now different. Below is the error I get when I try to import into phpadmim:

Error
SQL query:

CREATE TABLE `nuke_nsnst_tracked_ips` (

`tid` int( 10 ) NOT NULL AUTO_INCREMENT ,
`ip_addr` varchar( 15 ) NOT NULL default '',
`ip_long` int( 10 ) unsigned NOT NULL default '0',
`user_id` int( 11 ) NOT NULL default '1',
`username` varchar( 60 ) NOT NULL default '',
`user_agent` text NOT NULL ,
`refered_from` text NOT NULL ,
`date` int( 20 ) NOT NULL default '0',
`page` text NOT NULL ,
`x_forward_for` varchar( 32 ) NOT NULL default '',
`client_ip` varchar( 32 ) NOT NULL default '',
`remote_addr` varchar( 32 ) NOT NULL default '',
`remote_port` varchar( 11 ) NOT NULL default '',
`request_method` varchar( 10 ) NOT NULL default '',
`c2c` char( 2 ) NOT NULL default '00',
PRIMARY KEY ( `tid` ) ,
KEY `ip_addr` ( `ip_addr` ) ,
KEY `ip_long` ( `ip_long` ) ,
KEY `user_id` ( `user_id` ) ,
KEY `username` ( `username` ) ,
KEY `user_agent` ( `user_agent` ) ,
KEY `refered_from` ( `refered_from` ) ,
KEY `date` ( `date` ) ,
KEY `page` ( `page` ) ,
KEY `c2c` ( `c2c` )
) TYPE = MYISAM AUTO_INCREMENT =4485;

MySQL said:

#1170 - BLOB/TEXT column 'user_agent' used in key specification without a key length

Any ideas? Could I get a copy of your dump.php file? NOTE: 144 of a 172 tables did import.

Thanks

LORAXX
Reputation: 6.5
Local time: 9:10 AM

Armour Whore

0.03 posts per day
Medals: 0

Joined: Jan 17, 2008
Last Visit: 18 Dec 2008
Posts: 43
Points: 718

Re: Automatic mysql database backup Posted: Sat Mar 01, 2008 12:59 am
Shop Purchases:Multi Gaming (Warrior) Theme · Clan Roster v1.7 Php Nuke Module

<bump>

anyone??

LORAXX
Reputation: 6.5
Local time: 9:10 AM

Armour Whore

0.03 posts per day
Medals: 0

Joined: Jan 17, 2008
Last Visit: 18 Dec 2008
Posts: 43
Points: 718

Re: Automatic mysql database backup Posted: Tue Mar 04, 2008 2:09 am
Shop Purchases:Multi Gaming (Warrior) Theme · Clan Roster v1.7 Php Nuke Module

I found a superior solution and I a sticky on ravenscripts explaining the solution. Raven's site is currently not available for me to post a link. For now search on loraxx to find sticky.

www.clanthemes.com Forum Index » General PhpNuke

7 Replies / 1934 Views
Page 1 of 1
All times are GMT

Display posts from previous:

Jump to:

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You can download files in this forum

Company Information
Home · About Us · Affiliates · Advertising
Link To Us · Newsletter · Contact Us · Site Map
All content © Clan Themes 2006 - 2012
Based on RavenNuke

Clan Themes, We Make Clans Look Good!

Sponsors

CT on Facebook

Latest Product

User Box

PND Downloads Feed

Custom Work