Database Conversion Script from 7.9 to RN2.10

registered · Posted: Sat Mar 17, 2007 11:53 am

Here is a cleaned up version of my script that I used to convert 7.9 to RN2.10. It is posted here without warranty or any support. Your database tables may be different due to 3rd party add-ons, so your mileage may vary. This script was generated from the mysqldiff tool, and then hand edited in a few places to remove some errors.

Code:




#


# MySQLDiff 1.5.0


#


# http://www.mysqldiff.org


# (c) 2001-2004, Lippe-Net Online-Service


#


# Create time: 16.03.2007 18:25


#


#





SET FOREIGN_KEY_CHECKS = 0;





#


# DDL START


#


CREATE TABLE nuke_bbconfirm (


    confirm_id char(32) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_general_ci,


    session_id char(32) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_general_ci,


    code char(6) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_general_ci,


    PRIMARY KEY (session_id, confirm_id)


) DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;





CREATE TABLE nuke_hnl_categories (


    cid int(11) NOT NULL COMMENT '' auto_increment,


    ctitle varchar(50) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_general_ci,


    cdescription text NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_general_ci,


    cblocklimit int(4) NOT NULL DEFAULT '10' COMMENT '',


    PRIMARY KEY (cid)


) DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;





CREATE TABLE nuke_hnl_cfg (


    cfg_nm varchar(255) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_general_ci,


    cfg_val longtext NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_general_ci,


    PRIMARY KEY (cfg_nm)


) DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;





CREATE TABLE nuke_hnl_newsletters (


    nid int(11) NOT NULL COMMENT '' auto_increment,


    cid int(11) NOT NULL DEFAULT '1' COMMENT '',


    topic varchar(100) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_general_ci,


    sender varchar(20) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_general_ci,


    filename varchar(32) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_general_ci,


    datesent date NULL DEFAULT NULL COMMENT '',


    view int(1) NOT NULL DEFAULT '0' COMMENT '',


    groups text NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_general_ci,


    hits int(11) NOT NULL DEFAULT '0' COMMENT '',


    PRIMARY KEY (nid),


    INDEX cid (cid)


) DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;





CREATE TABLE nuke_nsngr_config (


    config_name varchar(255) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_general_ci,


    config_value text NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_general_ci,


    PRIMARY KEY (config_name)


) DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;





CREATE TABLE nuke_nsngr_groups (


    gid int(11) NOT NULL COMMENT '' auto_increment,


    gname varchar(32) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_general_ci,


    gdesc text NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_general_ci,


    gpublic tinyint(1) NOT NULL DEFAULT '0' COMMENT '',


    glimit int(11) NOT NULL DEFAULT '0' COMMENT '',


    phpBB int(11) NOT NULL DEFAULT '0' COMMENT '',


    muid int(11) NOT NULL DEFAULT '0' COMMENT '',


    PRIMARY KEY (gid)


) DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;





CREATE TABLE nuke_nsngr_users (


    gid int(11) NOT NULL DEFAULT '0' COMMENT '',


    uid int(11) NOT NULL DEFAULT '0' COMMENT '',


    uname varchar(25) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_general_ci,


    trial tinyint(1) NOT NULL DEFAULT '0' COMMENT '',


    notice tinyint(1) NOT NULL DEFAULT '0' COMMENT '',


    sdate int(14) NOT NULL DEFAULT '0' COMMENT '',


    edate int(14) NOT NULL DEFAULT '0' COMMENT ''


) DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;





CREATE TABLE nuke_quotes (


    qid int(10) unsigned NOT NULL COMMENT '' auto_increment,


    quote text NULL DEFAULT NULL COMMENT '' COLLATE latin1_general_ci,


    PRIMARY KEY (qid)


) DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;





ALTER TABLE nuke_authors


    DROP INDEX aid, DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;





ALTER TABLE nuke_autonews


    MODIFY aid varchar(25) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_general_ci,


    MODIFY informant varchar(25) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_general_ci,


    DROP INDEX anid, DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;


#


#  Fieldformats of


#    nuke_autonews.aid changed from varchar(30) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci to varchar(25) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_general_ci.


#    nuke_autonews.informant changed from varchar(20) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci to varchar(25) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_general_ci.


#  Possibly data modifications needed!


#





ALTER TABLE nuke_banned_ip


    DROP INDEX id, DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;








ALTER TABLE nuke_banner


DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;








ALTER TABLE nuke_banner_clients


DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;








ALTER TABLE nuke_banner_plans


DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;








ALTER TABLE nuke_banner_positions


DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;








ALTER TABLE nuke_banner_terms


DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;








ALTER TABLE nuke_bbauth_access


DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;








ALTER TABLE nuke_bbbanlist


DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;








ALTER TABLE nuke_bbcategories


DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;








ALTER TABLE nuke_bbconfig


DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;








ALTER TABLE nuke_bbdisallow


DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;








ALTER TABLE nuke_bbforum_prune


DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;








ALTER TABLE nuke_bbforums


DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;








ALTER TABLE nuke_bbgroups


DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;








ALTER TABLE nuke_bbposts


DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;








ALTER TABLE nuke_bbposts_text


DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;








ALTER TABLE nuke_bbprivmsgs


DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;








ALTER TABLE nuke_bbprivmsgs_text


DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;








ALTER TABLE nuke_bbranks


DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;








ALTER TABLE nuke_bbsearch_results


DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;








ALTER TABLE nuke_bbsearch_wordlist


DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;








ALTER TABLE nuke_bbsearch_wordmatch


DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;








ALTER TABLE nuke_bbsessions


    DROP PRIMARY KEY,


    DROP INDEX session_id_ip_user_id,


    ADD INDEX session_ip (session_ip),


    ADD INDEX session_id (session_id), DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;








ALTER TABLE nuke_bbsessions_keys


DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;








ALTER TABLE nuke_bbsmilies


DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;








ALTER TABLE nuke_bbthemes


DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;








ALTER TABLE nuke_bbthemes_name


DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;








ALTER TABLE nuke_bbtopics


DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;








ALTER TABLE nuke_bbtopics_watch


DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;








ALTER TABLE nuke_bbuser_group


DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;








ALTER TABLE nuke_bbvote_desc


DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;








ALTER TABLE nuke_bbvote_results


DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;








ALTER TABLE nuke_bbvote_voters


DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;








ALTER TABLE nuke_bbwords


DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;








ALTER TABLE nuke_blocks


    ADD groups text NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_general_ci AFTER view,


    DROP INDEX bid, DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;








ALTER TABLE nuke_cities


DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;








ALTER TABLE nuke_comments


    DROP last_moderation_ip,


    DROP INDEX tid, DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;








DROP TABLE nuke_comments_moderated;





ALTER TABLE nuke_config


    ALTER minpass SET DEFAULT 8,


    ALTER ultramode SET DEFAULT 1,


    ALTER httpref SET DEFAULT 0, DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;








ALTER TABLE nuke_confirm


DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;








ALTER TABLE nuke_counter


DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;








ALTER TABLE nuke_downloads_categories


    DROP INDEX cid, DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;








ALTER TABLE nuke_downloads_downloads


    DROP INDEX lid, DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;








ALTER TABLE nuke_downloads_editorials


    DROP INDEX downloadid, DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;








ALTER TABLE nuke_downloads_modrequest


    DROP INDEX requestid, DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;








ALTER TABLE nuke_downloads_newdownload


    DROP INDEX lid, DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;








ALTER TABLE nuke_downloads_votedata


    DROP INDEX ratingdbid, DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;








ALTER TABLE nuke_encyclopedia


    DROP INDEX eid, DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;








ALTER TABLE nuke_encyclopedia_text


    DROP INDEX tid, DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;








ALTER TABLE nuke_faqanswer


    DROP INDEX id, DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;








ALTER TABLE nuke_faqcategories


    DROP INDEX id_cat, DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;








ALTER TABLE nuke_groups


    DROP INDEX id,


    ADD PRIMARY KEY (id), DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;








ALTER TABLE nuke_groups_points


    DROP INDEX id,


    ADD PRIMARY KEY (id), DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;








ALTER TABLE nuke_headlines


    DROP INDEX hid, DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;








ALTER TABLE nuke_journal


    DROP INDEX jid, DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;








ALTER TABLE nuke_journal_comments


    DROP INDEX cid, DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;








ALTER TABLE nuke_journal_stats


    DROP INDEX id, DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;








ALTER TABLE nuke_links_categories


    DROP INDEX cid, DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;








ALTER TABLE nuke_links_editorials


    DROP INDEX linkid, DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;








ALTER TABLE nuke_links_links


    DROP INDEX lid, DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;








ALTER TABLE nuke_links_modrequest


    DROP INDEX requestid, DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;








ALTER TABLE nuke_links_newlink


    DROP INDEX lid, DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;








ALTER TABLE nuke_links_votedata


    DROP INDEX ratingdbid, DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;








ALTER TABLE nuke_main


DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;








ALTER TABLE nuke_message


    ADD groups text NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_general_ci AFTER view,


    DROP INDEX mid, DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;








ALTER TABLE nuke_modules


    ADD groups text NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_general_ci AFTER view,


    DROP INDEX mid, DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;








ALTER TABLE nuke_nsnst_admins


DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;








ALTER TABLE nuke_nsnst_blocked_ips


DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;








ALTER TABLE nuke_nsnst_blocked_ranges


DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;








ALTER TABLE nuke_nsnst_blockers


DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;








ALTER TABLE nuke_nsnst_cidrs


    MODIFY cidr int(2) NOT NULL COMMENT '' auto_increment, DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;


#


#  Fieldformat of


#    nuke_nsnst_cidrs.cidr changed from int(2) NOT NULL DEFAULT '0' COMMENT '' to int(2) NOT NULL DEFAULT 0 COMMENT '' auto_increment.


#  Possibly data modifications needed!


#





ALTER TABLE nuke_nsnst_config


DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;








ALTER TABLE nuke_nsnst_countries


DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;








ALTER TABLE nuke_nsnst_excluded_ranges


DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;








ALTER TABLE nuke_nsnst_ip2country


DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;








ALTER TABLE nuke_nsnst_protected_ranges


DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;








ALTER TABLE nuke_nsnst_tracked_ips


DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;








ALTER TABLE nuke_pages


    DROP INDEX pid, DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;








ALTER TABLE nuke_pages_categories


    DROP INDEX cid, DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;








ALTER TABLE nuke_poll_check


DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;








ALTER TABLE nuke_poll_data


DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;








ALTER TABLE nuke_poll_desc


    DROP comments,


    DROP INDEX pollID, DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;








ALTER TABLE nuke_pollcomments


    DROP last_moderation_ip,


    DROP INDEX tid, DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;








DROP TABLE nuke_pollcomments_moderated;





ALTER TABLE nuke_public_messages


    DROP INDEX mid, DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;








ALTER TABLE nuke_queue


    DROP INDEX qid, DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;








ALTER TABLE nuke_referer


    DROP INDEX rid, DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;








ALTER TABLE nuke_related


    DROP INDEX rid, DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;








ALTER TABLE nuke_reviews


    MODIFY reviewer varchar(25) NULL DEFAULT NULL COMMENT '' COLLATE latin1_general_ci,


    DROP INDEX id, DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;


#


#  Fieldformat of


#    nuke_reviews.reviewer changed from varchar(20) NULL DEFAULT NULL COMMENT '' COLLATE latin1_swedish_ci to varchar(25) NULL DEFAULT NULL COMMENT '' COLLATE latin1_general_ci.


#  Possibly data modifications needed!


#





ALTER TABLE nuke_reviews_add


    MODIFY reviewer varchar(25) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_general_ci,


    DROP INDEX id, DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;


#


#  Fieldformat of


#    nuke_reviews_add.reviewer changed from varchar(20) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci to varchar(25) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_general_ci.


#  Possibly data modifications needed!


#





ALTER TABLE nuke_reviews_comments


    DROP INDEX cid, DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;








DROP TABLE nuke_reviews_comments_moderated;





ALTER TABLE nuke_reviews_main


DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;








ALTER TABLE nuke_session


DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;








ALTER TABLE nuke_stats_date


DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;








ALTER TABLE nuke_stats_hour


DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;








ALTER TABLE nuke_stats_month


DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;








ALTER TABLE nuke_stats_year


DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;








ALTER TABLE nuke_stories


    MODIFY aid varchar(25) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_general_ci,


    MODIFY informant varchar(25) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_general_ci,


    DROP rating_ip,


    DROP INDEX sid, DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;


#


#  Fieldformats of


#    nuke_stories.aid changed from varchar(30) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci to varchar(25) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_general_ci.


#    nuke_stories.informant changed from varchar(20) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci to varchar(25) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_general_ci.


#  Possibly data modifications needed!


#





ALTER TABLE nuke_stories_cat


    DROP INDEX catid, DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;








ALTER TABLE nuke_subscriptions


    MODIFY userid int(10) NOT NULL DEFAULT '0' COMMENT '',


    DROP INDEX id,


    ADD PRIMARY KEY (id, userid), DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;


#


#  Fieldformat of


#    nuke_subscriptions.userid changed from int(10) NULL DEFAULT '0' COMMENT '' to int(10) NOT NULL DEFAULT '0' COMMENT ''.


#  Possibly data modifications needed!


#





ALTER TABLE nuke_topics


    MODIFY topicimage varchar(20) NULL DEFAULT NULL COMMENT '' COLLATE latin1_general_ci,


    DROP INDEX topicid, DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;


#


#  Fieldformat of


#    nuke_topics.topicimage changed from varchar(100) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci to varchar(20) NULL DEFAULT NULL COMMENT '' COLLATE latin1_general_ci.


#  Possibly data modifications needed!


#





ALTER TABLE nuke_users


    ADD user_login_tries smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '' AFTER last_ip,


    ADD user_last_login_try int(11) NOT NULL DEFAULT '0' COMMENT '' AFTER user_login_tries,


    MODIFY bio tinytext NULL DEFAULT NULL COMMENT '' COLLATE latin1_general_ci,


    MODIFY ublock tinytext NULL DEFAULT NULL COMMENT '' COLLATE latin1_general_ci,


    DROP karma,


    DROP INDEX uid,


    DROP INDEX karma, DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;


#


#  Fieldformats of


#    nuke_users.bio changed from tinytext NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci to tinytext NULL DEFAULT NULL COMMENT '' COLLATE latin1_general_ci.


#    nuke_users.ublock changed from tinytext NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci to tinytext NULL DEFAULT NULL COMMENT '' COLLATE latin1_general_ci.


#  Possibly data modifications needed!


#





ALTER TABLE nuke_users_temp


    ADD requestor varchar(25) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_general_ci AFTER time, DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;








#


# DDL END


#





SET FOREIGN_KEY_CHECKS = 1;

registered · Posted: Sun Mar 18, 2007 9:50 am

I hope you do not mind, but I have made this a Sticky. At the same time, I want to use this as an opportunity to mention a few learnings that I have had with regards to MySQLDiff as well as specific to this type of migration. I hope that you do not mind.

1) I can see that you had checked (it defaults to it) with MySQLDiff the option to show differences in character sets. This can actually cause you issues and I recommend unchecking that. I have found incompatibilities as I move databases around from one environment to the next when I leave the charset statements in there.

Some folks are going to be coming from different character set settings. So, everyone, please just keep this in mind. You may want to strip out all the CHARSET and COLLATE attributes.

2) If you already have the HTML NEwsletter installed on your 7.9 site, you should strip out the CREATE for these tables or just realize that you will get errors in phpMyAdmin that might prevent you from continuing.

3) Also, if you already had NSN Groups installed, you will get additional errors, so you will need to analyze those. In this case, you would want to remove the ALTER statements for nuke_blocks, nuke_messages and nuke_modules. In addition, you would want to remove the CREATEs for tables nuke_nsngr_config, nuke_nsngr_groups, and nuke_nsngr_users.

4) I also do not like how the nuke indexes are being dropped. This is definitely something we should look more into with a future release. I think with some large sites, better indexing could be a tremendous help (along with more efficient SQL calls).

That is all I can think of right now.

Thanks for sharing this, because I am sure it is going to be of help to some who choose to do this downgrade.

Posted: Sun Mar 18, 2007 11:59 am

I think each person should run mysqldiff themselves. It isn't that hard. But I provided this for those that didn't want to or didn't know how.

It is surprising at how many indexes got dropped. But that just means they got added after 7.6.

I was also surprised to see that I got the bbconfirm table. Is this used? How come I didn't need it before?

I also scratched my head on the char set and collation things. In my case it didn't matter. But good point. If I had shut that off the file would be a lot smaller.

registered · Posted: Wed Mar 21, 2007 3:07 pm

bbconfirm table is used with phpBB's image verification. It previously did not work when turned on

New Member Joined: Apr 05, 2007 Posts: 18

THANK YOU GREMMIE!!!!!!!!!!

Apparently I had a partially converted database. UGGHHHHHHHHH! Going through your script and running each query individually worked for the most part. Somehow ended up with the nuke_stories table having issues, but oh well. Working on a clean RN table and I'll just have to input some of the data manually.

This should work for those that haven't already messed things up previously.

Posted: Mon Apr 16, 2007 6:56 am

I'm glad someone got some use out of it. If I had to do it over again I would probably omit the queries that simply altered the character sets and/or dropped indices.