System Administrator Blog And Scripts

Shell script to Backup MySQL Database (Exclude the System Databases, like performance_schema & information_schema) This script will automatically mount the  share  folder from backup_server and make the backup of all the databases which are  in  the server and  execludes  the system databases like performance_schema and information_schema  1. Create a shell script file with Sql_backup . sh  #  vi  /root/Sql_backup . sh Code: Sql_backup . sh # ! /bin/bash mount -t cifs //backup_server/backup_folder /mnt/backups -o username=username,password=password,domain=domain_name; if   [  `echo  $?` - eq  0  ] then                  cd  /mnt/backups;                 STTIME=`date +%d_%m_%y_%H`;    ...

How to setup Nginx, My SQL, PHP enabled on Centos 6.7 1. Update the yum repository as the Nginx is not directly available from Centos # yum install epel -release 2. Install MySQL with dependencies # yum install mysql-server 3. Once the MySQL installation is completed start the MySQL services. # service mysqld start or # sudo /etc/ init . d/mysqld restart 4. We can secure MySQL by running this command, we can alse setup root password for the MySQL # /usr/bin/mysql_secure_installation Enter current password for root (enter for none): OK, successfully used password, moving on... Since we have installed the MySQL just now we dont have the password for root, Just press Enter key By default, a MySQL installation has an anonymous user, allowing anyone to log into MySQL without having to have a user account created for them .  This is intended only for testing, and to make the installation go a bit smoother.  You shou...

Creating new projects in the SVN Assuming that we have already SVN repository, if not you can create using this link   here . Change to the repository directory #  cd  /var/www/ svn Create the repository with   svnadmin   command # svnadmin create new_porject_name edit   the   svn   access control file to give access to the project [ groups ] new_project_group_name = user1, user2 [new_project_name : /] @new_project_group_name=rw @userx =  rw Now give change the   owner ship   of the folder to apache user and group so that it can be accessed from browsers and   svn # chown -R apache . apache  new_porject_name Now import the initial folders to the project [ brancks , tags , trunk] folders to the new project # svn import -m 'Initial import' /tmp/ svn -structure/ http://192.168.1.84:808/svn/ new_porject_name Now edit the   svnserve . conf   file so that to r...