steammer Posted March 23, 2008 Report 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?
bubu Posted March 23, 2008 Report Posted March 23, 2008 Īstiem vīriem nav cerību, jo īsti vīri backupu netaisa.
Aleksejs Posted March 23, 2008 Report Posted March 23, 2008 Kaut ko vari mēģināt dabūt no binary log.
steammer Posted March 23, 2008 Author Report 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...
Aleksejs Posted March 23, 2008 Report 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.
steammer Posted March 23, 2008 Author Report 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?
Aleksejs Posted March 23, 2008 Report 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
steammer Posted March 24, 2008 Author Report 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...
777 Posted March 24, 2008 Report 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 ...
Recommended Posts