553

To Cr0n0s -rectificare

Cer scuze o rectificare , astai varianta:mam lamurit cu problema anterioara dar ma cioknit cu lata poate imi dati un indiciu:deci am 2 baze pe localhost: dom1 si dom2, Verific tabelul AdmContact din ambele baze pentru a vede daca au fost facute modificari:my $server1 = 'localhost ';my $db1 = 'dom1';my $username1 = 'root' ;my $password1 = '123' ;$dbh = DBI->connect("dbi:mysql:$db1:$server1", $username1, $password1, { RaiseError => 1 });##########################################################3my $server2 = 'localhost';my $db2 = 'dom2';my $username2 = ' root' ;my $password2 = ' 123' ;my $dbh2 = DBI->connect("dbi:mysql:$db2:$server2", $username2, $password2, { RaiseError => 1 });#############################################################$query="SELECT dom1.AdmContact.domain_name FROM dom1.AdmContact, dom2.AdmConatc WHERE dom1.AdmContact.id ne dom2.AdmContact.id";$sth=$dbh->prepare($query) or die " Nu poate cere query: \n";$sth->execute() or die "Nu poate indeplini: \n";while (@row = $sth->fetchrow_array) {print "@row\n";}Conectarea merge ok , incepe selctul se gindeshte vre- 30 secunde si imi da rezultatul : Terminatedsi moare serverul mysql
0