phpMyBackupPro - Ọpa Afẹyinti MySQL wẹẹbu Kan fun Linux

phpMyBackupPro jẹ orisun ṣiṣi pupọ rọrun lati lo ohun elo afẹyinti MySQL wẹẹbu, ti a kọ ni ede PHP ti a tu silẹ labẹ GNU GPL. O fun ọ laaye lati ṣẹda awọn afẹyinti iṣeto, mu pada ati ṣakoso wọn, igbasilẹ, imeeli, tabi gbe awọn afẹyinti si eyikeyi olupin FTP ati pupọ diẹ sii. O tun gba igbasilẹ awọn ilana Faili ki o gbe wọn si olupin FTP kan.

O ṣe atilẹyin awọn ipele funmorawon mẹta ti awọn afẹyinti (Ko si funmorawon, pelu tabi fifun gzip). O tun ṣe atilẹyin awọn ọna iwọle wiwọle aabo meji miiran, HTTP tabi ijẹrisi HTML.

Awọn ẹya ara ẹrọ

Atẹle ni diẹ ninu awọn ẹya bọtini pataki ti “phpMyBackupPro“.

  1. Nikan tabi Ọpọlọpọ atilẹyin atilẹyin data pẹlu tabi laisi data, iṣeto tabili.
  2. Ipele mẹta ti funmorawon ti o ni atilẹyin kii ṣe funmorawon, gzip tabi ifunpọ zip.
  3. Ṣẹda awọn afẹyinti ti a ṣeto laisi awọn iṣẹ cron nipa lilo afọwọkọ PHP kekere.
  4. Po si awọn afẹyinti taara si olupin FTP ati fifiranṣẹ awọn afẹyinti nipasẹ imeeli.
  5. Apache ati PHP nikan nilo lati ṣiṣẹ lori awọn iru ẹrọ bii Linux, Mac tabi Windows.
  6. Ikarahun ikarahun lati mu awọn afẹyinti pẹlu ọwọ tabi nipa lilo iwe afọwọkọ cron.
  7. Gbogbo igbasilẹ liana Oluṣakoso ki o gbe wọn si olupin FTP eyikeyi.
  8. Gba afẹyinti awọn apoti isura infomesonu lati oriṣiriṣi awọn iroyin lori ọpọlọpọ awọn olupin MySQL.
  9. Awọn ọna idanimọ aabo meji ni atilẹyin HTTP tabi ijẹrisi iwọle iwọle HTML.
  10. Iboju ọrẹ ati irọrun rọrun lati fi sori ẹrọ ati iṣeto.
  11. Ọpọlọpọ ede ni atilẹyin.

Gbigba awọn afẹyinti MySQL ati mimu-pada sipo wọn lati laini aṣẹ jẹ iṣe ti o dara nigbagbogbo, ṣugbọn ti o ba jẹ kini nigba ti o ko ba ni iraye si olupin. Ni yen, ipo phpMyBackupPro ọpa wa ni ọwọ.

Bii o ṣe le Fi phpMyBackupPro sii ni RHEL/CentOS/Fedora ati Debian/Ubuntu

Fun fifi sori ohun elo phpMyBackupPro, o gbọdọ ni ṣiṣe olupin wẹẹbu Apache ati PHP ti a fi sii lori olupin naa. Jẹ ki a fi awọn idii ti a beere wọnyi sori olupin naa.

Fi sori ẹrọ lori awọn eto ipilẹ Red Hat nipa lilo pipaṣẹ yum.

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

Fi sori ẹrọ lori awọn eto orisun Debian nipa lilo pipaṣẹ-gba aṣẹ.

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

Ẹya phpMyBackupPro tuntun julọ ni a le gba lati ayelujara lati aṣẹ wget lati gba lati ayelujara.

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

Ṣii faili zip zip phpMyBackupPro labẹ/usr/share/directory.

# unzip phpMyBackupPro-2.5.zip

Fun awọn idi aabo, o dara lati gbe akoonu ti folda naa labẹ/usr/share/phpmybackup liana.

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

Nigbamii lọ si itọsọna Apache “conf.d” ki o ṣẹda faili ti a npè ni “phpmybackup.conf” labẹ rẹ. Fun ọna awọn ọna ṣiṣe ti Hat Hat yẹ ki o jẹ (/etc/httpd/conf.d/) ati fun 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]

Fi awọn ila wọnyi si. Fipamọ ki o sunmọ. Awọn ofin ti o wa ni isalẹ nipasẹ aiyipada jẹ ki iraye si gbogbo, ti o ba fẹ lati ni ihamọ wiwọle si IP kan pato. Rọpo “gbogbo” pẹlu adirẹsi IP rẹ ”. Fun apẹẹrẹ, laini yẹ ki o “gba laaye lati 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>

Tun iṣẹ Afun bẹrẹ.

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

Lori diẹ ninu awọn ọna ṣiṣe, awọn faili kan gbọdọ ni awọn igbanilaaye kikọ fun faili “global_conf.php” ati fun itọsọna “okeere”.

# 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

Bayi o ti ṣetan lati bẹrẹ phpMyBackupPro. Lilọ kiri si ẹrọ lilọ kiri lori ayelujara ki o fifuye faili config.php bii eleyi.

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

Ninu taabu iṣeto ni o fi awọn alaye MySQL sii, bii orukọ olupin, orukọ olumulo, ọrọ igbaniwọle ati orukọ ibi ipamọ data. Ti o ba fẹ lati ṣeto FTP lati fi awọn afẹyinti pamọ, tẹ awọn alaye iwọle FTP sii bi a ṣe han ni isalẹ.

Itele, tẹ lori “afẹyinti” taabu lati wo atokọ ti ibi ipamọ data MySQL rẹ ki o yan orukọ ibi ipamọ data ti o fẹ mu afẹyinti.

Afẹyinti iṣeto ni awọn ọna olokiki meji lati ṣeto awọn afẹyinti:

  1. Nipasẹ pẹlu iwe afọwọkọ iṣeto sinu ohun elo to wa.
  2. Nipasẹ lilo fireemu ti o farapamọ ninu awọn fireemu HTML kan.

Lati seto afẹyinti, o gbọdọ kọkọ ṣẹda iwe afọwọkọ iṣeto kan. Lọ si taabu “ṣeto afẹyinti”.

Yan bii igbagbogbo ti o fẹ ṣe afẹyinti lati ṣẹda. Lẹhinna o ni lati yan itọsọna ti iwe afọwọkọ PHP yẹn eyiti yoo pẹlu iwe afọwọkọ iṣeto nigbamii. Lẹhin eyini yan orukọ ti ibi ipamọ data si afẹyinti, tẹ asọye kan, yan iru titẹkuro ati nikẹhin tẹ bọtini “Fihan iwe afọwọkọ”. Ni oju-iwe ti o tẹle iwọ yoo wo iwe afọwọkọ iṣeto tuntun ti a ṣẹda.

Dipo didakọ koodu ti a ṣẹda si faili tuntun, o le fi koodu pamọ nipa fifun orukọ faili bi “schedu_backup.php” ninu apoti ọrọ ki o tẹ “Fipamọ data” lati fipamọ. Fun alaye diẹ sii ka faili “SCHEDULED_BACKUPS.txt” labẹ ilana iwe.

Taabu “awọn ibeere sql” kọ lati ṣiṣẹ awọn ibeere sql ti o rọrun si awọn apoti isura data tabi gbe awọn apoti isura data wọle lati kọmputa agbegbe.

Taabu “bẹrẹ” ṣe afihan Apache ti isiyi rẹ, PHP ati alaye ẹya MySQL.

phpMyBackupPro jẹ ọna jijin ojutu afẹyinti rọọrun fun MySQL. Ti o ba n ṣakoso olupin MySQL, lẹhinna pMBP jẹ ohun elo ti o nilo ti o le ṣe iranlọwọ fun ọ lati fipamọ data iyebiye rẹ pẹlu igbiyanju to kere julọ.

Itọkasi Awọn ọna asopọ

phpMyBackupPro akọọkan