Maitiro Ekubata Dhatabheki Zvikanganiso muMySQL 5q4064

MySQL dhatabhesi inoshandiswa nevakawanda zvemukati manejimendi masisitimu (CMS) kutsigira mawebhusaiti. Tichifunga mukana wekuti vawanikwe zvakananga kuburikidza newebhu interface, vanogona zvakare kuve panjodzi kupfuura mamwe masisitimu. Ndosaka kuchengetedza MySQL kuchida kwete zvishoma, asi kutarisisa kwakawanda. Chii chaunofanira kuita kana iwe ukaona kuti sevhisi yako yeCMS haisi kushanda nemazvo nekuda kwekusasvikika kwedatabase?Izvi zvakanganisa webhusaiti yako, zvakakonzera matambudziko muchitoro chako chendaneti, nezvimwe. 3x3f6k

Kana dambudziko riripachokwadi dhatabhesi, iwe unozofanirwa kutarisa mune yakazara yakazara yekudzoreredza sarudzo. Zvakakodzera yambiro: kushanda nemadhatabhesi hakuna kumbobvira kwave mhinduro iri nyore uye izvi zvingada ruzivo rwakadzama rwemadatabase uye mutauro weSQL zvakazara. O Tutorial nhasi unotsvaka kuratidza izvozvo chaizvo.

Zvakadaro, pane basa rinotarisira dambudziko iri - maneja wedatabase - izvo zvinoreva kuti kune vanhu vakanyatsodzidziswa kuti vaone kuti dhatabhesi "haaparadzwe". Iwe unogona kunge wakambonzwa nezve vatariri veIzwi, Excel uye nezvimwe. Zvakanaka, kana uchishanda nemadhatabhesi, anodiwa. Saka, chii chaunofanira kuita kana vanhu ava vasiri mukambani yako uye kudiwa kwekuve navo kuri pakarepo?

Vagadziri vezvishandiso vachishandisa MySQL dhatabhesi vakaedza kupa dzimwe nzira dzekudzoreredza. Pane zvinyorwa zvakawanda pamusoro pekutonga kwebhangi uye kudzoreredza, asi mazhinji anogona kunge akaomarara. Saka, kana pakupedzisira ukatadza kuzvinzwisisa, kana nzira idzi dzaive dzisina basa, edza yakasarudzika chishandiso chepasirese - Recovery Toolbox yeMySQL - iri nyore uye inoshanda mukudzoreredza MySQL dhatabhesi kubva ku "InnoDB" uye "MyISAM" shanduro.

Ehe, zvese izvi zvine musoro chete kana pasina imwe-up-date backup yedatabase. Inogona kuva imwe dump Database, "inotonhora kopi" yefaira, mufananidzo wedhisiki, kana chimwewo chinhu. Kana paine backup, usarambe uchiverenga, sezvo iyi sarudzo isingatariswe pano.

MySQL Internal Recovery 4ns5

Saka chii chaunofanira kuita kana MySQL database yakamira kushanda:

1. Vhura iyo "my.cnf" faira uye isa inotevera parameter: "innodb_force_recovery = 1"
2. Tangazve MySQL nemurairo unotevera: "/etc/init.d/mysql restart"
3. gadzira dump yedatabase uye kuirongedza: "mysqldump db | gzip> db.sql.gz”
4. Gadzira dhatabhesi nyowani: mysql -e gadzira dhatabhesi "new_DB";
5. Ngenisa data ku: “zcat database.sql.gz | mysql itsva_DB”.

Kutangazve MySQL nenzira iyi hakutangi ese akabatana maitiro uye mune dzimwe nguva inobvumidza iwe kuvhura dhatabhesi rekare. Tichishandisa mirairo iyi, tinoedza kurasa dhatabhesi yekare, kuipinza mune imwe nyowani, yaunovhura nenzira yakajairika. Kana izvi zvikaitika, unogona kudzima dhatabhesi yekare. Nenzira, kana iyo nzira isingabatsire, uye dhatabhesi yekare haina kutanga, iwe unofanirwa kuedza mamwe maitiro e "innodb_force_recovery" parameter, kusvika ku "6".

Munguva yakajairika dhatabhesi yekutanga, sisitimu inoedza kutanga maitiro ese, kusanganisira ayo aive, semuenzaniso, akamiswa zvisirizvo nekuda kwematambudziko emagetsi. Nekuda kweiyo "innodb_force_recovery" sarudzo, unogona kudzima mamwe ma paramita anokanganisa kuvhurwa kwedhatabhesi. Nhamba dzinoreva zvinotevera:

• MySQL yekutanga haina kumira, kunyangwe iyo system ikaona mapeji akaora panguva yekuita.
• Kanzura kuvhura mabasa ekumashure
• Kanzura kuedza kudzosera shure kutengeserana
• Kuramba kuverenga nhamba uye kushandiswa kweshanduko dzakachengetwa
• Haitore marekodhi ekudzosera kumashure pakutanga
• Haitore muakaunti "ib_logfiles" paramita panguva yekutanga

Dzimwe nzira dzeDatabase Recovery 4k4m3i

Iyo nzira inotsanangurwa pamusoro inobatsira chaizvo, kunyangwe, zvinosuruvarisa, inogona kuomera vamwe vashandisi. Nekudaro, kushanda nechero dhatabhesi fomati kunogara kwakaoma. Kana iwe usingade kugadzirisa marongero, vhura mutsara wekuraira uye udzidze syntax yemirairo inodiwa. Saka, iwe unozoda iri nyore uye iri nyore kushandisa chishandiso. Munguva pfupi yapfuura, ndanga ndichishandisa Recovery Toolbox yeMySQL yakawanda.

Zvichida iyi ndiyo nzira iri nyore uye inoshanda yekudzoreredza dhatabhesi reMySQL, zvinova ndizvo chaizvo zvinodiwa nevazhinji vashandisi. Pane zvishoma zvingasarudzwa:

1. Bata zvese iwe pachako nekupedza mazuva akati wandei uchizviita
2. Dzosera dhatabhesi mukati meawa
3. Ramba uchishanda uye udzivise kurasikirwa.

Kushandisa Recovery Toolbox yeMySQL iri nyore kwazvo; Iwe hautombofanire kuverenga iyo mirairo - kusiyana nekutsanangurwa kwakadzama kwekugadzirisa zvigadziriso nezvimwe zvakadaro - zvese zviito zvinoitwa intuitively. Iyo purogiramu inongoshanda nekopi imwe yedhatabhesi, saka haimbokanganise zvakasara padhatabhesi rekare. Iwe uchanzwa mutsauko wekuongorora mune "yekugadzira" server marongero, usingatyi kuita chimwe chinhu chakaipa uye kuparadza zvakasara.

Maitiro ekudzoreredza Dhatabhesi Uchishandisa Recovery Toolbox yeMySQL 6z6c3a

Kuti udzorere dhatabhesi yeMySQL yakakuvadzwa uchishandisa chirongwa ichi, unofanirwa kuita zvinotevera:

1. the Recovery Toolbox yeMySQL papeji
2. Isa uye shandisa purogiramu
3. Sarudza folda inochengeta yakakuvadzwa MySQL database mafaira
4. Sarudza dhatabhesi yakakuvadzwa kubva pane iyo rondedzero
5. Mhanyai kuongorora pane yakasarudzwa database
6. Ona kudzoreredza mhinduro: matafura, zvinhu, indexes
7. Gadzira nzira yekuchengetedza data yakadzoserwa
8. Sevha data (inowanikwa chete mune yakazara vhezheni yesoftware)

Iyo purogiramu inotorwa zvachose pasina muripo uye yakaiswa pasina kunyoresa. Uchishandisa Recovery Toolbox yeMySQL, unogona kutarisa iyo yakadzoserwa data yemahara uye kuongorora basa rakaitwa.

Iwe unogona kunyange kunosora dzimwe shanduko uye nyore kuzviita iwe pachako nemaoko ako pane "yakaputsika" asi ichiri kushanda negadziriro yeparutivi; Kana ukagadzirisa chero zvipi zvazvo, ndapota funga nezveshanduko dzichangoburwa. Iwe unongoda kubhadhara kana iwe uchida kuchengetedza iyo yakadzoserwa data, gadzirazve iyo MySQL dhatabhesi, uye ibatanidze kune sisitimu.

Chengetedzo Paunoshanda neKudzoreredza Toolbox yeMySQL 2c1j3s

Iyo purogiramu inogona kuiswa pane chero Windows komputa. Iwe unogona kuita yekuisa mumaminitsi mashoma uye mushure meizvozvo iwe unogona kutanga kudzoreredza, izvo, nenzira, zvinogona kutora nguva yakareba zvichienderana nehukuru hweiyo dhatabhesi yepakutanga. Iwe unogona kudzora kusavapo kwekufungirana kwekubatanidza munzira dzinoverengeka, iyo yakapusa ndeye kudzima netiweki tambo. Uye zvinonyanya kukosha, izvi hazvikanganisi kushanda kwebasa munzira ipi neipi, nekuti Recovery Toolbox yeMySQL haishandisi yechitatu-bato kubatana.

Pane imwe nzira yakaoma zvishoma: kuisa network yekuongorora traffic - kurudziro yakanaka ndeye Wirehark - uye tarisa kana kufungidzira Kudzoreredza Toolbox yeMySQL mapakeji ari kusvika. Sezvingatarisirwa, iyi nzira inosanganisira kushingairira, sezvo iwo maWireShark manyoro akakura uye, zvakanyanya kukosha, kuwanikwa kwenguva yemahara. Naizvozvo, kushandisa Recovery Toolbox yeMySQL inonyanya kukurudzirwa kuchengetedza nguva uye kudzoreredza dhatabhesi pane system nekukurumidza sezvinobvira.

Chinhu chinonyanya kukosha ndechokuti purogiramu nguva dzose inoshanda chete nekopi yezvinyorwa zvepakutanga; saka, iyi nzira yekudzoreredza inovimbika zvakanyanya pane kuita shanduko kune dhatabhesi marongero uye kumirira kuona zvinoitika. Rangarira, kuyedza kugadzirisa dhatabhesi pane yekugadzira server inogona kuiuraya; izvi zvinoitika kunyangwe nevatungamiriri vane ruzivo.