saldais Posted December 30, 2005 Report Share Posted December 30, 2005 sveiki, man te atkal neliela probleema ar kodeshanas lietam.. nepiecieshams vienu sisteeminju parnest uz jaudiigaaku serveri un nodomaaju, ka mysql5 vareetu buut labakais variants, jo uz mysql 3 pusmiljons ierakstu nedaudz par daudz :) .. karas un ta pamatiigi.. tapec kjeros klat un novilku mysql 5 uzliku uz sava maza shlakwares serveriisha, nokonfigureeju un pat pabriinijos, ka .dmp bez kludam uzlikas.. nodomaju, ka optimizeshanu atlikshu uz velaku laiku, tapec kjeros klat pie konekcijas, vai mans php un pati aplikaacija stradaas.. izraadas nee.. sekojosha kluuda Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in /var/storage/www/helpdesk/includes/connect.inc.php on line 10KĻŪDA Nevar pieslēgties datu bāzei vai ir kaads pieredzejis jua shadu probleemu.. es lietoju shadu konekciju.. <? // connect to database if( isset( $CONNECT ) ) { return; } $CONNECT=1; if ($db_type == "mysql") { $mysql_link = mysql_connect("$db_server", "$db_username", "$db_password"); if (!$mysql_link) { print "<B>$l_error</B> <I>$l_cannotconnecttodatabase</I>\n"; exit; } mysql_select_db($db_db, $mysql_link); } ?> negribas pariet uz php5 tāpec, ka kods aplikacijais ir diezgan pinjkeriigs gars un nesaprotams... pac neesmu kodeejis.. kadi priekšlikumi ?? Link to comment Share on other sites More sharing options...
v3rb0 Posted December 30, 2005 Report Share Posted December 30, 2005 liec 4turto mysql.. ar 5kto imo vērts lauzties tad ja izmanto viņa jaunās fīčas - storētās procedūras, viewus, trigerus.. Link to comment Share on other sites More sharing options...
AcidRain Posted December 30, 2005 Report Share Posted December 30, 2005 Man bija tieši šī pati problēma, pie mana mysql slēdzās klāt vecāks php. Problēmas risinājums ir aprakstīts šeit: http://dev.mysql.com/doc/refman/5.0/en/old-client.html. Link to comment Share on other sites More sharing options...
saldais Posted December 30, 2005 Author Report Share Posted December 30, 2005 liec 4turto mysql..ar 5kto imo vērts lauzties tad ja izmanto viņa jaunās fīčas - storētās procedūras, viewus, trigerus.. cik esmu lasiijis uz dzirdeejis, tad mysql5 ir ljooti lidziigs PostreSQL. ta kaa ar postresql ir probleema, ka no mysql nevar datus pardzit uz postgresql (ljoti daudz problemas ar timestampiem uc..) tad domaju, ka mysql5 butu labaks risinajums.. vismaz ar datu migreeshanu nav jasatraucas.. (modificeet ~200Mb .dmp ir neprats..) tapec, vel kadus risinajumus.. pashu konekciju kaa rakste vai ect.. ?? Link to comment Share on other sites More sharing options...
Paulinjsh Posted December 30, 2005 Report Share Posted December 30, 2005 Nu dari kā acid teica un vajadzētu darboties. Man nav bijusi prob no 4 uz 5 pārnest izņemot to old_password. Link to comment Share on other sites More sharing options...
armags Posted January 1, 2006 Report Share Posted January 1, 2006 bet sakiet vai nebus problemu savienot Mysql 4 kopa ar 4 PHP??? Link to comment Share on other sites More sharing options...
bubu Posted January 1, 2006 Report Share Posted January 1, 2006 nē, nebūs Link to comment Share on other sites More sharing options...
armags Posted January 1, 2006 Report Share Posted January 1, 2006 nu tad es uzzinstaleju shitos , un daru to pec ta parauga kas ir dots te foruma ka instelt aache un ..... un nebus tas erors man? Link to comment Share on other sites More sharing options...
Kavacky Posted January 1, 2006 Report Share Posted January 1, 2006 ****, uzliec un tad skaties. Pareizi izdarīsi, nebūs. Link to comment Share on other sites More sharing options...
saldais Posted January 2, 2006 Author Report Share Posted January 2, 2006 paldies... http://dev.mysql.com/doc/refman/5.0/en/old-client.html. shis te nodereeja... Link to comment Share on other sites More sharing options...
Recommended Posts