Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mysqldiff --difftype=differ --server1=PASSWORD@localhost --server2=root:PASSWORD@localhost pos.phppos_additional_item_numbers:compare.phppos_additional_item_numbers
- <?php
- ini_set('display_errors', 1);
- set_time_limit(0);
- $db_host = 'localhost';
- $db_user = 'root';
- $db_password = 'PASSWORD';
- $db_1 = $argv[1];
- $db_2 = $argv[2];
- $verbose = isset($argv[3])? '-'.$argv[3] : '';
- $conn = mysqli_connect($db_host, $db_user, $db_password, $db_1);
- $show_tables_query = mysqli_query($conn, 'SHOW tables');
- $tables = array();
- while ($row = mysqli_fetch_assoc($show_tables_query))
- {
- $tables[] = $row['Tables_in_'.$db_1];
- }
- foreach($tables as $table)
- {
- echo "$tablen*******************************nn";
- 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");
- echo "nn";
- }
- ?>
Add Comment
Please, Sign In to add comment