Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2012
    Posts
    2

    Unanswered: URGENT! MySQL import

    I am using Sequel Pro to import from an old database. I have successfully imported from the old database into my new one. I am connecting the database to an expression engine forum. After importing all the data some items for example, member id do not show up so the forum thread is not being read and not showing the thread that was posted by this user. Can anyone help?? Any help is appreciated. Thank you.

  2. #2
    Join Date
    Sep 2009
    Location
    San Sebastian, Spain
    Posts
    880
    Did you check if the data exists in the database and match the values from the old database? If this does not match then it is likely that these values were not exported correctly and that auto incremented values were added which will leave the data model in an inconsistent state.
    Ronan Cashell
    Certified Oracle DBA/Certified MySQL Expert (DBA & Cluster DBA)
    http://www.it-iss.com
    Follow me on Twitter

  3. #3
    Join Date
    Jun 2012
    Posts
    2
    ok so yeah I feel kinda stupid. So the data in the new tables doesn't match so thats why its not showing up. how would i join the tables these are the tables I have now,

    `exp_forum_topics` (
    `topic_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `forum_id` int(6) unsigned NOT NULL,
    `board_id` int(6) unsigned NOT NULL DEFAULT '2',
    `pentry_id` int(10) unsigned NOT NULL DEFAULT '0',
    `moved_forum_id` int(6) unsigned NOT NULL DEFAULT '0',
    `author_id` int(10) unsigned NOT NULL DEFAULT '0',
    `ip_address` varchar(16) NOT NULL,
    `title` varchar(150) NOT NULL,
    `body` text NOT NULL,
    `status` char(1) NOT NULL DEFAULT 'o',
    `sticky` char(1) NOT NULL DEFAULT 'n',
    `poll` char(1) NOT NULL DEFAULT 'n',
    `announcement` char(1) NOT NULL DEFAULT 'n',
    `topic_date` datetime NOT NULL,
    `topic_edit_date` int(10) unsigned NOT NULL DEFAULT '0',
    `topic_edit_author` int(10) unsigned NOT NULL DEFAULT '0',
    `thread_total` int(5) unsigned NOT NULL DEFAULT '0',
    `thread_views` int(6) unsigned NOT NULL DEFAULT '0',
    `last_post_date` int(11) NOT NULL DEFAULT '0',
    `last_post_author_id` int(10) unsigned NOT NULL DEFAULT '0',
    `last_post_id` int(10) unsigned NOT NULL DEFAULT '0',
    `notify` char(1) NOT NULL DEFAULT 'n',
    `parse_smileys` char(1) NOT NULL DEFAULT 'y',
    PRIMARY KEY (`topic_id`),
    KEY `forum_id` (`forum_id`),
    KEY `board_id` (`board_id`),
    KEY `author_id` (`author_id`),
    KEY `last_post_author_id` (`last_post_author_id`),
    KEY `topic_date` (`topic_date`)
    ) ENGINE=MyISAM AUTO_INCREMENT=6679 DEFAULT CHARSET=utf8;






    CREATE TABLE `exp_forum_posts` (
    `post_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `topic_id` int(10) unsigned NOT NULL,
    `forum_id` int(6) unsigned NOT NULL DEFAULT '1',
    `board_id` int(6) unsigned NOT NULL DEFAULT '2',
    `author_id` int(10) unsigned NOT NULL DEFAULT '0',
    `ip_address` varchar(16) NOT NULL,
    `body` text NOT NULL,
    `post_date` int(10) NOT NULL DEFAULT '0',
    `post_edit_date` int(10) NOT NULL DEFAULT '0',
    `post_edit_author` int(10) unsigned NOT NULL DEFAULT '0',
    `notify` char(1) NOT NULL DEFAULT 'n',
    `parse_smileys` char(1) NOT NULL DEFAULT 'y',
    PRIMARY KEY (`post_id`),
    KEY `topic_id` (`topic_id`),
    KEY `forum_id` (`forum_id`),
    KEY `board_id` (`board_id`),
    KEY `author_id` (`author_id`)
    ) ENGINE=MyISAM AUTO_INCREMENT=192 DEFAULT CHARSET=utf8;






    CREATE TABLE `exp_members` (
    `member_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `group_id` smallint(4) NOT NULL DEFAULT '0',
    `username` varchar(50) NOT NULL,
    `screen_name` varchar(50) NOT NULL,
    `password` varchar(128) NOT NULL,
    `salt` varchar(128) NOT NULL DEFAULT '',
    `unique_id` varchar(40) NOT NULL,
    `crypt_key` varchar(40) DEFAULT NULL,
    `authcode` varchar(10) DEFAULT NULL,
    `email` varchar(72) NOT NULL,
    `url` varchar(150) DEFAULT NULL,
    `location` varchar(50) DEFAULT NULL,
    `occupation` varchar(80) DEFAULT NULL,
    `interests` varchar(120) DEFAULT NULL,
    `bday_d` int(2) DEFAULT NULL,
    `bday_m` int(2) DEFAULT NULL,
    `bday_y` int(4) DEFAULT NULL,
    `aol_im` varchar(50) DEFAULT NULL,
    `yahoo_im` varchar(50) DEFAULT NULL,
    `msn_im` varchar(50) DEFAULT NULL,
    `icq` varchar(50) DEFAULT NULL,
    `bio` text,
    `signature` text,
    `avatar_filename` varchar(120) DEFAULT NULL,
    `avatar_width` int(4) unsigned DEFAULT NULL,
    `avatar_height` int(4) unsigned DEFAULT NULL,
    `photo_filename` varchar(120) DEFAULT NULL,
    `photo_width` int(4) unsigned DEFAULT NULL,
    `photo_height` int(4) unsigned DEFAULT NULL,
    `sig_img_filename` varchar(120) DEFAULT NULL,
    `sig_img_width` int(4) unsigned DEFAULT NULL,
    `sig_img_height` int(4) unsigned DEFAULT NULL,
    `ignore_list` text,
    `private_messages` int(4) unsigned NOT NULL DEFAULT '0',
    `accept_messages` char(1) NOT NULL DEFAULT 'y',
    `last_view_bulletins` int(10) NOT NULL DEFAULT '0',
    `last_bulletin_date` int(10) NOT NULL DEFAULT '0',
    `ip_address` varchar(45) NOT NULL DEFAULT '0',
    `join_date` int(10) unsigned NOT NULL DEFAULT '0',
    `last_visit` int(10) unsigned NOT NULL DEFAULT '0',
    `last_activity` int(10) unsigned NOT NULL DEFAULT '0',
    `total_entries` smallint(5) unsigned NOT NULL DEFAULT '0',
    `total_comments` smallint(5) unsigned NOT NULL DEFAULT '0',
    `total_forum_topics` mediumint(8) NOT NULL DEFAULT '0',
    `total_forum_posts` mediumint(8) NOT NULL DEFAULT '0',
    `last_entry_date` int(10) unsigned NOT NULL DEFAULT '0',
    `last_comment_date` int(10) unsigned NOT NULL DEFAULT '0',
    `last_forum_post_date` int(10) unsigned NOT NULL DEFAULT '0',
    `last_email_date` int(10) unsigned NOT NULL DEFAULT '0',
    `in_authorlist` char(1) NOT NULL DEFAULT 'n',
    `accept_admin_email` char(1) NOT NULL DEFAULT 'y',
    `accept_user_email` char(1) NOT NULL DEFAULT 'y',
    `notify_by_default` char(1) NOT NULL DEFAULT 'y',
    `notify_of_pm` char(1) NOT NULL DEFAULT 'y',
    `display_avatars` char(1) NOT NULL DEFAULT 'y',
    `display_signatures` char(1) NOT NULL DEFAULT 'y',
    `parse_smileys` char(1) NOT NULL DEFAULT 'y',
    `smart_notifications` char(1) NOT NULL DEFAULT 'y',
    `language` varchar(50) NOT NULL,
    `timezone` varchar(8) NOT NULL,
    `daylight_savings` char(1) NOT NULL DEFAULT 'n',
    `localization_is_site_default` char(1) NOT NULL DEFAULT 'n',
    `time_format` char(2) NOT NULL DEFAULT 'us',
    `cp_theme` varchar(32) DEFAULT NULL,
    `profile_theme` varchar(32) DEFAULT NULL,
    `forum_theme` varchar(32) DEFAULT NULL,
    `tracker` text,
    `template_size` varchar(2) NOT NULL DEFAULT '20',
    `notepad` text,
    `notepad_size` varchar(2) NOT NULL DEFAULT '18',
    `quick_links` text,
    `quick_tabs` text,
    `show_sidebar` char(1) NOT NULL DEFAULT 'n',
    `pmember_id` int(10) NOT NULL DEFAULT '0',
    PRIMARY KEY (`member_id`),
    KEY `group_id` (`group_id`),
    KEY `unique_id` (`unique_id`),
    KEY `password` (`password`)
    ) ENGINE=MyISAM AUTO_INCREMENT=8384 DEFAULT CHARSET=utf8;




    how would I join all these tables together that way the member ID is found as the author id that way the threads can be found and printed out in my forum???


    Thanks for the fast reply.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •