Making folder backups using Cron

Cron JobsAs I mentioned in yesterdays post on ,a href=’https://www.azurecurve.co.uk/2019/12/making-mysql-backups-using-cron/’>making backups of mySQL databases, earlier this year I migrated from a Microsoft Windows based web hosting package to a Linux based one. This meant I had to learn a few new ways of doing things, such as backing up databases or files, on a regular repeating basis.

This is accomplished on Linux web hosts using the Cron time-based scheduler. I needed to create two types of cron jobs; one to backup databases and one to backup files. Yesterdays post was on the databases and todays is on backing up files.

The syntax for backing up a files using Cron jobs will largely be the same on all web hosts.

The below example shows the syntax to backup a files, with the sections to change highlighted:

/*
Created by Ian Grieve of azurecurve|Ramblings of a Dynamics GP Consultant (http://www.azurecurve.co.uk) This code is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International (CC BY-NC-SA 4.0 Int). */
/bin/tar -czvf /home/{username}/backups/backup_{sitename}_$(date +\%Y\%m\%d\%H\%M\%S).tar.gz /home/{username}/{foldername}

Making mySQL backups using Cron

Cron JobsEarlier this year I migrated from a Microsoft Windows based web hosting package to a Linux based one. This meant I had to learn a few new ways of doing things, such as backing up databases or files, on a regular repeating basis.

This is accomplished on Linux web hosts using the Cron time-based scheduler. I needed to create two types of cron jobs; one to backup databases and one to backup files.

The syntax for backing up a MySQL database using Cron jobs will largely be the same on all web hosts.

The below example shows the syntax to backup a mySQL database, with the sections to change highlighted:

/*
Created by Ian Grieve of azurecurve|Ramblings of a Dynamics GP Consultant (http://www.azurecurve.co.uk) This code is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International (CC BY-NC-SA 4.0 Int). */
/usr/bin/mysqldump -u {username}-p'{password}' {databasename} > /home/{username}/backups/backup_{databasename}_$(date +\%Y\%m\%d\%H\%M\%S).sql

Hands On with Microsoft Dynamics GP October 2019 Release: Install GP Add-in for Microsoft Word

Microsoft Dynamics GPThis post is part of the Hands On with Microsoft Dynamics GP October 2019 Release series where I am going hands on with the new version of Microsoft Dynamics GP.

The Microsoft Dynamics GP Add-in for Microsoft Word allows the Word Templates used for outputting vendor or customer documents to be amended and have new fields added to them. Things work best if you have both the Microsoft Dynamics GP client and Microsoft Word on the same computer, but this isn;t technically necessary as you could copy the exported Word Template between machines to make the changes and then transfer it back for import.

To install the add-in, launch the Microsoft Dynamics GP setup utility and, under the Additional Products heading, select Microsoft Dynamics GP Add-in for Microsoft Word:

Microsoft Dynamics GP setup utility

Continue reading “Hands On with Microsoft Dynamics GP October 2019 Release: Install GP Add-in for Microsoft Word”

Hands On with Microsoft Dynamics GP October 2019 Release: Install OData Service

Microsoft Dynamics GPThis post is part of the Hands On with Microsoft Dynamics GP October 2019 Release series where I am going hands on with the new version of Microsoft Dynamics GP.

The OData service allows for reporting services such as PowerBI to connect to Microsoft Dynamics GP. This post is going to focus on installing the OData service, but at the bottom of this post I’ve included details of a book, co-written by Mark Polino and I, in which Mark covered configuring OData for use with PowerBI.

To install the OData Service, launch the Microsoft Dynamics GP setup utility and click on GP OData Service under the Additional Products heading:

Microsoft Dynamics GP setup utility

Continue reading “Hands On with Microsoft Dynamics GP October 2019 Release: Install OData Service”

Hands On with Microsoft Dynamics GP October 2019 Release: Install GP PowerShell

Microsoft Dynamics GPThis post is part of the Hands On with Microsoft Dynamics GP October 2019 Release series where I am going hands on with the new version of Microsoft Dynamics GP.

The GP PowerShell module can be used to execute commands against Microsoft Dynamics GP such as creating a new company. The installation is a straightforward one which only needs to be done on a machine on which it nwill be used; there also needs to be a Dynamics GP client present.

To install GP PowerShell, launch the setup utility and, under the Additional Products header click GP PowerShell:

Microsoft Dynamics GP setup utility

Continue reading “Hands On with Microsoft Dynamics GP October 2019 Release: Install GP PowerShell”

Hands On with Microsoft Dynamics GP October 2019 Release: Verify Web Services

Microsoft Dynamics GPThis post is part of the Hands On with Microsoft Dynamics GP October 2019 Release series where I am going hands on with the new version of Microsoft Dynamics GP.

With Web Services not installed, the final step is to verify that everything is working correctly; the steps to verify are the same as those for Dynamics GP 2018 R2 so you can follow the instructions in that post.

If the Windows Service does not start, then you may have installed the Web Services from the October Release download which does not work; make sure you have the fixed version downloaded.

If you need to install the fixed version, I’d recommend a full uninstall and reinstall using the fixed version.

Click to show/hide the Hands On with Microsoft Dynamics GP October 2019 Release Series Index

Hands On with Microsoft Dynamics GP October 2019 Release: Configure Web Services

Microsoft Dynamics GPThis post is part of the Hands On with Microsoft Dynamics GP October 2019 Release series where I am going hands on with the new version of Microsoft Dynamics GP. Over the last couple of posts, I’ve downloaded the fixed version of the Web Services and run through the installation.

The next step in installing the web services, is to run the Web Services for Microsoft Dynamics GP Configuration Wizard from the Windows Start menu. When it starts, click Next on the welcome screen:

Web Services for Microsoft Dynamics GP Configuration Wizard -

Continue reading “Hands On with Microsoft Dynamics GP October 2019 Release: Configure Web Services”