RegEx Files and Directories Exclusion https://www.akeeba.com/documentation/akeeba-solo/regex-files-directories-exclusion.html Sometimes you know that you have to exclude files or directories following a specific naming pattern, but there are so many that it's completely impractical going to the normal exclusion filters page and click them one by one. Or they are scattered around the file system tree, making it extremely complex to track them down and exclude them. Wouldn't it be nice to have an automated way to say, for example, "exclude all SVN directories from the backup"? Enter regular expressions. What are those regular expressions? Let's see what Wikipedia has to say on the subject: In computing, regular expressions, also referred to as regex or regexp, provide a concise and flexible means for matching strings of text, such as particular characters, words, or patterns of characters. A regular expression is written in a formal language that can be interpre...
Postingan
To clear your Java cache in Windows : Click Start > Control Panel. Locate and double click the Java icon in the Control Panel. Click Settings under Temporary Internet Files. Click Delete Files. Select all boxes and click OK on Delete Temporary Files window . Click OK on Temporary Files Settings window . Item lainnya... • 6 Mar 2011 wiki.umbc.edu › plugins › servlet How do I clear my Java cache?
https://stackoverflow.com/questions/49705813/pentaho-excel-file-creation-with-file-name-from-field-or-other-variable Not knowing what your existing solution does, or why, this is the best way I can think of solving your problem, given you want exactly the same data in a different file format: Create a new job. In that job start a new transformation called 'get locations' In this 'get locations' transformation as below, have two steps a) Table input, with a query like 'select distinct locations from data' and b) copy rows to result. This should give you a list of your unique locations Create another new job called 'set variable and make excel'. This job will be run after your 'get locations' transformation, tick the 'execute once for every row' checkbox In the new job, you'll have two transformations. set variable, and make excel. The set variable transformation has two steps, first 'gets rows from results' then 'set vari...
Proses install database server MySQL adalah hal yang mudah dan biasanya langsung digunakan begitu saja oleh PHP hanya dengan setting apa password rootnya. Tapi ada satu langkah yang harus dilakukan yaitu mengamankan settingnya yang default. Selain dengan mengedit file my.cnf ada cara yang gampang. 🙂 Catatan saja cara berikut berlaku untuk MySQL, MariaDB, Percona Server dan mungkin fork – fork lainnya yang belum saya ketahui. Saya mencontohkan pada VPS dengan sistem operasi Debian yang telah terpasang MariaDB 5.5.45. Silakan eksekusi perintah berikut: mysql_secure_installation Nanti akan muncul balasan seperti berikut, peringatan dan konfirmasi pengamanan instalasi database server dan kemudian login sebagai root MySQL: NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY! In order to log into MariaDB to secure it, we 'll need the current password for the root user. If you' ve...
https://blog-en.openalfa.com/how-to-continue-after-an-error-execute-failed-duplicate-entry-in-mysql When an INSERT statement is executed to add a set of records to a table that has a unique key defined, it may happen that the value of the key in some of the records to be inserted is the same as that of records already in the table. The default behaviour in this case is that the execution fails with an error message “execute failed: Duplicate entry”. When this happens, no record is inserted, not even those whose keys do not clash with the keys of previously existing records. Example: Let’s say we are developing an application that needs a “customers” table, with columns “clientid”,”name” and “email”. There will be a unique key defined on the “clientid” field. We can create the table, and insert the first records successfully: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 mysql > create table customers ( clientid integer , nam...