phpMyBackupPro - Kayan Ajiyayyen MySQL na Yanar gizo don Linux

phpMyBackupPro buɗaɗɗen tushe ne mai sauƙin amfani da aikace-aikacen madadin MySQL na yanar gizo, wanda aka rubuta a cikin yaren PHP da aka fitar a ƙarƙashin GNU GPL. Yana ba ka damar ƙirƙirar ajiyayyun jadawalin jadawalin, dawo dasu da sarrafa su, zazzagewa, imel, ko loda madadin zuwa kowane sabar FTP da ƙari mai yawa. Hakanan yana ɗaukar kundin adireshi na Fayil don adanawa da loda su a kan FTP Server.

Yana tallafawa matakan matsi uku na madadin (Babu matsi, zip ko gzip compression). Hakanan yana goyan bayan hanyoyin shiga biyu na tsaro, HTTP ko HTML.

Fasali

Wadannan wasu manyan mahimman fasali ne na “phpMyBackupPro“.

  1. Guda ɗaya ko pleimbin bayanan ajiyar bayanai tare da ko ba tare da bayanai ba, tsarin tebur.
  2. Mataki uku na matsewa da aka tallafawa ba matsa bane, gzip ko zip matsawa.
  3. Createirƙiri tsare-tsaren da aka tsara ba tare da ayyukan cron ta amfani da ƙaramin rubutun PHP ba.
  4. Loda abubuwan ajiya kai tsaye zuwa sabar FTP da lika bayanan imel ta imel.
  5. Apache da PHP kawai ake buƙata don gudana a kan dandamali kamar Linux, Mac ko Windows.
  6. Shell dubawa don ɗaukar madadin ta hannu ko ta amfani da rubutun cron.
  7. Dukkanin kundin adireshi sai a matsar dasu zuwa duk wata sabar FTP.
  8. Takeauki ajiyar bayanan bayanai daga asusu daban-daban akan sabobin MySQL da yawa.
  9. Hanyoyi biyu na tabbatar da tsaro sun tallafawa HTTP ko HTML don tabbatar da shiga.
  10. Abubuwan dubawa na abokantaka kuma masu sauƙin shigarwa da saitawa.
  11. Ana tallafawa harsuna da yawa.

Samun bayanan MySQL da dawo dasu daga layin umarni koyaushe kyakkyawan aiki ne, amma idan menene lokacin da baku da damar isa ga sabar. A cikin wannan, yanayin phpMyBackupPro kayan aiki ya zo cikin sauki.

Yadda ake Shigar phpMyBackupPro a RHEL/CentOS/Fedora da Debian/Ubuntu

Don shigar da aikace-aikacen phpMyBackupPro, dole ne ku sami sabar yanar gizo ta Apache da PHP da aka sanya akan sabar. Bari mu shigar da waɗannan buƙatun da ake buƙata akan sabar.

Sanya a kan tsarin Red Hat ta amfani da umarnin yum.

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

Shigar da tsarin Debian ta hanyar amfani da umarnin da ya dace.

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

Za'a iya zazzage sabon juzu'in phpMyBackupPro daga umarnin wget don zazzagewa.

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

Bude fayil din zip na phpMyBackupPro a karkashin/usr/share/directory.

# unzip phpMyBackupPro-2.5.zip

Saboda dalilan tsaro, ya fi kyau sanya abun cikin jakar a karkashin/usr/share/phpmybackup directory.

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

Nan gaba je zuwa Apache "conf.d" directory kuma ƙirƙiri fayil mai suna "phpmybackup.conf" a ƙarƙashinsa. Don hanyar Red Hat bisa tsarin yakamata ya kasance (/etc/httpd/conf.d/) da na 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]

Appara layuka masu zuwa zuwa gare shi. Adana kuma ka rufe. Dokokin da ke ƙasa ta tsohuwa suna ba da damar isa ga duka, idan kuna son ƙuntata damar zuwa takamaiman IP. Sauya “duka” tare da adireshin IP ɗinka ”. Misali, layin ya zama “bada izinin daga 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>

Sake kunna sabis na 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

A kan wasu tsarin, wasu fayiloli dole ne su sami izinin izini don fayil ɗin "global_conf.php" da kuma kundin fitarwa na "fitarwa".

# 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

Yanzu kun kusan shirya don fara phpMyBackupPro. Kewaya zuwa burauzar kuma loda fayil din config.php kamar haka.

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

A cikin sanyi shafin saka bayanan MySQL ɗinku, kamar sunan mai masauki, sunan mai amfani, kalmar wucewa da sunan bayanai. Idan kanaso ka saita FTP dan adana bayanai, shigar da bayanan shiga FTP kamar yadda aka nuna a kasa.

Na gaba, danna maballin "madadin" don ganin jerin bayanan MySQL ɗinku kuma zaɓi sunan bayanan da kuke son ɗaukarwa.

Jadawalin jadawalin yana da shahararrun hanyoyi biyu don tsara jadawalin:

  1. Ta hanyar haɗa rubutun jadawalin cikin aikace-aikacen da ake ciki.
  2. Ta amfani da ɓoyayyen firam a cikin tsarin HTML.

Don tsara ajiyar waje, dole ne ka fara ƙirƙirar rubutun jadawalin. Jeka shafin "tsara jadawalin".

Zaɓi yadda sau da yawa kuke so madadin da za a generated. Sannan dole ne ku zaɓi kundin adireshin wannan rubutun na PHP wanda zai haɗa da rubutun jadawalin daga baya. Bayan haka zaɓi sunan matattarar bayanai don adanawa, shigar da sharhi, zaɓi nau'in matsi kuma a ƙarshe danna maɓallin "Nuna rubutun". A shafi na gaba zaka ga sabon tsarin tsara jadawalin.

Maimakon yin kwafin lambar da aka kirkira zuwa sabon fayil, zaka iya adana lambar ta hanyar bayar da suna kamar "schedu_backup.php" a cikin akwatin rubutu saika latsa kan "Ajiye bayanai" don adanawa. Don informationarin bayani karanta fayil “SCHEDULED_BACKUPS.txt” a ƙarƙashin kundin bayanai.

Shafin "tambayoyin sql" suna ginawa don gudanar da tambayoyin sql mai sauki zuwa rumbunan adana bayanai ko shigo da rumbunan adana bayanai daga kwamfutar cikin gida.

A “fara” tab nuna your halin yanzu Apache, PHP da MySQL version bayani.

phpMyBackupPro shine mafi sauki madadin maganin MySQL. Idan kuna amfani da sabar MySQL, to pMBP shine aikace-aikacen da ake buƙata wanda zai iya taimaka muku adana bayananku masu daraja tare da ƙaramar ƙoƙari.

Tunanin Mahaɗa

shafin farko na phpMyBackupPro