![]() Your server is localhost, and you need to create or choose a directory to store your backups in: # Host name (or IP address) of MySQL server e.g localhost passwordĬONFIG_mysql_dump_password=`cat /etc/psa/.psa.shadow` #Horcrux email backup exclude list password#Instead, use the encrypted password: # Password to access the MySQL server e.g. You can dump this password in plain text with this command if you need to recover it: # /usr/local/psa/bin/admin -show-passwordīut you can’t use the plain text password in your AutoMySQLBackup configuration. Starting with version 10.2 the Plesk admin password is encrypted in /etc/psa/.psa.shadow. ![]() It is better to use a different MySQL user, like one you have created with minimal privileges just for AutoMySQLBackup, but if that is not possible then you can’t use the plain-text admin password. There is a complication if you are using Parallels Plesk 10.2 or newer on your server, and you want to authenticate with the admin user. passwordĬONFIG_mysql_dump_password='sekkritpassword' # Password to access the MySQL server e.g. First you need to select a MySQL user that has, at a minimum, SELECT privileges, and then enter that user and user’s password: # Username to access the MySQL server e.g. The configuration file is large and well-commented, and you need to change only a few things to start making and testing your backups. Then you will have a copy of the original for reference, and your working configuration file. Replace “nf” with whatever you want to name your configuration file. These are run from the directory where you unpacked the tarball: # chown root:root automysqlbackup #Horcrux email backup exclude list install#If the installation script fails you can easily install AutoMySQLBackup manually by following these steps. Then your next step is to run install.sh, and this requires root privileges. It may not tell you everything you need to know, so hopefully this article will fill the gaps. Next, read the README because it contains installation instructions and other useful information. Now you should have the automysqlbackup-v3.0_rc6 directory with six files in it: automysqlbackup, nf, CHANGELOG, install.sh, LICENSE, and README. Getting AutoMySQLBackupĭownload AutoMySQLBackup from Sourceforge, and then unpack the tarball: $ tar zxvf automysqlbackup-v3.0_ Then you can copy the tarballs to other media, and encrypt them if you wish. AutoMySQLBackup dumps your databases at whatever intervals you desire, and rolls them up into compressed tarballs. Its only dependency is the mysqldumpcommand, which comes with mysql-client. Grep exclude binary files, we can use grep -I option, it can ignore binary files when searching.AutoMySQLBackup is a clever script that takes the pain out of setting up automated incremental daily, weekly, and monthly backups of MySQL databases. When we use the grep command pattern search, we often find some binary files, these are not what we need, so we need to exclude these binary files. ➜ grep -exclude "test.log" -exclude "m.log" "grep" *.log In the following example, we will use the grep –exclude option to exclude one or more files during pattern search. ➜ grep -exclude "file1" -exclude "file1" "keyword" files Grep - exclude syntax # grep exclude a file Grep exclude file, as with excluding directories, we can use the grep –exclude option, which will exclude files matching the given file name pattern from the search. ➜ grep -exclude-dir "test" -exclude-dir "backup" -R "grep". In the following example, we use grep –exclude-dir to exclude one or more directories. ➜ grep -exclude-dir "directory1" -exclude-dir "directory2" -R "keyword". ➜ grep -exclude-dir "directory" -R "keyword". Grep –exclude-dir syntax # grep exclude a directory Recursively search subdirectories listed. If -R is specified, it excludes directories matching the given filename pattern from the search. Grep –exclude-dir excludes directories matching the given file name pattern from the search. Grep exclude directories, we can use the grep –exclude-dir option, which needs to be used with the grep -R option. ![]() ![]() ➜ ~ grep -i 'use' test.log | grep -v "option" | grep -v "find" Grep exclude directory In the following example, we will use a pipeline with grep to exclude multiple keywords. ➜ ~ grep -i 'use' test.log | grep -v "option" In the following example, we will use grep to search for keywords and exclude specific keyword. ➜ grep -v "keyword1" file | grep -v "keyword2" |. Grep -v syntax # grep excludes a single keyword Selected lines are those not matching any of the specified patterns. We can use the grep -v option, which can which can invert the match. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |