MySQL Database Sync

Question

I have 2 MySQL databases with similar data. The difference is that one has an email column with about 2000 entries and the other has an email column with no entries. Is there some sort of bulk operation that could be done to copy the 2000 email addresses from database 1 to database 2?

I'm looking for a way to do this with PHP, or better yet, an all-inclusive query to run via phpMyAdmin.

@Sven They are similar tables - not identical. I worded that wrong in the question. — user1710563
– user1710563, Commented Apr 14, 2013 at 23:35

Kermit · Accepted Answer · 2013-04-14 22:57:12Z

4

Something like this:

UPDATE db1.tbl a SET a.email = b.email
JOIN db2.tbl b ON b.id = a.id

answered Apr 14, 2013 at 22:57

Kermit

34.1k13 gold badges89 silver badges121 bronze badges

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

4 Comments

user1710563 Over a year ago

Not extremely familiar with SQL statements - would need more clarity.

Kermit Over a year ago

As long as both databases are on the same server and have the same user privileges, then you can query off both databases using a single query. This query will update db1's table with db2's e-mails based on the id.

user1710563 Over a year ago

Almost got it...when I run the query, I get a syntax error for the JOIN statement.

Kermit Over a year ago

@user1710563 Put it in a fiddle.

Collectives™ on Stack Overflow

MySQL Database Sync

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related