steammer Posted March 23, 2008 Report Share Posted March 23, 2008 Sveicinaati! Dziive kaa jau vienmeer, komandu DROP DATABASE iznaak izpildiit tieshi tad, kad tas nav vajadziigs... Liidz ar to jautaajums - kaada var buut izeja, lai datubaazi atkal atjaunotu... Ikdienaa ar MySQL nestraadaaju, datubaaze arii nebija paaraak nopietna, taapeec logjiski ka nebija ne backupi uzstaadiiti, ne kas. Bet saturs tomeer ir svariigs un gribeetos atguut. Ir ceriibas? Link to comment Share on other sites More sharing options...
bubu Posted March 23, 2008 Report Share Posted March 23, 2008 Īstiem vīriem nav cerību, jo īsti vīri backupu netaisa. Link to comment Share on other sites More sharing options...
Aleksejs Posted March 23, 2008 Report Share Posted March 23, 2008 Kaut ko vari mēģināt dabūt no binary log. Link to comment Share on other sites More sharing options...
steammer Posted March 23, 2008 Author Report Share Posted March 23, 2008 probleema taa, ka no 540 cik tur binary logiem, palikushi ir tikai kaadi 8 peedeejie, paareejie nodzeesti. manupraat ar to pashu izredzes atjaunot nav, datubaaze kraata pusgada garumaa... Link to comment Share on other sites More sharing options...
Aleksejs Posted March 23, 2008 Report Share Posted March 23, 2008 Skarbi... Nu, varbūt te kaut kas vērtīgs: http://forums.mysql.com/read.php?28,99328,99328 vēl arī dokumentācijā ir interesants komentārs: Do note that when a db is dropped, the corresponding db structure is deleted. However, the data itself, which resides in a common file 'ibdata', is not deleted. In some cases, this might constitute a security hazard.This is not a bug but i think that it would be a good idea that 'drop database' actually removes the data from ibdata. Link to comment Share on other sites More sharing options...
steammer Posted March 23, 2008 Author Report Share Posted March 23, 2008 Skatiijos jau visus internetaa atrodamos resursus par atjaunoshanu. Probleema taa, ka shajaa gadiijumaa datubaaze ir vesela, liidz ar to atjaunojot pat no ibdata (ko arii dariiju), atjaunojas peedeejaa mirklja situaacija, kas ir peec komandas DROP... Liidz ar to kaa vareetu panaakt, lai no ibdata vareetu izlobiit kaadu agraaku informaaciju? Link to comment Share on other sites More sharing options...
Aleksejs Posted March 23, 2008 Report Share Posted March 23, 2008 (edited) pats neesmu to darījis, varu tikai palīdzēt meklēšanā ;) http://forums.mysql.com/read.php?22,47078,47078 Edited March 23, 2008 by Aleksejs Link to comment Share on other sites More sharing options...
steammer Posted March 24, 2008 Author Report Share Posted March 24, 2008 Pavadot pusvakaru un riitu pie kaarteejiem meegjinaajumiem, laikam atmetiishu ar roku. Sapratu, ka man vajadziigaa tabula ir MyISAM formaataa, liidz ar to atguut varu tikai no cietaa diska lasot pa fragmentiem... Link to comment Share on other sites More sharing options...
777 Posted March 24, 2008 Report Share Posted March 24, 2008 ka jau bubu rakstija , istie virieshi backup netaisa , ta tev bus maciba , kad ir jataisa backup , lai butu droshs , ka ja nu kas , tad visu vares atkal dabut pie dzives ... Link to comment Share on other sites More sharing options...
Recommended Posts