when finished sends status to php file so we know its completedġ2. imports mysql database which is provided by us on server Cġ2. creates new database with variables defined beforeġ1. Connect to server B (returns status (variable)to our php script so we know connection was succesfulġ0. It checks the strength of password and allows the users to set only those passwords which are secure enough. VALIDATE PASSWORD PLUGIN can be used to test passwords and improve security. Connecting to MySQL using a blank password. copies all the files from server A to server C subomain (rsync) and returns status (variable)to our php script when doneħ. Press yY for Yes, any other key for No: ' + echo 'spawn mysqlsecureinstallation Securing the MySQL server deployment. connects to server A (returns status (variable)to our php script so we know connection was succesfulĤ.1 Creates virtualhost for domain previously created with SSL script we already have ( just need to automate)ĥ. returns status (variable)to our php script so we know that subdomain was createdĤ. server A files locations like /var/www/test1Ģ- Script connect to digitalocean and creates a subdomain via API (with previously defined input data variable )ģ. After that it creates directory to store the databackup on daily basis. In the below shell script, we are defining the env variables to login into mysql. Ubuntu/CentOS MySQL 5.7 Step 1: Shell Script for MySQL DataBase Backup. As per requirement we can schedule the script using cronjob. Script will be triggered from php script made by us In the shell script we are using Mutt (text-based command line mail client) which can send the status of backup job whether it is success/failure. server A which hosts files WWW - apacheġ.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |