*** pma-git/phpmyadmin/libraries/server_synchronize.lib.php 2010-04-07 17:31:22.665485919 -0400 --- server_synchronize.lib.php 2010-04-07 17:40:36.395117798 -0400 *************** *** 671,681 **** function PMA_populateTargetTables($src_db, $trg_db, $src_link, $trg_link, $uncommon_tables, $table_index, $uncommon_tables_fields, $display) { $display = false; // todo: maybe display some of the queries if they are not too numerous - $unbuffered_result = PMA_DBI_try_query('SELECT * FROM ' . PMA_backquote($src_db) . '.' . PMA_backquote($uncommon_tables[$table_index]), $src_link, PMA_DBI_QUERY_UNBUFFERED); if (false !== $unbuffered_result) { ! while ($one_row = PMA_DBI_fetch_row($unbuffered_result)) { ! $insert_query = 'INSERT INTO ' . PMA_backquote($trg_db) . '.' .PMA_backquote($uncommon_tables[$table_index]) . ' VALUES('; $key_of_last_value = count($one_row) - 1; foreach($one_row as $key => $value) { $insert_query .= "'" . PMA_sqlAddslashes($value) . "'"; --- 671,681 ---- function PMA_populateTargetTables($src_db, $trg_db, $src_link, $trg_link, $uncommon_tables, $table_index, $uncommon_tables_fields, $display) { $display = false; // todo: maybe display some of the queries if they are not too numerous $unbuffered_result = PMA_DBI_try_query('SELECT * FROM ' . PMA_backquote($src_db) . '.' . PMA_backquote($uncommon_tables[$table_index]), $src_link, PMA_DBI_QUERY_UNBUFFERED); if (false !== $unbuffered_result) { ! $insert_query = 'INSERT INTO ' . PMA_backquote($trg_db) . '.' .PMA_backquote($uncommon_tables[$table_index]) . ' VALUES'; ! while ($one_row = PMA_DBI_fetch_row($unbuffered_result)) { ! $insert_query.='('; $key_of_last_value = count($one_row) - 1; foreach($one_row as $key => $value) { $insert_query .= "'" . PMA_sqlAddslashes($value) . "'"; *************** *** 683,694 **** $insert_query .= ","; } } ! $insert_query .= ');'; ! if ($display == true) { ! PMA_displayQuery($insert_query); ! } ! PMA_DBI_try_query($insert_query, $trg_link, 0); } } } /** --- 683,696 ---- $insert_query .= ","; } } ! $insert_query .= '),'; ! } ! $insert_query=substr($insert_query,0,-1); ! $insert_query.=';'; ! if ($display == true) { ! PMA_displayQuery($insert_query); } + PMA_DBI_try_query($insert_query, $trg_link, 0); } } /**