Nduzi zuru oke maka iwu nkwado ndabere na mwepụ nke MySQL/MariaDB: Site na onye mbido ruo ọkachamara

MySQLNduzi zuru oke maka MariaDB Backup and Decompression Commands

Site na onye mbido ruo ọkachamara, ọ na-egosi...MySQLUsoro ọmụmụ a na-enye usoro ọrụ zuru oke maka nkwado ndabere dump, mkpakọ gzip, mwepu gunzip, na mbubata MySQL, na-enyere ndị mmepe aka ịmụta nkà nchekwa data na mgbake ngwa ngwa iji hụ na nchekwa data na ịga n'ihu azụmaahịa.

Ọ bụ ezie na MySQL na MariaDB nwere otu mmalite, ha dị iche nke ukwuu n'ihe gbasara ikike isi mmalite mepere emepe, mgbasawanye atụmatụ, imeziwanye arụmọrụ, na gburugburu ebe obibi obodo. MariaDB na-emesi ike na mmepe isi mmalite zuru oke na atụmatụ ọhụrụ, ebe MySQL na-adabere na nkwado azụmaahịa Oracle ma dabara adaba maka ngwa ọkwa ụlọ ọrụ.

Ọ bụ naanị mgbe nchekwa data ahụ dara ka m ghọtara mkpa ọ dị ịkwado ndabere.

Onye mmepụta ọ bụla enwetala obi mgbawa nke mfu data, iwu nkwado ndabere na mweghachi nke MySQL na MariaDB bụ ihe nchekwa ahụ.

Ugbu a, m ga-eduzi gị n'ụzọ kachasị mfe iji ghọta nke ọma iwu nkwado ndabere, mwepụ, na mbubata maka MySQL/MariaDB.

Gịnị mere iwu nkwado ndabere MySQL/MariaDB ji dị oke mkpa?

Data bụ isi iyi nke azụmaahịa.

Ọ bụrụ na e mebie nchekwa data ahụ, ọ nwere ike ibute nsogbu azụmaahịa ma ọ bụ ọbụna mfu nke nde dollar.

Dịka nnyocha e mere na IEEE Transactions on Computers si kwuo, ụlọ ọrụ na-enwe mfu ruru [ọnụọgụ efu] kwa nkeji site na oge ọrụ nchekwa data.5600 USD(Isi mmalite: IEEE, 2023).

Ọ bụ ya mere ị ga-eji mara iwu ndabere.

Nkọwa zuru ezu nke Iwu Ndabere MySQL/MariaDB

Ụzọ nkwado ndabere kachasị ewu ewu bụ ijimysqldump.

Iwu ahụ bụ nke a:

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

• -u root: Kwupụta onye ọrụ ahụ.
• -p[root_password]Tinye paswọọdụ gị.
• [database_name]: Aha nchekwa data a ga-akwado.
• dumpfilename.sqlAha faịlụ ndabere.

Dịka ọmụmaatụ, ọ bụrụ na a kpọrọ nchekwa data gị...shopdbAha faịlụ ahụ bụshop_backup.sqlYa mere, iwu ahụ bụ:

mysqldump -u root -p123456 shopdb > shop_backup.sql

MariaDB na-akwadokwa nke a.mysqldumpUsoro okwu ahụ kwekọrọ kpamkpam.

Ị naghị enwe mmasị na ya?

Ndabere nha faịlụ na mkpakọ

Mgbe ụfọdụ, faịlụ nchekwa data buru ibu nke ukwuu, naanị gigabytes ole na ole.

Nke a bụ ebe mkpakọ na-abata.

LinuxIwu mkpakọ kachasị bụgzip:

gzip shop_backup.sql

Faịlụ a gbakọrọ aghọọshop_backup.sql.gz.

Nke a anaghị echekwa naanị ohere nchekwa kamakwa ọ na-eme ka nnyefe dị mfe.

Iwu Unzip: Nzọụkwụ mbụ na mgbake

A ga-emepe faịlụ nchekwa data ahụ tupu ebubata ya.

Iwu ahụ bụ nke a:

gunzip FileName.gz

Ntughari:

gunzip shop_backup.sql.gz

Mgbe decompression gasịrị, ị ga-enwetashop_backup.sqlNke a bụ faịlụ enwere ike ibubata.

Nkọwa zuru ezu nke iwu mbubata MySQL/MariaDB

Iwu mbubata na nkwado ndabere ya fọrọ nke nta ka ọ bụrụ onyinyo nke ibe ha:

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

Ọmụmaatụ:

mysql -u root -p123456 shopdb < shop_backup.sql

Nzọụkwụ a na-ebubata data zuru oke site na faịlụ ahụ n'ime nchekwa data.

MariaDB na-ejikwa yamysqlMbubata iwu ahụ dakọtara kpamkpam.

Ọnọdụ ụwa n'ezie: Usoro zuru oke site na nkwado ndabere ruo na mgbake

Ka e were ya na i nwereE-azụmahịaNdekotashopdb.

1. ndabere:

   mysqldump -u root -p123456 shopdb > shop_backup.sql
   

2. mkpakọ:

   gzip shop_backup.sql
   

nwetashop_backup.sql.gz.

1. Wepụ:

   gunzip shop_backup.sql.gz
   

Weghachite nashop_backup.sql.

1. Bubata:

   mysql -u root -p123456 shopdb < shop_backup.sql
   

Emechara usoro ahụ dum nke ọma.

Njehie na Ngwọta Ndị A Na-ahụkarị

• Njehie 1: Amachibidoro ohere
  Nke a na-egosi paswọọdụ na-ezighi ezi ma ọ bụ ikike onye ọrụ ezughi oke.
  Ngwọta: Lelee ikike ndị ọrụ iji hụ na ha dị.SELECTnaINSERTIkikere.

• Njehie nke 2: Enweghị ebe nchekwa zuru oke
  E ji aka bubata nchekwa data ahụ n'ihi na ebe nchekwa ezughi oke.
  Ngwọta: Jiri--single-transactionMbubata nke paramita n'ọkwa.

• Njehie nke 3: Nsogbu ederede gbagọrọ agbagọ
  Mgbe ebubatachara ya, a na-egosi mkpụrụedemede ndị Chaịna dị ka akara ajụjụ.
  Ngwọta: Tinye ihe ndị a na iwu ahụ--default-character-set=utf8mb4.

Akwụkwọ MySQL gọọmentị na-ekwu nke ọma:

"jiri"mysqldumpNke a bụ ụzọ kachasị mma isi mee nkwado ndabere ezi uche dị na ya, ebe ọ na-eme ka nhazi data na ọdịnaya data sie ike. (Isi mmalite: MySQL Reference Manual, Oracle)

Akwụkwọ MariaDB gọọmentị na-emesi ike:

"MariaDB dakọtara nke ọma na iwu nchekwa na mweghachi nke MySQL, na-enye ndị mmepe ohere ịkwaga n'enweghị nsogbu." (Isi mmalite: MariaDB Knowledge Base)

Nke a na-emesi ike ọzọ mkpa ọ dị nkwado ndabere nke akara iwu.

Usoro dị elu: Ndabere akpaghị aka

Nkwado ndabere aka dị oke nsogbu?

Nwere ike ijicrontabỌrụ ndị e mere atụmatụ ha.

Dịka ọmụmaatụ, nkwado ndabere akpaka na elekere abụọ nke ụtụtụ kwa ụbọchị:

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

Nke a ga-emepụta faịlụ ndabere na ụbọchị kwa ụbọchị.

na mkpokọta

Nchekwa data abụghị nhọrọ, kama ọ bụ okwu nke ndụ na ọnwụ.

nna ukwumysqldump,gunzipnamysqlIwu mbubata dị ka inwe ihe mgba ọkụ ike iji chịkwaa nchekwa data.

Isi okwu m doro anya nke ukwuu:Nchekwa data bụ ihe kachasị mkpa maka ụlọ ọrụ, nkwado ndabere bụkwa naanị ụzọ nchekwa.

Dịka Harvard Business Review si kwuo, "Anyị na-ekwu maka ya:

"N'oge dijitalụ, data bara uru karịa ọlaedo."

Ya mere, mee ihe ugbu a, dee ihe odide gị, ma debe data ahụ nke ọma n'aka gị.

Nke a abụghị naanị gbasara teknụzụ, kamakwa gbasara ibu ọrụ.