Huge 7.9 DB, any tool to downgrade to 7.6 without Nuke?

New Member Joined: Oct 16, 2002 Posts: 11

Hello all,

I am kinda in a dilemma. I mysql db almost 10 megs in size. The last time the site was working was when it was version 7.9. Well, the site went down and now I am trying to figure out a way to convert the db to 7.6 so I can use it with Ravens version. Is there any other way besides starting from a scratch 7.9 and importing the data. A 10 meg db is painful to restore. Help me please Crying or Very sad

Posted: Sat Dec 09, 2006 4:57 pm

I cannot put my hand on the link right at this moment but yes, as search for 'downgrade script' should find it for you.

Sells PC To Pay For Divorce Joined: Posts: 5661

10 mb ?
thats nothing...peanuts... Wink

Posted: Sat Dec 09, 2006 9:47 pm

Evaders has posted the link to the downgrade script a number of times. I don't have it close at hand but it's posted in these forums I'm sure. You might need to break the restore into a series of steps but it should definitely be doable. What I usually wind up doing is separating out the Forums tables from the rest in an editor and then chunking the restore up into manageable segments thru PHPmyadmin.

Posted: Sun Dec 10, 2006 7:03 am

Hi fkelly,

Yup, thats the painful part. I guess there is no other way, except to load up 7.9 and do a painful db restore in phpmyadmin. I was hoping there was a tool out there without having to load up phpnuke. Like a standalone executable.

Posted: Sun Dec 10, 2006 12:19 pm

I'm not sure I get the "load up phpnuke" reference. You can back up your database in chunks from phpmyadmin and that saves having to go in there with an editor and copy and paste out sections of it. I just keep a little paper pad by the computer and note down which tables I've done and which have to still be done. There is usually a file size limit on what you can import back to phpmyadmin for the restore so it helps to make the backup exports be tar.gz format. And I'd skip the Sentinel tables entirely unless you have really customized them and added a bunch of blocked IP's. The IP to country table in particular is huge and you'd be better off loading it fresh from the installation sql.

Posted: Sun Dec 10, 2006 1:44 pm

"I'm not sure I get the "load up phpnuke" reference" means that my original site is down. It is not running currently. I would have to "load up" re-install phpNuke. I didn't know about the backup in chunks though, I will remember that in the future.

registered · Posted: Sun Dec 10, 2006 10:06 pm

Use the Big Dump script to load up your database. 10 Megs, no problem.
And then run the downgrader script from http://www.nukescripts.net

Posted: Mon Dec 11, 2006 7:56 am

evaders99, great suggestion. I got an error right away. I am using a totally blank db.

Error at the line 26: ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

Query: CREATE TABLE IF NOT EXISTS `cpg_installs` (
`cpg_id` tinyint(3) NOT NULL auto_increment,
`dirname` varchar(20) NOT NULL default '',
`prefix` varchar(20) NOT NULL default '',
`version` varchar(10) default NULL,
PRIMARY KEY (`cpg_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

MySQL: You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ' at line 7

Posted: Mon Dec 11, 2006 8:27 am

I'm not sure why it shows cpg as the table prefix unles this was originally for use with cpg-nuke.
In anyevent, change the last line to read

Code:

) ENGINE=MyISAM;

Posted: Mon Dec 11, 2006 9:16 am

Error at the line 26: ) ENGINE=MyISAM ;

Query: CREATE TABLE IF NOT EXISTS `cpg_installs` (
`cpg_id` tinyint(3) NOT NULL auto_increment,
`dirname` varchar(20) NOT NULL default '',
`prefix` varchar(20) NOT NULL default '',
`version` varchar(10) default NULL,
PRIMARY KEY (`cpg_id`)
) ENGINE=MyISAM ;

MySQL: You have an error in your SQL syntax near 'ENGINE=MyISAM ' at line 7

Posted: Mon Dec 11, 2006 9:36 am

Oops. the problem is actualy on the first line copy this;

Code:

CREATE TABLE IF NOT EXISTS `cpg_installs` ( 


`cpg_id` tinyint(3) NOT NULL auto_increment, 


`dirname` varchar(20) NOT NULL default '', 


`prefix` varchar(20) NOT NULL default '', 


`version` varchar(10) default NULL, 


PRIMARY KEY (`cpg_id`) 


) ENGINE=MyISAM;

Posted: Mon Dec 11, 2006 9:55 am

Heck, I just went to the next table and same errors:

this is what bigdump.php shows:

Error at the line 12: ) ENGINE=MyISAM ;

Query: CREATE TABLE IF NOT EXISTS `nuke_antiflood` (
`ip_addr` varchar(4 Cool

NOT NULL default '',
`time` varchar(14) NOT NULL default '',
KEY `ip_addr` (`ip_addr`,`time`)
) ENGINE=MyISAM ;

MySQL: You have an error in your SQL syntax near 'ENGINE=MyISAM ' at line 5

this is the actual query:

DROP TABLE IF EXISTS `nuke_antiflood`;
CREATE TABLE IF NOT EXISTS `nuke_antiflood` (
`ip_addr` varchar(4 Cool

NOT NULL default '',
`time` varchar(14) NOT NULL default '',
KEY `ip_addr` (`ip_addr`,`time`)
) ENGINE=MyISAM ;

Posted: Mon Dec 11, 2006 12:40 pm

Weird that code worked for me just fine.

Try removing the ENGINE=MyISAM part next

Posted: Mon Dec 11, 2006 1:35 pm

yes, thats exactly what I did throughout the sql. It was a pain but it all imported with some glitches, but it's good now. I made a good backup of the current db and will start to move forward in the downgrade. Thanks a bunch for your help. I wouldn't have gotten this far without the help.