Guest User

Untitled

a guest
Mar 12th, 2018
110
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.87 KB | None | 0 0
  1. mysqldiff --difftype=differ --server1=PASSWORD@localhost --server2=root:PASSWORD@localhost pos.phppos_additional_item_numbers:compare.phppos_additional_item_numbers
  2.  
  3. <?php
  4. ini_set('display_errors', 1);
  5. set_time_limit(0);
  6. $db_host = 'localhost';
  7. $db_user = 'root';
  8. $db_password = 'PASSWORD';
  9. $db_1 = $argv[1];
  10. $db_2 = $argv[2];
  11. $verbose = isset($argv[3])? '-'.$argv[3] : '';
  12.  
  13. $conn = mysqli_connect($db_host, $db_user, $db_password, $db_1);
  14. $show_tables_query = mysqli_query($conn, 'SHOW tables');
  15.  
  16. $tables = array();
  17. while ($row = mysqli_fetch_assoc($show_tables_query))
  18. {
  19. $tables[] = $row['Tables_in_'.$db_1];
  20. }
  21.  
  22. foreach($tables as $table)
  23. {
  24. echo "$tablen*******************************nn";
  25. system("mysqldiff $verbose --difftype=differ --server1=$db_user:$db_password@$db_host --server2=$db_user:$db_password@$db_host $db_1.$table:$db_2.$table");
  26. echo "nn";
  27. }
  28.  
  29.  
  30.  
  31. ?>
Add Comment
Please, Sign In to add comment