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