NukeCoder

Guest

I'm italian man - my compliments for the program advbackup that it works well but the backuped list one that saves in format sql, does not create the tables in mysql DB. I use program phpnuke v.6.8 and its backup creates the tables in the DB.
thanks in advance
lucky

Guest

excused me if they have been inaccurate. I have noticed that in local the list of the backup it is corrected but on the serveur (linux) is different format.
thanks

Site Admin Joined: Oct 25, 2004 Posts: 921

Are you talking about the file name's time format?

Guest

excused for my English language.
The file sended from advbackup in the serveur, it contains data without carriage return for which mysql they give error to me while, if used advbackup in not remote way (pc local mode) is perfectly suitable to backup.
which is the cause of this difference ?
how to correct this problem?
thanks for the answer

Site Admin Joined: Oct 25, 2004 Posts: 921

can you post an example?

Guest

I have resolved the previous problems of visualization.
now,this is the error that they give to me during the loading in the mysql
CREATE TABLE nuke_advbackup (
id int(11) DEFAULT '0' NOT NULL,
backupdir varchar(100) DEFAULT 'backup' NOT NULL,
mail_to varchar(255) NOT NULL,
mail_from varchar(255) NOT NULL,
excludes varchar(255) NOT NULL,
lastdb varchar(25),
lastfile varchar(25),
autostate varchar(4) NOT NULL,
autoinc int(11) DEFAULT '48' NOT NULL,
autolast int(22) DEFAULT '0' NOT NULL,
autogzip varchar(4) NOT NULL,
automail varchar(4) NOT NULL,
autodel varchar(10) NOT NULL,
PRIMARY KEY ()
) TYPE=MyISAM

Messaggio di MySQL:

Something is wrong in your syntax prÃ¨s de ')
) TYPE=MyISAM' Ã la ligne 15
thanks for your availability

Site Admin Joined: Oct 25, 2004 Posts: 921

Try this.

Code:

CREATE TABLE `nuke_advbackup` (
`id` int(11) NOT NULL default '0',
`backupdir` varchar(100) NOT NULL default 'backup',
`mail_to` varchar(255) NOT NULL default '',
`mail_from` varchar(255) NOT NULL default '',
`excludes` varchar(255) NOT NULL default '',
`lastdb` varchar(25) default NULL,
`lastfile` varchar(25) default NULL,
`autostate` varchar(4) NOT NULL default '',
`autoinc` int(11) NOT NULL default '48',
`autolast` int(22) NOT NULL default '0',
`autogzip` varchar(4) NOT NULL default '',
`automail` varchar(4) NOT NULL default '',
`autodel` varchar(10) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM;

Guest

this is right, but all the "KEY" are empty.
example without advbackup:
CREATE TABLE nuke_bbcategories (
cat_id mediumint( Cool

unsigned NOT NULL auto_increment,
cat_title varchar(100),
cat_order mediumint( Cool

unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (cat_id),
KEY cat_order (cat_order)
);
example with advbackup:
CREATE TABLE nuke_bbcategories (
cat_id mediumint( Cool

unsigned NOT NULL auto_increment,
cat_title varchar(100),
cat_order mediumint( Cool

unsigned DEFAULT '0' NOT NULL,
KEY cat_order ()
) TYPE=MyISAM;
you see the difference? why?
best regards

Site Admin Joined: Oct 25, 2004 Posts: 921

you need to apply the update from here http://nukecoder.com/downloadview-details-6-Update_for_Advanced_Nuke_Backup_1.1.html

here is what mine looks like with anb...

Code:

DROP TABLE IF EXISTS `nuke_bbcategories`;
CREATE TABLE `nuke_bbcategories` (
`cat_id` mediumint(8) unsigned NOT NULL auto_increment,
`cat_title` varchar(100) NULL,
`cat_order` mediumint(8) unsigned NOT NULL default '0',
PRIMARY KEY (`cat_id`),
KEY `cat_order` (`cat_order`)
) TYPE=MyISAM AUTO_INCREMENT=7;

NOTE : To be sure you have the latest and best version, only download advanced nuke backup from this site, as i am not responsible for any other site that hosts unmaintained/edited files. Just be careful.

Posted: Sat Apr 23, 2005 12:18 pm

all it works well now, it still compliments and thanks.
luckysoft