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, e re ...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 kapele bokhoni ba ho boloka data le ho e khutlisa 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 ka tsela e tobileng ka ho fetisisa ya ho utlwisisa ka botlalo ditaelo tsa bekapo, decompression, le import bakeng sa MySQL/MariaDB.

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 litšitisong tsa khoebo kapa esita le tahlehelo ea limilione tsa lidolara.

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.5600 USD(Mohloli: IEEE, 2023).

Ke ka lebaka leo o lokelang ho tloaelana le litaelo tsa bekapo.

Tlhaloso e qaqileng ea Litaelo tsa Backup tsa MySQL/MariaDB

Mokhoa o tloaelehileng haholo oa ho boloka bekapo ke ho sebelisamysqldump.

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 keshop_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 o e rate?

Boholo ba faele ea bekapo le khatello

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

Mona ke moo khatello e kenang teng.

LinuxTaelo e tloaelehileng haholo ea khatello kegzip:

gzip shop_backup.sql

Faele e hatelletsoeng e bashop_backup.sql.gz.

Sena ha se boloke sebaka sa polokelo feela empa se boetse se etsa hore phetiso e be bonolo.

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

Phetolelo:

gunzip shop_backup.sql.gz

Kamora ho fokotsa khatello ea maikutlo, u tla fumanashop_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 kenya data e felletseng ho tsoa faeleng ho ea polokelongtshedimosetsong.

MariaDB e boetse e sebelisamysqlTaelo 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 ea inthanete数据库shopdb.

1. Boloka:

   mysqldump -u root -p123456 shopdb > shop_backup.sql
   

2. khatello:

   gzip shop_backup.sql
   

fumanashop_backup.sql.gz.

1. Unzip:

   gunzip shop_backup.sql.gz
   

Khutlisetsa hoshop_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.SELECTleINSERTLitumello.

• Phoso ea 2: Khopolo e sa lekaneng
  Database e kentswe ka letsoho ka lebaka la memori e sa lekaneng.
  Tharollo: Tšebeliso--single-transactionHo kenngoa ha liparamente ka bongata.

• 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.

Litokomane tsa semmuso tsa MySQL li bolela ka ho hlaka:

"sebelisamysqldumpEna ke tsela e molemohali ea ho etsa li-backup tse utloahalang, kaha e 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)

Sena se totobatsa hape 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 sebelisacrontabMesebetsi 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.

monghadimysqldump,gunziplemysqlTaelo 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 bakeng sa likhoebo, 'me bekapo ke eona feela tsela ea 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 lingoloa tsa hau, 'me u boloke lintlha li tiile matsohong a hau.

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