NukeCoder

Joined: Feb 21, 2007 Posts: 9

Hi

first times thanks;
I installed the Script and all ok, but whom I want to do Restore the Backup not go. I get am missing with the Script http://www.ozerov.de/pphlogger/dlcount.php?id=bigdump&url=http://www.ozerov.de/bigdump.zip

Please I do have data protection made and now not functioned

Site Admin Joined: Oct 25, 2004 Posts: 920

The most common problem is usually the line

Code:

TYPE=MYISAM;

TYPE is depreciated and should now be

Code:

ENGINE=MYISAM;

Usually a find/replace function in a good text editor will take care of it.

Joined: Feb 21, 2007 Posts: 9

Thank for your answer, please where is does I that to change?

Site Admin Joined: Oct 25, 2004 Posts: 920

You would change each occurrence in the backup you made, the .sql file, to make the import work.

Joined: Feb 21, 2007 Posts: 9

But I did not find it in my Backup (my sql file)

Site Admin Joined: Oct 25, 2004 Posts: 920

You should see something like this for each database table.

Code:

CREATE TABLE nuke_authors (
aid varchar(25) NOT NULL default '',
name varchar(50) default NULL,
url varchar(255) NOT NULL default '',
email varchar(255) NOT NULL default '',
pwd varchar(40) default NULL,
counter int(11) NOT NULL default '0',
radminsuper tinyint(1) NOT NULL default '1',
admlanguage varchar(30) NOT NULL default '',
PRIMARY KEY (aid)
) TYPE=MyISAM;

TYPE=MyISAM; should be ENGINE=MyISAM;

If you don't see anything like the above, please pm me a sample of your
backup file. Also, does the restore script (big dump) show any sql errors?