Here are a few examples of how you can use the search feature:

Entering this and that into the search form will return results containing both "this" and "that".

Entering this not that into the search form will return results containing "this" and not "that".

Entering this or that into the search form will return results containing either "this" or "that".

Search results can also be filtered using a variety of criteria. Select one or more filters below to get started.

Assuming identified is required, the following 9 results were found.

  1. Minimal Privileges for MySQL Database Backup Cron Jobhttps://www.joellipman.com/component/content/article/minimal-privileges-for-mysql-database-backup-cron-job.html?catid=111&Itemid=165

    GRANT SELECT, LOCK TABLES, EVENT, INDEX, REFERENCES, TRIGGER, SHOW VIEW ON 'my_live_db'.* TO 'mybackupuser'@'localhost' IDENTIFIED BY 'mybackupuser'; Or via cPanel the following screenshot when adding a user to a database: Method #1: The following...

    • Type: Article
    • Author: Joel Lipman
    • Category: cPanel
    • Language: *

  2. GDPR Privacy Policyhttps://www.joellipman.com/component/content/article/gdpr-privacy-policy.html?catid=50&Itemid=165

    • Type: Article
    • Category: Static Items
    • Language: *

  3. Privacy Policyhttps://www.joellipman.com/component/content/article/privacy-policy.html?catid=50&Itemid=165

    to ensuring that your privacy is protected. Should we ask you to provide certain information by which you can be identified when using this website, then you can be assured that it will only be used in accordance with this privacy statement. Joel Lipman...

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: en-GB

  4. AwStats Data Parser (ADP)https://www.joellipman.com/component/content/article/awstats-data-parser-adp.html?catid=53&Itemid=165

    the file you saved in step 1 Click on "Go". What data does it return? Any table/grid in the Awstats report uniquely identified by the labels mentioned below. What data does Joes Infographic for Joomla (JIJ) need? Summary Period Report (details on your...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *

  5. SSIS Convert a string into a datehttps://www.joellipman.com/component/content/article/ssis-convert-a-string-into-a-date.html?catid=74&Itemid=165

    "Convert Date" (4228) failed with error code 0xC0209029 while processing input "Derived Column Input" (4229). The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB

  6. SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttps://www.joellipman.com/component/content/article/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html?catid=74&Itemid=165

    return DTSValidationStatus.VS_ISCORRUPT; } } return DTSValidationStatus.VS_ISVALID; } // This method repairs any errors identified during Design Time validation that caused the component to return VS_NEEDSNEWMETADATA at design time public override void...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB

  7. T-SQL example of Case-Sensitive Soundexhttps://www.joellipman.com/articles/else/database/t-sql/t-sql-example-of-case-sensitive-soundex.html

    yields StudentDetail ----------------- Data Not Yet Available Which isn't at all what we set out to achieve other than it identified the remaining values as having the same SOUNDEX value. Adding the COLLATE option straight after the column that needs to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB

  8. SQL Queries for Statisticshttps://www.joellipman.com/articles/else/database/mysql/sql-queries-for-statistics.html

    can change because anonymous guests count as guests until they login, which is when they are associated to a UserID and identified as staff or student. Number of total hits aggregated by month with on-peak/off-peak. SELECT...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: *

  9. Migrate MediaWiki to another serverhttps://www.joellipman.com/articles/cms/mediawiki/migrate-mediawiki-to-another-server.html

    mysql versions should be same. grant create, select, insert, update, delete, lock tables on wikidb.* to wiki@localhost identified by 'YourPassword' ; MediaWiki Upgrade copy all the new files to wiki folder and then run php update.php from maintenance...

    • Type: Article
    • Author: Joel Lipman
    • Category: MediaWiki
    • Language: en-GB
Results 1 - 9 of 9