+ Reply to Thread
Results 1 to 2 of 2

Thread: Comparing 2 databases

  1. #1

    Comparing 2 databases

    I have two MySQL databases: one for testing, and the other one is the actual database. Both databases are on different servers. their tables should be identical, however one table has one more row than the other. How would I find this row?

  2. #2
    Junior Member
    Join Date
    Jan 2012
    Posts
    20
    Okay , so your only soultion is to export the database and importing it on the first server and use the following code :
    Code:
    SELECT t1.* FROM table1 t1
    LEFT JOIN table2 t2
      ON t1.id = t2.id
    WHERE t2.id IS NULL

+ Reply to Thread

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts