Take the 2-minute tour ×
Ask Ubuntu is a question and answer site for Ubuntu users and developers. It's 100% free, no registration required.

I have two discrete mysql databases (located in different servers). In windows, I can use odbc and ms access and query from tables residing in different databases. In ubuntu, is there a way or tool to do this task?

share|improve this question
    
What exactly do you want to do? It does not matter where the databases are located. Please give us some more detail about your environment. –  ortang May 29 '13 at 11:09
    
database 1 is mysql on IIS server. database 2 is mysql on linux server. I would like to bring (linked) table1 from db1 and table2 from db2 in common db tool and make union query from these 2 tables. –  bob May 29 '13 at 11:11
    
That link might help you: mysql-joins-between-databases-on-different-servers-using-python –  ortang May 29 '13 at 11:26
    
Thank you. In addition, the 2 servers are located in different countries. I do not know how to do it using python (I have never used python). I wonder if there is a tool similar with mysqlworkbench I use, I mean GUI). –  bob May 29 '13 at 11:33
add comment

3 Answers

up vote 1 down vote accepted

Since MySql Workbench did not connect to multiple databases at once, I found Tora, a database Management Tool from Oracle. (http://sourceforge.net/projects/tora). You can get build instructions and a precompiled deb for 12.04 here: http://help.ubuntu.com/community/HowToBuildToraWithOracle .

It is also available in the official ubuntu-repositories (Software-Center).

share|improve this answer
1  
thank you mondjunge. unfortunately, mysql workbench can not connect at the same time in 2 different dbs. –  bob May 29 '13 at 13:16
1  
That is odd... I also found Tora, a database Management Tool from Oracle. (sourceforge.net/projects/tora). You can get it precompiled for 12.04 here: help.ubuntu.com/community/HowToBuildToraWithOracle . Unfortunately I have no time to test Tora, but it seems like the only tool, that might have such a functionality build in. –  mondjunge May 29 '13 at 14:04
    
many thanks. I will try it; it seems it is for ubuntu 7.04. –  bob May 29 '13 at 14:16
    
There is tora 2.1.3. available in ubuntu software center; I have installed in and I connect in both dbs at the same time! Congrats, you can include this in your answer so I accept it. –  bob May 29 '13 at 14:25
    
I did... thx and good to know that TOra works... –  mondjunge May 30 '13 at 11:07
add comment

Take a look at LibreOffice Base. Its a GUI database system (similar to MS Office Access) that allows you to connect (I believe) to pretty much any database you have login privileges on.

Look in the Ubuntu Software Center and search for LibreOffice Base or run sudo apt-get install libreoffice-base* That command will install everything Base needs to run.

share|improve this answer
    
thank you. I have tried, it does import external data (db connect), only one at a time however. –  bob May 29 '13 at 13:47
    
Ah. Well, hope you find what you want! –  RPi Awesomeness May 29 '13 at 13:49
add comment

You can use SQLyog on Wine/LINUX with GNOME desktop see product page in TAB SQLyog on Wine/Linux

To install wine.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.