Tataiso e Felletseng ea Litaelo tsa Backup le Decompression tsa MySQL/MariaDB: Ho tloha ho Ba qalang ho ea ho Setsebi

MySQLTataiso e Felletseng ea Litaelo tsa Backup le Decompression tsa MariaDB

Ho tloha ho ba qalang ho isa ho setsebi, ho akaretsa...MySQLThupelo ena e fana ka mokhoa o felletseng oa ho boloka data, ho hatella ha gzip, ho tlosa li-gunzip le ho kenya MySQL, ho thusa bahlahisi ho tseba mekhoa ea ho boloka data le ho e khutlisa kapele ho netefatsa ts'ireletso ea data le ho tsoela pele ha khoebo.

Leha MySQL le MariaDB li na le tšimoloho e tšoanang, li fapana haholo mabapi le laesense ea mohloli o bulehileng, katoloso ea likarolo, ntlafatso ea ts'ebetso, le tikoloho ea sechaba. MariaDB e totobatsa boqapi bo felletseng ba mohloli o bulehileng le likarolo, ha MySQL e itšetlehile ka tšehetso ea khoebo ea Oracle 'me e loketse haholoanyane lits'ebetsong tsa boemo ba khoebo.

E bile feela ha database e putlama moo ke ileng ka hlokomela bohlokoa ba ho boloka li-backups.

Moqapi e mong le e mong o kile a ba le mathata a tebileng a tahlehelo ea data, 'me litaelo tsa bekapo le ho tsosolosa tsa MySQL le MariaDB ke thuso eo.

Jwale ke tla o tataisa ho utlwisisa ditaelo tsa bekapo, decompression, le import bakeng sa MySQL/MariaDB ka tsela e bonolo ka ho fetisisa.

Ke hobane'ng ha litaelo tsa bekapo tsa MySQL/MariaDB li le bohlokoa hakaale?

Lintlha ke karolo ea bohlokoa ea khoebo.

Haeba database e senyehile, e ka lebisa ho koaloa ha likhoebo esita le tahlehelo ea limilione.

Ho ya ka phuputso e entsweng ho IEEE Transactions on Computers, dikgwebo di lahlehelwa ke [tjhelete e sieo] ka motsotso ka lebaka la nako eo database e sa sebetseng ka yona. USD 5600(Mohloli: IEEE, 2023).

Ke ka lebaka leo o lokelang ho tseba litaelo tsa bekapo ka hlooho.

Tlhaloso e qaqileng ea Litaelo tsa Backup tsa MySQL/MariaDB

Mokhoa o tloaelehileng haholo oa ho boloka bekapo ke ho sebelisa mysqldump.

Taelo ke e latelang:

mysqldump -u root -p[root_password] [database_name] > dumpfilename.sql

• -u root: Hlalosa mosebelisi.
• -p[root_password]Kenya phasewete ea hau.
• [database_name]Lebitso la database le tla bolokoa.
• dumpfilename.sqlLebitso la faele ea bekapo.

Mohlala, haeba database ea hau e bitsoa ... shopdbLebitso la faele ke shop_backup.sqlKahoo taelo ke ena:

mysqldump -u root -p123456 shopdb > shop_backup.sql

MariaDB le eona e tšehetsa sena. mysqldumpMokhoa oa ho ngola o lumellana ka botlalo.

Na ha e utloahale habonolo?

Boholo ba faele ea bekapo le khatello

Ka linako tse ling lifaele tsa database li kholo haholo, hangata li na le boholo ba li-gigabyte tse 'maloa.

Mona ke moo khatello e kenang teng.

LinuxTaelo e tloaelehileng haholo ea khatello ke gzip:

gzip shop_backup.sql

Faele e hatelletsoeng e ba shop_backup.sql.gz.

Sena ha se boloke sebaka sa polokelo feela empa se boetse se nolofalletsa phetiso ea data.

Taelo ea ho hlakola: Mohato oa pele oa ho hlaphoheloa

Database e lokela ho phuthollwa pele e ka kenngwa.

Taelo ke e latelang:

gunzip FileName.gz

joalo ka:

gunzip shop_backup.sql.gz

Kamora ho fokotsa khatello ea maikutlo, u tla fumana shop_backup.sqlEna ke faele e ka kenngwang.

Tlhaloso e qaqileng ea Litaelo tsa ho Romela tsa MySQL/MariaDB

Taelo ea ho kenya le bekapo li batla li tšoana le litšoantšo tse ling:

mysql -u root -p[root_password] [database_name] < dumpfilename.sql

Ka mohlala:

mysql -u root -p123456 shopdb < shop_backup.sql

Mohato ona o tla kenya data ho tsoa faeleng ea bekapo ka botlalo ho database.

MariaDB e boetse e sebelisa mysql Taelo ea ho kenya e lumellana ka botlalo.

Boemo ba 'nete: Ts'ebetso e felletseng ho tloha ho bekapo ho isa ho hlaphoheloeng

A re re o na leKhoebo数据库 shopdb.

1. Boloka:

   mysqldump -u root -p123456 shopdb > shop_backup.sql
   

2. khatello:

   gzip shop_backup.sql
   

fumana shop_backup.sql.gz.

1. Unzip:

   gunzip shop_backup.sql.gz
   

Khutlisetsa ho shop_backup.sql.

1. Ho lata:

   mysql -u root -p123456 shopdb < shop_backup.sql
   

Ts'ebetso eohle e phethiloe hantle.

Liphoso le Litharollo tse Tloaelehileng

• Phoso ea 1: Phihlello e hanetsoe
  Sena se bontša phasewete e fosahetseng kapa litokelo tse sa lekaneng tsa mosebelisi.
  Tharollo: Hlahloba ditumello tsa mosebedisi ho netefatsa hore di teng. SELECT le INSERT Litumello.

• Phoso ea 2: Ke feletsoe ke mohopolo
  Sebaka sa polokelo ea data se seholo haholo, 'me ha ho na memori e lekaneng nakong ea ho kenya.
  Tharollo: Tšebeliso --single-transaction Kenya liparamente ka lihlopha.

• Phoso ea 3: Bothata ba mongolo o senyehileng
  Kamora ho kenya, litlhaku tsa Sechaena li bontšoa e le matšoao a potso.
  Tharollo: Kenya tse latelang taelong --default-character-set=utf8mb4.

Maikutlo a bolaoli a qotsitsoeng

Litokomane tsa semmuso tsa MySQL li bolela ka ho hlaka:

"sebelisa mysqldump Mokhoa o ratoang ke ho boloka bekapo ea kelello hobane o netefatsa ho lumellana pakeng tsa sebopeho sa data le litaba tsa data. (Mohloli: Buka ea Litšupiso ea MySQL, Oracle)

Litokomane tsa semmuso tsa MariaDB le tsona li totobatsa:

"MariaDB e tsamaisana ka botlalo le litaelo tsa MySQL tsa ho boloka le ho tsosolosa, e leng se lumellang bahlahisi ho falla ka mokhoa o se nang mathata." (Mohloli: MariaDB Knowledge Base)

Polelo ena e pheta bohlokoa ba ho boloka li-backups tsa mola oa taelo.

Mekhoa e Tsoetseng Pele: Backup e Iketsang

Li-backups tsa letsoho li na le mathata a mangata?

E ka sebelisa crontab Mesebetsi e reriloeng.

Mohlala, ho boloka bekapo ka bohona ka hora ea bobeli hoseng letsatsi le leng le le leng:

0 2 * * * mysqldump -u root -p123456 shopdb > /backup/shop_$(date +\%F).sql

Sena se tla hlahisa faele ea bekapo e nang le letsatsi letsatsi le letsatsi.

总结

Ho boloka polokelo ea database ha se khetho, empa ke taba ea bophelo le lefu.

monghadi mysqldump,gunzip le mysql Taelo ea ho kenya e tšoana le ho ba le switch ea matla ho laola database.

Ntlha ea ka e hlakile haholo:Tšireletso ea data ke ntho ea bohlokoa ka ho fetisisa k'hamphaning, 'me bekapo ke eona feela tšireletso.

Jwalo ka ha Harvard Business Review e boletse:

"Mehleng ena ea dijithale, data e bohlokoa ho feta khauta."

Kahoo nka khato hona joale, ngola mongolo oa hau oa bekapo, 'me u boloke lintlha tsa hau li tiile matsohong a hau.

Sena ha se taba ea theknoloji feela, empa hape se mabapi le boikarabello.