Upgrading from v2.02.02

ciph3r · Worker Joined: Jun 01, 2005 Posts: 176

montego, I couldnt figure out how to do it in phpmyadmin. Ill look around a bit more.

dad7732, yes i installed it under my admin account on xp.

montego · Posted: Mon Jun 09, 2008 5:24 am

If you go to "Privileges", in there, you can elect to "Add New User". Once the user is added, you can then select that user from the Privileges list and then assign database-level permissions to it.

ciph3r · Worker Joined: Jun 01, 2005 Posts: 176

Thanks montego, I actually figured it out on my own (w00t).

I have XXAMPP installed, and all is running well.

This is what ive done so far:

1. Installed the latest RNUKE "stock" with no modifications. (in the db rnuke2)

2. I put bigdump, and mySQLdiff in the new install for use.

3. Ran bigdump to import my old db into a db called "rnuke1"

4. Ran MySQLDiff to try to figure out what changes need to be made (using these options)

Source DB: rnuke1 <---- Old Install
Target DB: rnuke2 <---- New Install

Response:

Code:

#
# MySQLDiff 1.5.0
#
# http://www.mysqldiff.org
# (c) 2001-2004, Lippe-Net Online-Service
#
# Create time: 09.06.2008 19:03
#
# --------------------------------------------------------
# Source info
# Host: localhost
# Database: rnuke1
# --------------------------------------------------------
# Target info
# Host: localhost
# Database: rnuke2
# --------------------------------------------------------
#

SET FOREIGN_KEY_CHECKS = 0;

#
# DDL START
#
CREATE TABLE nuke_banner_clients (
cid int(11) NOT NULL DEFAULT 0 COMMENT '' auto_increment,
name varchar(60) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
contact varchar(60) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
email varchar(60) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
login varchar(10) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
passwd varchar(10) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
extrainfo text NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
PRIMARY KEY (cid),
INDEX cid (cid)
) DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

CREATE TABLE nuke_banner_plans (
pid int(10) NOT NULL DEFAULT 0 COMMENT '' auto_increment,
active tinyint(1) NOT NULL DEFAULT '0' COMMENT '',
name varchar(255) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
description text NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
delivery varchar(10) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
delivery_type varchar(25) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
price varchar(25) NOT NULL DEFAULT '0' COMMENT '' COLLATE latin1_swedish_ci,
buy_links text NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
PRIMARY KEY (pid)
) DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

CREATE TABLE nuke_banner_positions (
apid int(10) NOT NULL DEFAULT 0 COMMENT '' auto_increment,
position_number int(5) NOT NULL DEFAULT '0' COMMENT '',
position_name varchar(255) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
PRIMARY KEY (apid),
INDEX position_number (position_number)
) DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

CREATE TABLE nuke_banner_terms (
terms_body text NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
country varchar(255) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci
) DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

CREATE TABLE nuke_gcal_cat_group (
id int(11) NOT NULL DEFAULT 0 COMMENT '' auto_increment,
cat_id int(11) NOT NULL DEFAULT 0 COMMENT '',
group_id int(11) NOT NULL DEFAULT 0 COMMENT '',
PRIMARY KEY (id),
INDEX cat_id (cat_id),
INDEX group_id (group_id)
) DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

CREATE TABLE nuke_gcal_category (
id int(11) NOT NULL DEFAULT 0 COMMENT '' auto_increment,
name varchar(128) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
PRIMARY KEY (id)
) DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

CREATE TABLE nuke_gcal_config (
id int(11) NOT NULL DEFAULT 0 COMMENT '' auto_increment,
title varchar(128) NOT NULL DEFAULT 'Calendar of Events' COMMENT '' COLLATE latin1_swedish_ci,
image varchar(255) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
min_year int(10) unsigned NOT NULL DEFAULT '2006' COMMENT '',
max_year int(10) unsigned NOT NULL DEFAULT '2037' COMMENT '',
user_submit enum('off','members','anyone','groups') NOT NULL DEFAULT 'off' COMMENT '' COLLATE latin1_swedish_ci,
req_approval tinyint(1) NOT NULL DEFAULT '1' COMMENT '',
allowed_tags text NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
allowed_attrs text NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
version varchar(16) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
time_in_24 tinyint(1) NOT NULL DEFAULT '0' COMMENT '',
short_date_format varchar(16) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
reg_date_format varchar(16) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
long_date_format varchar(16) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
first_day_of_week tinyint(1) NOT NULL DEFAULT '0' COMMENT '',
auto_link tinyint(1) NOT NULL DEFAULT '0' COMMENT '',
location_required tinyint(1) NOT NULL DEFAULT '0' COMMENT '',
details_required tinyint(1) NOT NULL DEFAULT '0' COMMENT '',
email_notify tinyint(1) NOT NULL DEFAULT '0' COMMENT '',
email_to varchar(255) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
email_subject varchar(255) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
email_msg varchar(255) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
email_from varchar(255) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
show_cat_legend tinyint(1) NOT NULL DEFAULT '1' COMMENT '',
wysiwyg tinyint(1) NOT NULL DEFAULT '0' COMMENT '',
user_update tinyint(1) NOT NULL DEFAULT '0' COMMENT '',
weekends set('0','1','2','3','4','5','6') NOT NULL DEFAULT '0,6' COMMENT '' COLLATE latin1_swedish_ci,
rsvp enum('off','on','email') NOT NULL DEFAULT 'off' COMMENT '' COLLATE latin1_swedish_ci,
rsvp_email_subject varchar(255) NOT NULL DEFAULT 'Event RSVP Notification' COMMENT '' COLLATE latin1_swedish_ci,
groups_submit text NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
groups_no_approval text NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
PRIMARY KEY (id)
) DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

CREATE TABLE nuke_gcal_event (
id int(11) NOT NULL DEFAULT 0 COMMENT '' auto_increment,
title varchar(255) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
no_time tinyint(1) NOT NULL DEFAULT '1' COMMENT '',
start_time time NOT NULL DEFAULT '00:00:00' COMMENT '',
end_time time NOT NULL DEFAULT '00:00:00' COMMENT '',
location text NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
category int(11) NOT NULL DEFAULT '0' COMMENT '',
repeat_type enum('none','daily','weekly','monthly','yearly') NOT NULL DEFAULT 'none' COMMENT '' COLLATE latin1_swedish_ci,
details text NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
interval_val int(11) NOT NULL DEFAULT '0' COMMENT '',
no_end_date tinyint(1) NOT NULL DEFAULT '1' COMMENT '',
start_date date NOT NULL DEFAULT '0000-00-00' COMMENT '',
end_date date NOT NULL DEFAULT '0000-00-00' COMMENT '',
weekly_days set('0','1','2','3','4','5','6') NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
monthly_by_day tinyint(1) NOT NULL DEFAULT '0' COMMENT '',
submitted_by varchar(25) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
approved tinyint(1) NOT NULL DEFAULT '0' COMMENT '',
rsvp enum('off','on','email') NOT NULL DEFAULT 'off' COMMENT '' COLLATE latin1_swedish_ci,
PRIMARY KEY (id),
INDEX approved (approved),
INDEX start_date (start_date),
INDEX repeat_type (repeat_type)
) DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

CREATE TABLE nuke_gcal_exception (
id int(11) NOT NULL DEFAULT 0 COMMENT '' auto_increment,
event_id int(11) NOT NULL DEFAULT 0 COMMENT '',
`date` date NOT NULL DEFAULT '0000-00-00' COMMENT '',
PRIMARY KEY (id),
INDEX event_id (event_id),
INDEX `date` (`date`)
) DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

CREATE TABLE nuke_gcal_rsvp (
id int(11) NOT NULL DEFAULT 0 COMMENT '' auto_increment,
event_id int(11) NOT NULL DEFAULT 0 COMMENT '',
user_id int(11) NOT NULL DEFAULT 0 COMMENT '',
PRIMARY KEY (id),
INDEX event_id (event_id, user_id)
) DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

CREATE TABLE nuke_hnl_categories (
cid int(11) NOT NULL DEFAULT 0 COMMENT '' auto_increment,
ctitle varchar(50) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
cdescription text NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
cblocklimit int(4) NOT NULL DEFAULT '10' COMMENT '',
PRIMARY KEY (cid)
) DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

CREATE TABLE nuke_hnl_cfg (
cfg_nm varchar(255) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
cfg_val longtext NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
PRIMARY KEY (cfg_nm)
) DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

CREATE TABLE nuke_hnl_newsletters (
nid int(11) NOT NULL DEFAULT 0 COMMENT '' auto_increment,
cid int(11) NOT NULL DEFAULT '1' COMMENT '',
topic varchar(100) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
sender varchar(20) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
filename varchar(32) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
datesent date NULL DEFAULT NULL COMMENT '',
view int(1) NOT NULL DEFAULT '0' COMMENT '',
groups text NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
hits int(11) NOT NULL DEFAULT '0' COMMENT '',
PRIMARY KEY (nid),
INDEX cid (cid)
) DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

CREATE TABLE nuke_seo_config (
config_type varchar(255) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
config_name varchar(255) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
config_value text NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
PRIMARY KEY (config_type, config_name)
) DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

CREATE TABLE nuke_seo_disabled_modules (
title varchar(255) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
seo_module varchar(255) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
PRIMARY KEY (title, seo_module)
) DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

CREATE TABLE nuke_seo_feed (
fid int(6) NOT NULL DEFAULT 0 COMMENT '' auto_increment,
content varchar(20) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
name varchar(20) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
level varchar(20) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
lid int(6) NOT NULL DEFAULT 0 COMMENT '',
title varchar(50) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
`desc` text NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
`order` varchar(20) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
howmany char(3) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
active int(1) NOT NULL DEFAULT 0 COMMENT '',
desclimit varchar(5) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
securitycode varchar(50) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
cachetime varchar(6) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
feedburner_address varchar(100) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
PRIMARY KEY (fid),
INDEX content (content, title)
) DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

CREATE TABLE nuke_seo_subscriptions (
sid int(6) NOT NULL DEFAULT 0 COMMENT '' auto_increment,
type varchar(256) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
name varchar(60) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
tagline varchar(60) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
image varchar(256) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
icon varchar(256) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
url varchar(256) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
active int(1) NOT NULL DEFAULT 0 COMMENT '',
PRIMARY KEY (sid)
) DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

ALTER TABLE nuke_authors
DROP INDEX aid;

ALTER TABLE nuke_autonews
DROP INDEX anid;

ALTER TABLE nuke_banned_ip
DROP INDEX id;

ALTER TABLE nuke_banner
ADD name varchar(50) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci AFTER cid,
ADD position int(10) NOT NULL DEFAULT '0' COMMENT '' AFTER dateend,
ADD ad_class varchar(5) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci AFTER active,
ADD ad_code text NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci AFTER ad_class,
ADD ad_width int(4) NULL DEFAULT '0' COMMENT '' AFTER ad_code,
ADD ad_height int(4) NULL DEFAULT '0' COMMENT '' AFTER ad_width,
DROP type;

DROP TABLE nuke_bannerclient;

ALTER TABLE nuke_bbforums
DROP forum_parent;

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);

ALTER TABLE nuke_blocks
DROP INDEX bid;

DROP TABLE nuke_cities;

DROP TABLE nuke_clockcalendar;

ALTER TABLE nuke_comments
DROP INDEX tid;

ALTER TABLE nuke_config
ALTER minpass SET DEFAULT 8,
ALTER ultramode SET DEFAULT 1,
ALTER httpref SET DEFAULT 0;

DROP TABLE nuke_donators;

DROP TABLE nuke_donators_config;

DROP TABLE nuke_donators_settings;

ALTER TABLE nuke_downloads_categories
DROP INDEX cid;

ALTER TABLE nuke_downloads_downloads
DROP INDEX lid;

ALTER TABLE nuke_downloads_editorials
DROP INDEX downloadid;

ALTER TABLE nuke_downloads_modrequest
DROP INDEX requestid;

ALTER TABLE nuke_downloads_newdownload
DROP INDEX lid;

ALTER TABLE nuke_downloads_votedata
DROP INDEX ratingdbid;

ALTER TABLE nuke_encyclopedia
DROP INDEX eid;

ALTER TABLE nuke_encyclopedia_text
DROP INDEX tid;

ALTER TABLE nuke_faqanswer
DROP INDEX id;

ALTER TABLE nuke_faqcategories
DROP INDEX id_cat;

DROP TABLE nuke_g2config;

ALTER TABLE nuke_groups
DROP INDEX id,
ADD PRIMARY KEY (id);

ALTER TABLE nuke_groups_points
DROP INDEX id,
ADD PRIMARY KEY (id);

ALTER TABLE nuke_headlines
DROP INDEX hid;

ALTER TABLE nuke_journal
DROP INDEX jid;

ALTER TABLE nuke_journal_comments
DROP INDEX cid;

ALTER TABLE nuke_journal_stats
DROP INDEX id;

ALTER TABLE nuke_links_categories
DROP INDEX cid;

ALTER TABLE nuke_links_editorials
DROP INDEX linkid;

ALTER TABLE nuke_links_links
DROP INDEX lid;

ALTER TABLE nuke_links_modrequest
DROP INDEX requestid;

ALTER TABLE nuke_links_newlink
DROP INDEX lid;

ALTER TABLE nuke_links_votedata
DROP INDEX ratingdbid;

ALTER TABLE nuke_message
DROP INDEX mid;

ALTER TABLE nuke_modules
DROP INDEX mid;

ALTER TABLE nuke_nsnst_cidrs
MODIFY cidr int(2) NOT NULL DEFAULT 0 COMMENT '' auto_increment;
#
# 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!
#

DROP TABLE nuke_optimize_gain;

ALTER TABLE nuke_pages
DROP INDEX pid;

ALTER TABLE nuke_pages_categories
DROP INDEX cid;

ALTER TABLE nuke_poll_desc
DROP comments,
DROP INDEX pollID;

ALTER TABLE nuke_pollcomments
DROP INDEX tid;

ALTER TABLE nuke_public_messages
DROP INDEX mid;

ALTER TABLE nuke_queue
DROP INDEX qid;

ALTER TABLE nuke_quotes
DROP INDEX qid;

ALTER TABLE nuke_referer
DROP INDEX rid;

ALTER TABLE nuke_related
DROP INDEX rid;

ALTER TABLE nuke_reviews
DROP INDEX id;

ALTER TABLE nuke_reviews_add
DROP INDEX id;

ALTER TABLE nuke_reviews_comments
DROP INDEX cid;

DROP TABLE nuke_shoutbox_censor;

DROP TABLE nuke_shoutbox_conf;

DROP TABLE nuke_shoutbox_date;

DROP TABLE nuke_shoutbox_emoticons;

DROP TABLE nuke_shoutbox_ipblock;

DROP TABLE nuke_shoutbox_manage_count;

DROP TABLE nuke_shoutbox_nameblock;

DROP TABLE nuke_shoutbox_shouts;

DROP TABLE nuke_shoutbox_sticky;

DROP TABLE nuke_shoutbox_theme_images;

DROP TABLE nuke_shoutbox_themes;

DROP TABLE nuke_shoutbox_version;

ALTER TABLE nuke_stories
DROP INDEX sid;

ALTER TABLE nuke_stories_cat
DROP INDEX catid;

ALTER TABLE nuke_subscriptions
MODIFY userid int(10) NOT NULL DEFAULT '0' COMMENT '',
DROP INDEX id,
ADD PRIMARY KEY (id, userid);
#
# 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!
#

DROP TABLE nuke_themecpanel;

ALTER TABLE nuke_topics
MODIFY topicimage varchar(20) NULL DEFAULT NULL COMMENT '' COLLATE latin1_swedish_ci,
DROP INDEX topicid;
#
# 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_swedish_ci.
# Possibly data modifications needed!
#

ALTER TABLE nuke_users
MODIFY user_sig varchar(255) NULL DEFAULT NULL COMMENT '' COLLATE latin1_swedish_ci,
MODIFY bio tinytext NULL DEFAULT NULL COMMENT '' COLLATE latin1_swedish_ci,
MODIFY ublock tinytext NULL DEFAULT NULL COMMENT '' COLLATE latin1_swedish_ci;
#
# Fieldformats of
# nuke_users.user_sig changed from text NULL DEFAULT NULL COMMENT '' COLLATE latin1_swedish_ci to varchar(255) NULL DEFAULT NULL COMMENT '' COLLATE latin1_swedish_ci.
# nuke_users.bio changed from tinytext NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci to tinytext NULL DEFAULT NULL COMMENT '' COLLATE latin1_swedish_ci.
# nuke_users.ublock changed from tinytext NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci to tinytext NULL DEFAULT NULL COMMENT '' COLLATE latin1_swedish_ci.
# Possibly data modifications needed!
#

ALTER TABLE nuke_users_temp
ADD requestor varchar(25) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci AFTER time;

DROP TABLE nuke_whoiswhere;

#
# DDL END
#

SET FOREIGN_KEY_CHECKS = 1;

© 2001-2004, Lippe-Net Online-Service

Now, if I click "send" it lets me download the SQL file. Im guessing if I click "switch" it will convert the DB for me. . . . or will it revert and backwards convert from rnuke2 to rnuke1? (im really not sure, I tried, and the tables look different).

Am I doing this right?

ciph3r · Worker Joined: Jun 01, 2005 Posts: 176

Actually, after pulling my head outta my own ass and looking for myself, I see it changed a table name from the new DB to a name from the old one.

Ok, so send, and import. . . trying now.

ciph3r · Worker Joined: Jun 01, 2005 Posts: 176

Ok, now im getting:

Code:

MySQL: Invalid default value for 'cid'

.

My head hurts. . .

ciph3r · Worker Joined: Jun 01, 2005 Posts: 176

any ideas?

montego · Posted: Fri Jun 13, 2008 5:56 am

ciph3r, the point of doing the comparison is not to have it make all the changes for you. If you run that SQL, you will remove a bunch of tables that you had in your original install (such as the shout box stuff). I guess its ok if you meant to go completely "clean", but the difference is to highlight things for your review.

Personally, I take down the sql and then go through it removing what I don't want/need. I would remove the CREATEs for anything prefixed with nuke_gcal_, nuke_hnl_ and nuke_seo_. For these, since they require also what I call "seed data", it would be better to just move the entire tables and their data over to your "old db".

In your original comparison settings, I would also set the "Alter charset" to "No".

ciph3r · Worker Joined: Jun 01, 2005 Posts: 176

Well, I got a 1 week paid vacation from work, and im wanting to get this done.

At this point, I want to test out all of the newest versions features from scratch.

I have the core RNUKE installed in XXAMPP, and all I want to do at this time, is import the forums, and the users.

The blocks, news. . . whatever else. . . i dont care about.
I can install the modules one at a time and work the bugs out then, but when it comes to just importing the forums. . . and users. . . what would it require?

I was thinking about just installing the old DB, and the new one in the phpadmin in xxampp, and then importing the tables for the forums and users. . . then running the rnuke upgrade script. . . . would that be ok?

montego · Posted: Thu Jun 26, 2008 5:10 am

No, I would keep off-line backups of both databases and then...

1. Use MySQLDiff to compare the two databases and produce the results.

2. Copy the SQL statements to a text file.

3. Edit that text file of SQL statements to remove anything that is not related to nuke_bb* and nuke_user*.

4. Apply the edited SQL file to your OLD database to make those tables MATCH the RavenNuke tables.

5. Export just those same tables' data from your OLD database now into your RavenNuke. You get some errors because of data already being in some of your RavenNuke Tables. You could actually remove the data from these same tables ahead of time (in the RavenNuke database) and try your import. I have a feeling that if you took all those mentioned tables, you should be ok in the end.

Good luck. And just remember, since you have off-line copies of both databases PRIOR to starting this effort, you can re-run this cycle as many times as you like until you get it right!

ciph3r · Worker Joined: Jun 01, 2005 Posts: 176

Ok, thanks.

So far Ive got the source (rnuke1-old), and target (rnuke2-new) in mysqldiff.

I run it and get the results.

Ive read up on the mysqldiff site, and im a little confused at what im looking at.

Now, I know im looking at the structure of the database (the tables) but with those options checked. . . what exactly is this telling me?

These are all the tables in the rnuke2 db that are different from the rnuke1?

There just looks like to many differences:

For example:
In the new rnuke2 db, I have this:

Code:

nuke_banner_clients

In the old DB (rnuke1), I have this:

Code:

nuke_bannerclient

Is this something I must have screwed up during my original install of the old site, or is this an expected change?

The reason I ask, is because as stated above im not interested in the integrity of the rest of the site. . . since its a clean RNUKE install. . . I just want to keep my users and forums.

Is there something I should be looking for?

ciph3r · Worker Joined: Jun 01, 2005 Posts: 176

Sorry if im not supposed to do this, but im using this next post to document what i "think" needs to be done. . . for other users in the RN community.

Ok, installed the stock RNUKE tables from the latest version of RNUKE, in "rnuke2".
I have my old Database (rnuke1) in PhpMyAdmin.

I ran MySQLDiff. . . with both databases.
I looked at the nuke_users table, and noticed this:

Code:

ALTER TABLE nuke_users
MODIFY user_sig varchar(255) NULL DEFAULT NULL COMMENT '' COLLATE latin1_swedish_ci,
MODIFY bio tinytext NULL DEFAULT NULL COMMENT '' COLLATE latin1_swedish_ci,
MODIFY ublock tinytext NULL DEFAULT NULL COMMENT '' COLLATE latin1_swedish_ci;

Now, im guessing this is what is needed to be changed in the old DB (rnuke1) to make it current with the latest RavenNuke core tables.

I didnt see any difference in the _bb_* sections of the database, except this:

Code:

ALTER TABLE nuke_bbforums
DROP forum_parent;

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);

Now, I know the 'DROP forum_parent;' was added when I did the SubForums mod. The nuke_bbsessions section, is what I need to add to the old rnuke1 database to make it current with what I want in the new install?

Guardian2003 · Site Admin Joined: Aug 28, 2003 Posts: 4647

I have a migraine this morning so I have not fully digested this thread. I am assuming the objective is to convert the structureyour old database[b/] so you can then import the data from that into a new RN empty database?
If that is the case;
This is correct as stated above

Code:

ALTER TABLE nuke_users
MODIFY user_sig varchar(255) NULL DEFAULT NULL COMMENT '' COLLATE latin1_swedish_ci,
MODIFY bio tinytext NULL DEFAULT NULL COMMENT '' COLLATE latin1_swedish_ci,
MODIFY ublock tinytext NULL DEFAULT NULL COMMENT '' COLLATE latin1_swedish_ci;

This is also correct

Code:

ALTER TABLE nuke_bbforums
DROP forum_parent;

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);

The table [b]nuke_banner_clients[/] in your NEW database is correct. The table was added to support the new advertising module.
The table [b]nuke_bannerclient in your OLD database is not required as it was dropped so there is no need to created that in the NEW database.

Hope that helps

montego · Posted: Fri Jun 27, 2008 6:22 am

OH, one thing that I do is uncheck the CHARSET option in the list of options. It is better to not have that and your ALTER statements will be much more compact and readable.

Guardian, of course, is spot on. Wink