Minimal Privileges for MySQL Database Backup Cron Jobhttps://joellipman.com/articles/linux/cpanel/minimal-privileges-for-mysql-database-backup-cron-job.html

20 March 2019 user. For both methods, I grant the following to the user doing the backup on the database I want a backup of: GRANT SELECT, LOCK TABLES, EVENT, INDEX, REFERENCES, TRIGGER, SHOW VIEW ON 'my_live_db'.* TO 'mybackupuser'@'localhost' IDENTIFIED BY...

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

Windows OS: Alt Codes / Symbols / Special Charactershttps://joellipman.com/articles/microsoft/windows-os/windows-os-alt-codes-symbols-special-characters.html

03 June 2021 your numeric keypad and NOT the numbers at the top of your keyboard for the following steps. Also check that you have "Num Lock" on/enabled. Typing a special character is 3 easy steps: Hold down the ALT key (preferably the one on the left of the...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *

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

23 September 2009 wikidb; this is inside mysql, Note that both 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...

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

Quadcopter App with Flight Restrictions (JQA)https://joellipman.com/component/content/article/quadcopter-app.html?catid=40

24 October 2014 borders - Map: toggle aviation map - Map: toggle flight routes - Map: toggle atmosphere (openGL chrome experiment) - Map: lock map orientation to device compass - Map: replace map compass - Map: tap once to start a waypoint - Map: tap a second time to...

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

Protecting your Joomla Administrator Sectionhttps://joellipman.com/articles/cms/joomla/protecting-your-joomla-administrator-section.html

23 October 2015 This is a quick article to remind me how to move a Joomla administration section and to lock it down to a specific IP address. The below does not involve installing any third-party extensions and will remain in place even if you update your Joomla CMS....

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

Windows 10: Shortcut Apps to Settingshttps://joellipman.com/articles/microsoft/windows-os/windows-10-shortcut-apps-to-settings.html

30 July 2020 Set up a kiosk ms-settings:assignedaccess Sign-in options ms-settings:signinoptions ms-settings:signinoptions-dynamiclock Sync your settings ms-settings:sync Windows Hello setup ms-settings:signinoptions-launchfaceenrollment...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *

Zoho Books: Error 7008: There are no contact persons associated with this Invoicehttps://joellipman.com/articles/crm/zoho/zohobooks-error-7008-there-are-no-contact-persons-associated-with-this-invoice.html

07 March 2024 below, I have a connection to ZohoBooks from ZohoCreator called "zbooks". It has fullaccess as a scope but I'm sure you can lock it down to just the scopes you need. void ZohoBooks.fn_SendZohoBooksInvoice(int p_OrderID) { v_OrderID =...

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

FTP on Mac: Failed to retrieve directory listinghttps://joellipman.com/articles/web-development/ftp/ftp-on-mac-failed-to-retrieve-directory-listing.html

06 October 2018 The solution was to change the options on the mac firewall by going into Settings > Security & Privacy > Firewall Click the lock to make changes Firewall Options Untick "Block all incoming connections" Leave the boxes ticked EXCEPT for "Enable Stealth...

• Type: Article
• Author: Joel Lipman
• Category: File Transfer Protocol
• Language: *