RaaapuLis Posted October 7, 2008 Report Share Posted October 7, 2008 sveiki, vai ir kautkaada iespeja atgut netisham izdzestu datubazi? PHPMyAdmiana veeleejos 2 tables nodropot bet netisham nodropoju visu db Link to comment Share on other sites More sharing options...
Val Posted October 7, 2008 Report Share Posted October 7, 2008 jā. no backupa. Link to comment Share on other sites More sharing options...
Aleksejs Posted October 7, 2008 Report Share Posted October 7, 2008 Nav sanācis... Bet re ko raksta: http://stackoverflow.com/questions/88800/h...ysql-binary-log Link to comment Share on other sites More sharing options...
RaaapuLis Posted October 7, 2008 Author Report Share Posted October 7, 2008 un ja nau taada :( Link to comment Share on other sites More sharing options...
bubu Posted October 7, 2008 Report Share Posted October 7, 2008 Īsti vīri bakupus netaisa. Link to comment Share on other sites More sharing options...
Paraugs Posted October 7, 2008 Report Share Posted October 7, 2008 Ja nav backupa, tad nekas cits neatliek ka atjaunot datu bazes teiblus pec atminas. Link to comment Share on other sites More sharing options...
hQuse Posted October 8, 2008 Report Share Posted October 8, 2008 Rekomendēju turpmāk izmantot http://members.lycos.co.uk/wipe_out/automysqlbackup/ Link to comment Share on other sites More sharing options...
Grey_Wolf Posted October 8, 2008 Report Share Posted October 8, 2008 (edited) Tiiri teoretiski var atjaunot, jo DB peec savas dziljakaas buutiibas ir Direktorija, un tabulas ir faili --> var megjinat atjaunot failus ar kaadu no Undelete serijas programmam ... Īsti vīri bakupus netaisa. Isti viiri arii Nelasa un Nenjem veeraa briidinaajumus ... (PhpMyAdmins Pirms DB droposanas stipri vien Noblajustaas) Edited October 8, 2008 by Grey_Wolf Link to comment Share on other sites More sharing options...
marrtins Posted October 8, 2008 Report Share Posted October 8, 2008 Ja uztaisīts DELETE FROM bla bla, var vēl mēģināt izķeksēt datus no DB failiem (fixi tos pārkopējot kādā drošā vietā - lai nepārrakstās). Šādi reiz atguvu ~90% datus. Šo to atguvu, šo to nācās pielabot, bet visus nevarēja, jo tomēr šis un tas bija sabojāts. Ja nodroppota datubāze, tad var mēģināt ar savu mīļāko undelete tooli savai mīļākajai failsistēmai atjaunot izdzēstos failus un tad skat iepr rindkopu. Ā, un tas ir uz MyISAM tipa tabulām, uz InnoDB sūkā pirkstu, par pārējām nezinu. Link to comment Share on other sites More sharing options...
Klez Posted October 8, 2008 Report Share Posted October 8, 2008 pietiek ar vienu rindinju :) (backupam) laizham reizi dienaa, vai ja ir paranoja tad ik peec 10 min :) linuxam (automaatiski arii sakompreseejam) ielikeam cron.daily mapee date=`date -I` /usr/bin/mysqldump --opt --all-databases -u root --password='megaparole' | bzip2 -c > /vieta/kur/backupojam/all_databases-$date.sql.bz2 windowsam kaut kaa shitaa (liekam tasks folderii ieksh windows mapes) /usr/bin/mysqldump --opt --all-databases -u root --password='megaparole' > C:\droshaa\vieta\kur\backupojam\all_databases.sql Link to comment Share on other sites More sharing options...
Aleksejs Posted October 8, 2008 Report Share Posted October 8, 2008 Klez... Nez... Ja es iesitīšu: ps -af , kad izpildīsies šis skripts, es ieraudzīšu, ka mysqldump izsaukts ar parametru --password='megaparole' ? ;) Link to comment Share on other sites More sharing options...
marrtins Posted October 8, 2008 Report Share Posted October 8, 2008 Plus tāds bakkups nekam neder (ok, kaut kam jau der), bet, standarta gadījumā - datubāzes daudz, un pēc vajadzības "izķesēt" interesējošo datubāze no tā kluča nav diezko viegli. Link to comment Share on other sites More sharing options...
Klez Posted October 8, 2008 Report Share Posted October 8, 2008 (edited) par taam tatubaazeem jaa. bet vari taisiit katrai db atsevishki ... --opt --databases DB_VAARDS marrtins - jebkuraa gadijumaa vismaz ir backup :) taa kaa man uz servera ir tikai 13 baazes, tad iipashi nesatraucos :) maajas lapas db tiek taisiits atsevishks backup - viss paareejais vienaa :) Aleksejs , tur paraadaas shitaads /usr/bin/mysqldump --opt --all-databases -u root --password=x xxxxxxxxxxxxxx nezinu gan kaa windowsam ... Edited October 8, 2008 by Klez Link to comment Share on other sites More sharing options...
blackhalt Posted October 8, 2008 Report Share Posted October 8, 2008 Es arī balsoju par Undelete programmu, ja tas ir localhost ;) Tev jāmeklē kaut kur te: mysql/data Ja Tev nav attiecīgo tiesību rikoties uz servera ar tādām Undelete programmām, tad atliek cerēt, ka kāds Tavā vieta taisa rezerves kopijas ;) Link to comment Share on other sites More sharing options...
Java Posted October 8, 2008 Report Share Posted October 8, 2008 Kā var netīšām nodropot visu DB? Vai tad brīdinājumus nelasi? Skaties, ka kādreiz šitā netīšām arī nenoformatē cieto disku! Link to comment Share on other sites More sharing options...
Recommended Posts