Modify to access other databases?

Modify to access other databases?

There is a way to solve this creating a view on your joomla Database: "CREATE VIEW [name] AS SELECT .... FROM bbdd1.table1 t1, bbdd2.table2 t2 WHERE....."

And them, you can use this view on joodatabase.








[gldneagl 2010-10-11 05:00:00]:


Modify to access other databases?

And just another plus, you can access to another server wjth Mysql creating a Federated Table. Form example:
External Server: 192.168.1.100 with Mysql u:user p:password bbdd: Test01 and table: Table01. (id int(10) NOT NULL auto_increment, text01 varchar(255), date_field data NOT NULL default '2010-01-01').
Joomla Server: You have to create a FEDERATE table with same fields and format that the original one, adding the conection string:
CREATE TABLE new_table ( id int(10) NOT NULL auto_increment, text01 varchar(255), date_fiel date NOT NULL default '2010-01-01', PRIMARY KEY (id))
ENGINE=FEDERATED
CONNECTION='mysql://user:password@192.168.1.100/Test01/Table01';
Now, on joodb you can use this table (new_table) just as another joomla table.