phpMyBackupPro - Ngwá Ọrụ ndabere MySQL dabere na Weebụ maka Linux

phpMyBackupPro bụ ebe mepere emepe dị mfe iji ngwa ndabere MySQL dabere na weebụ, edere n'asụsụ PHP ewepụtara n'okpuru GNU GPL. Ọ na-enye gị ohere ịmepụta ndabere oge, weghachite na jikwaa ha, budata, email, ma ọ bụ bulite ndabere na sava FTP ọ bụla na ọtụtụ ihe ndị ọzọ. Ọ na-ewekwa ndabere akwụkwọ ndekọ aha faịlụ wee bulite ha na sava FTP.

Ọ na-akwado ọkwa mkpakọ atọ nke nkwado ndabere (enweghị mkpakọ, zip ma ọ bụ mkpakọ gzip). Ọ na-akwado ụzọ nbanye abụọ nchekwa ọzọ, HTTP ma ọ bụ HTML.

Atụmatụ

Ndị na-esonụ bụ ụfọdụ isi atụmatụ nke phpMyBackupPro.

  1. Nkwado ndabere nchekwa data dị otu ma ọ bụ ọtụtụ nwere ma ọ bụ enweghị data, nhazi tebụl.
  2. Ọkwa atọ nke mkpakọ akwadoro abụghị mkpakọ, gzip ma ọ bụ zip compress.
  3. Mepụta nkwado ndabere na mpaghara na-enweghị ọrụ cron site na iji obere edemede PHP.
  4. Bulite ndabere ozugbo na sava FTP yana biputere nkwado ndabere na mpaghara site na email.
  5. Naanị Apache na PHP chọrọ iji na-agba ọsọ na nyiwe dị ka Linux, Mac ma ọ bụ Windows.
  6. Ntụgharị Shell iji jiri aka were were ndabere ma ọ bụ site na iji cron script.
  7. Ndabere akwụkwọ ndekọ aha faịlụ niile wee bugharịa ha na sava FTP ọ bụla.
  8. Were ndabere ọdụ data site na akaụntụ dị iche iche na ọtụtụ sava MySQL.
  9. Ụzọ nchekwa abụọ akwadoro nbanye HTTP ma ọ bụ HTML.
  10. Ntụgharị enyi na-adịkwa mfe ịwụnye na nhazi.
    11. akwadoro ọtụtụ asụsụ.

Inweta nkwado ndabere na mpaghara MySQL na iweghachi ha site na ahịrị iwu bụ omume dị mma mgbe niile, mana ọ bụrụ na ọ bụrụ na ịnweghị ohere anụ ahụ na sava. Na nke ahụ, ọnọdụ phpMyBackupPro ngwá ọrụ na-abịa kemfe.

Otu esi etinye phpMyBackupPro na RHEL/CentOS/Fedora na Debian/Ubuntu

Maka ịwụnye ngwa phpMyBackupPro, ị ga-enwerịrị sava weebụ Apache yana PHP arụnyere na sava ahụ. Ka anyị tinye ngwugwu ndị a chọrọ na ihe nkesa.

Wụnye na sistemu okpu uhie site na iji iwu yum.

# yum install httpd php php-mysql     [RHEL/CentOS 7]
# yum install httpd php php-mysqlnd   [RHEL/CentOS 8]
# service httpd start

Wụnye na sistemụ Debian site na iji apt-nweta iwu.

# apt-get install apache2 
# apt-get install php libapache2-mod-auth-mysql php-mysql
# service apache2 start

Enwere ike ibudata ụdị phpMyBackupPro kachasị ọhụrụ site na iwu wget iji budata.

# cd /usr/share
# wget https://sourceforge.net/projects/phpmybackup/files/phpMyBackupPro/phpMyBackupPro%202.5/phpMyBackupPro-2.5.zip/download -O phpMyBackupPro-2.5.zip

Wepụ faịlụ zip phpMyBackupPro n'okpuru /usr/share/ directory.

# unzip phpMyBackupPro-2.5.zip

Maka ihe nchekwa, ọ ka mma idowe ọdịnaya nke folda n'okpuru /usr/share/phpmybackup directory.

# cd /usr/share/
# mv phpMyBackupPro-2.5/ /usr/share/phpmybackup

Ọzọ gaa na ndekọ Apache conf.d wee mepụta faịlụ akpọrọ phpmybackup.conf n'okpuru ya. N'ihi na Red Hat dabeere na usoro kwesịrị ịbụ (/etc/httpd/conf.d/) na maka Debain (/etc/apache2/conf.d).

# vi /etc/httpd/conf.d/phpmybackup.conf      [On RedHat based systems]
# vi /etc/apache2/conf.d/phpmybackup.conf    [On Debian based systems]

Tinye ahịrị ndị a na ya. Chekwa ma mechie. Iwu ndị dị n'okpuru na ndabara na-enye ohere ịnweta mmadụ niile, ma ọ bụrụ na ịchọrọ igbochi ohere ịnweta IP akọwapụtara. Dochie niile na adreesị IP gị. Dịka ọmụmaatụ, ahịrị ahụ kwesịrị ịbụ kwenye site na 172.16.25.125.

---------------- Apache 2.4 ----------------
Alias /phpmybackup /usr/share/phpmybackup
<Directory /usr/share/phpmybackup>
Require all granted
</Directory>

---------------- Apache 2.2 ----------------
Alias /phpmybackup /usr/share/phpmybackup
<Directory /usr/share/phpmybackup>
   Options None
   Order allow,deny
   allow from all
</Directory>

Malitegharịa ekwentị Apache.

-------- (On Red Hat systems) -------- 
# systemctl restart httpd
Or
# /etc/init.d/httpd restart 

-------- (On Debian systems) --------
# systemctl restart apache2
Or
# /etc/init.d/apache2 restart

Na sistemụ ụfọdụ, ụfọdụ faịlụ ga-enwerịrị ikikere ide maka faịlụ “global_conf.php” yana maka ndekọ “mbupu”.

# cd /usr/share/

# chown -R root:apache phpmybackup (On Red Hat systems)

# chown -R root:www-data phpmybackup (On Debian systems)

# cd /usr/share/phpmybackup/
# chmod 0777 global_conf.php
# chmod 0777 export

Ugbu a ị dịla njikere ịmalite phpMyBackupPro. Gaa na ihe nchọgharị ahụ wee buru faịlụ config.php dị ka nke a.

http://localhost/phpmybackup/config.php
OR
http://ip-address/phpmybackup/config.php

Na nhazi taabụ fanye nkọwa MySQL gị, dị ka aha nnabata, aha njirimara, paswọọdụ na aha nchekwa data. Ọ bụrụ na ịchọrọ ịtọlite FTP iji chekwaa ndabere, tinye nkọwa nbanye FTP dị ka egosiri n'okpuru.

Na-esote, pịa taabụ “ndabere” ka ịhụ ndepụta nke nchekwa data MySQL wee họrọ aha nchekwa data ịchọrọ iwere ndabere.

Ndabere nke usoro ihe omume nwere ụzọ abụọ ewu ewu maka ịtọọ oge ndabere:

  1. Site n'itinye ederede nhazi oge n'ime ngwa dị adị.
  2. Site na iji free zoro ezo n'ime HTML frameset.

Ka ịtọọ oge ndabere, ị ga-ebu ụzọ mepụta edemede nhazi oge. Gaa na taabụ ndabere oge.

Họrọ ugboro ole ịchọrọ ka ewepụta ndabere. Mgbe ahụ, ị ga-ahọrọ ndekọ nke ederede PHP nke ga-agụnye edemede nhazi oge emechaa. Mgbe ahụ họrọ aha nke nchekwa data ka ndabere, tinye okwu, họrọ mkpakọ ụdị na n'ikpeazụ pịa na Gosi script button. Na ibe na-esote, ị ga-ahụ edemede nhazi oge emepụtara ọhụrụ.

Kama iṅomi koodu emepụtara na faịlụ ọhụrụ, ị nwere ike ịchekwa koodu ahụ site n'inye aha faịlụ dịka schedule_backup.php na igbe ederede wee pịa Chekwa data iji chekwaa. Maka ozi ndị ọzọ gụọ faịlụ SCHEDULED_BACKUPS.txt n'okpuru akwụkwọ ndekọ aha.

“Ajụjụ sql” taabụ na-ewulite iji gbaa ajụjụ sql dị mfe na ọdụ data ma ọ bụ bubata ọdụ data sitere na kọmputa mpaghara.

Taabụ “mmalite” na-egosipụta ozi ụdị Apache gị ugbu a, PHP na MySQL.

phpMyBackupPro bụ ihe ndabere kachasị mfe maka MySQL. Ọ bụrụ na ị na-ejikwa ihe nkesa MySQL, mgbe ahụ pMBP bụ ngwa dị mkpa nke nwere ike inyere gị aka ịchekwa data dị oke ọnụ ahịa na mbọ kacha nta.

Njikọ ntụaka

phpMyBackupPro ibe