Scheduled backup tool of MySql database using FTP
1. Make sure that ZipArchive extension is enabled in your PHP version
2. Download file
3. Edit file and insert your database credentials (Host, database name, username,
password) and insert FTP account (Host, username, password)
4. Upload files and local backup folder (db_backup)
to your website
5. Create corn job using your web control panel
ZipArchive extension is responsible for compressing backup file and it is not supported for php version less than PHP ver. 5.2 and it is not enabled by default in php ver. 7.0 so you need to enable it through your PHP pears section in your control panel if you have shared hosting or through installation extension using SSH if you have VPS or dedicated server How to enable ZipArchive or zip module with PHP in shared hosting Cpanel?
How to install zip module php-zip on Centos & Fedora VPS or dedicated server? Due to an issue with the packaging of zip functionality within Centos & Fedora’s PHP package, the yum package php-zip, which was available for Fedora 15, is not available in Fedora 16. This is actually a “feature”, not a “bug”, but either way, getting zip support in PHP now takes a few extra steps. 1. Install dependencies as root or using sudo: yum install pcre-devel gcc zlib zlib-devel 2. Install zip module using PECL (PEAR‘s sister):pecl install zip 3. Edit the main PHP configuration file to register the new module. Add this text: extension=zip.so; a few lines before this: Module Settings in /etc/php.ini, as root or using sudo, like this: nano /etc/php.ini 4. Restart your web server as root or using sudo: service httpd restart 5. Check that support is enabled using phpinfo(). You should have a section on your phpinfo() page that looks like the image below.
Upload files and local backup folder (db_backup) to your website How to use FTP client to upload your files Once you’re connected to your server, the Local Site area will show the files and folders on your computer and the Remote Site area will show the files and folders on your Host server. The easiest way to copy file to and from the server is to simply drag and drop them from one side to the other.
Create corn job using your web control panel 1. Log to your cPanel Account 2. Search for cron jobs scheduler 3. Setting up a cron job 4. Remember to click the ‘Add New Cron Job’ once you have entered the right values in all fields. Cron jobs are very useful especially when running web applications on the internet. You will need them in one way or another to automate repetitive tasks and we believe this guide has shown you the basics of doing the same.