import data to a database from another database in python

Question

I have two databases, one is located in localhost, the other one in located in another server.

In python, I want to import some data from database 2 to database 1:

  con1 = mdb.connect (host= xx, user=xx, passwd= xx, db= xx) //connect database 1
  cur1 = con1.cursor()
  con2 = mdb.connect (host= xx, user=xx, passwd= xx, db= xx) //connect database 2
  cur2 = con2.cursor()

  query = "update database1.table1 set area = (select database2.table2.area from database2.table2)"

  cur(1 or 2?).execute(query) //Don't know how to solve this problem

Sergio Tulentsev · Accepted Answer · 2012-01-18 12:49:49Z

1

No, you can't do cross-server operations like that.

Fetch your data from source database (in batches, if it's big)
Prepare and send update statements to target database.

answered Jan 18, 2012 at 12:49

Sergio Tulentsev

231k43 gold badges381 silver badges373 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

manxing Over a year ago

Thank you for your information. But if the case is, two databases are located in the same server. How can I connect to them, and import some data from one to another?

Sergio Tulentsev Over a year ago

if both databases are located in the same db process, it's quite easy. Something like insert into db1.table1 (col1, col2) select col1, col2 from db2.table2;

Collectives™ on Stack Overflow

import data to a database from another database in python

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related