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-ekpuchi...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 usoro 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 ga-enyere ya aka.

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

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 mmechi azụmaahịa na ọbụna mfu nke ọtụtụ nde mmadụ.

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 site n'isi.

Nkọwa zuru ezu nke Iwu Ndabere MySQL/MariaDB

Ụzọ nkwado ndabere kachasị ewu ewu bụ iji mysqldump.

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.

Ọ́ bụghị ihe dị mfe nghọta?

Ndabere nha faịlụ na mkpakọ

Mgbe ụfọdụ, faịlụ nchekwa data buru ibu nke ukwuu, ọtụtụ mgbe ọtụtụ gigabytes n'ogo.

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 data 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

dị ka:

gunzip shop_backup.sql.gz

Mgbe decompression gasịrị, ị ga-enweta shop_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 ga-ebubata data ahụ site na faịlụ ndabere kpamkpam n'ime nchekwa data ahụ.

MariaDB na-ejikwa ya mysql Mbubata 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ịaNdekota shopdb.

1. ndabere:

   mysqldump -u root -p123456 shopdb > shop_backup.sql
   

2. mkpakọ:

   gzip shop_backup.sql
   

nweta shop_backup.sql.gz.

1. Wepụ:

   gunzip shop_backup.sql.gz
   

Weghachite na shop_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ị. SELECT na INSERT Ikikere.

• Njehie nke 2: Ebe nchekwa agwụla
  Nchekwa data ahụ buru oke ibu, ebe nchekwa adịghịkwa ezu oke n'oge ebubata ya.
  Ngwọta: Jiri --single-transaction Bubata paramita n'ime otu.

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

Echiche ndị e hotara n'aka ndị nwere ikike

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

"jiri" mysqldump Nchekwa ndabere ezi uche dị na ya bụ ụzọ kachasị mma maka na ọ 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)

Nkwupụta a na-ekwughachi mkpa ọ dị nkwado ndabere akara iwu.

Usoro dị elu: Ndabere akpaghị aka

Nkwado ndabere aka dị oke nsogbu?

Nwere ike iji crontab Ọ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 ukwu mysqldump,gunzip na mysql Iwu mbubata dị ka inwe ihe mgba ọkụ ike iji chịkwaa nchekwa data.

Isi okwu m doro anya nke ukwuu:Nchekwa data bụ ihe kacha mkpa ụlọ ọrụ, nkwado ndabere bụkwa naanị ihe 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 ndabere gị, ma debe data gị nke ọma n'aka gị.

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