Help needed in Redirecting a Database?

Discussion in 'MySQL' started by amitash, Jan 23, 2010.

  1. #1
    Hello,
    I have 2 sites www.site1.com and www.site2.com.
    The Site 1 is fully finctional and has about 200 nice articles and 500 users. These settings are stored in a database (Database 1). Other functions like site Name, Meta Tags are also stored in seperate Tables in the same database.

    I have created Site 2 as well. I want it to completely use the User and Articles from Site 1 Database. However it should have its own metatags and name. How can i instruct Articles and Users table in database 2 to redirect to Database 1.

    Here are the Table Structures:
    The following is the Table Structure for Articles in Database 1. It is the same in Database 2 as well. But i want it to redirect to Database 1. This way i can save database space. Even though Articles will be same.
    CREATE TABLE IF NOT EXISTS `dle_post` (
      `id` int(11) NOT NULL auto_increment,
      `autor` varchar(40) NOT NULL default '',
      `date` datetime NOT NULL default '0000-00-00 00:00:00',
      `short_story` text NOT NULL,
      `full_story` text NOT NULL,
      `xfields` text NOT NULL,
      `title` varchar(255) NOT NULL default '',
      `descr` varchar(200) NOT NULL default '',
      `keywords` text NOT NULL,
      `category` varchar(200) NOT NULL default '0',
      `alt_name` varchar(200) NOT NULL default '',
      `comm_num` smallint(5) unsigned NOT NULL default '0',
      `allow_comm` tinyint(1) NOT NULL default '1',
      `allow_main` tinyint(1) unsigned NOT NULL default '1',
      `allow_rate` tinyint(1) unsigned NOT NULL default '1',
      `approve` tinyint(1) NOT NULL default '0',
      `fixed` tinyint(1) NOT NULL default '0',
      `rating` smallint(5) NOT NULL default '0',
      `allow_br` tinyint(1) NOT NULL default '1',
      `vote_num` smallint(5) unsigned NOT NULL default '0',
      `news_read` mediumint(8) unsigned NOT NULL default '0',
      `votes` tinyint(1) NOT NULL default '0',
      `access` varchar(150) NOT NULL default '',
      `symbol` varchar(3) NOT NULL default '',
      `flag` tinyint(1) NOT NULL default '1',
      `editdate` varchar(15) NOT NULL default '',
      `editor` varchar(40) NOT NULL default '',
      `reason` varchar(255) NOT NULL default '',
      `view_edit` tinyint(1) NOT NULL default '0',
      `tags` varchar(255) NOT NULL default '',
      `metatitle` varchar(255) NOT NULL default '',
      `news_tid` smallint(5) NOT NULL default '0',
      PRIMARY KEY  (`id`),
      KEY `autor` (`autor`),
      KEY `alt_name` (`alt_name`),
      KEY `category` (`category`),
      KEY `approve` (`approve`),
      KEY `allow_main` (`allow_main`),
      KEY `date` (`date`),
      KEY `symbol` (`symbol`),
      KEY `comm_num` (`comm_num`),
      KEY `tags` (`tags`),
      FULLTEXT KEY `short_story` (`short_story`,`full_story`,`xfields`,`title`)
    ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=15307 ;
    Code (markup):

    This is the structure for users.
    CREATE TABLE IF NOT EXISTS `dle_users` (
      `email` varchar(50) NOT NULL default '',
      `password` varchar(32) NOT NULL default '',
      `name` varchar(40) NOT NULL default '',
      `user_id` mediumint(8) NOT NULL auto_increment,
      `news_num` smallint(6) NOT NULL default '0',
      `comm_num` mediumint(8) NOT NULL default '0',
      `user_group` smallint(5) NOT NULL default '4',
      `lastdate` varchar(20) default NULL,
      `reg_date` varchar(20) default NULL,
      `banned` varchar(5) NOT NULL default '',
      `allow_mail` tinyint(1) NOT NULL default '1',
      `info` text NOT NULL,
      `signature` text NOT NULL,
      `foto` varchar(30) NOT NULL default '',
      `fullname` varchar(100) NOT NULL default '',
      `land` varchar(100) NOT NULL default '',
      `icq` varchar(20) NOT NULL default '',
      `favorites` text NOT NULL,
      `pm_all` smallint(5) NOT NULL default '0',
      `pm_unread` smallint(5) NOT NULL default '0',
      `time_limit` varchar(20) NOT NULL default '',
      `xfields` text NOT NULL,
      `allowed_ip` varchar(255) NOT NULL default '',
      `hash` varchar(32) NOT NULL default '',
      `logged_ip` varchar(16) NOT NULL default '',
      `restricted` tinyint(1) NOT NULL default '0',
      `restricted_days` smallint(4) NOT NULL default '0',
      `restricted_date` varchar(15) NOT NULL default '',
      `thx_num` int(11) NOT NULL default '0',
      `forum_post` smallint(5) NOT NULL default '0',
      `forum_warn` smallint(5) NOT NULL default '0',
      `forum_update` varchar(20) NOT NULL default '0',
      `forum_rank` varchar(40) NOT NULL default '0',
      `forum_pips` smallint(2) NOT NULL default '0',
      `forum_reputation` smallint(5) NOT NULL default '0',
      `forum_last` varchar(20) NOT NULL default '0',
      `forum_time` varchar(20) NOT NULL default '0',
      PRIMARY KEY  (`user_id`),
      UNIQUE KEY `name` (`name`),
      UNIQUE KEY `email` (`email`)
    ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1846 ;
    
    Code (markup):
     
    amitash, Jan 23, 2010 IP
  2. swarg

    swarg Peon

    Messages:
    105
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    It depends from your software. If you use some custom scripts and both databases located at the same server it is possible. If you use something standard it will be difficult. If your databases located at different servers, it will be impossible afaik
     
    swarg, Jan 31, 2010 IP
  3. stOK

    stOK Active Member

    Messages:
    114
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    53
    #3
    Yes. This mostly depends on if your database is accessible to scripts running on www.site2.com
     
    stOK, Feb 1, 2010 IP