Instructions to include a backup script in espoCRM

[shalmaxb]

Hello,

the user item provided this script: https://forum.espocrm.com/forum/inst...5274#post75274
Any help, where to put it and how to use is appreciated.

Can be found here: https://docs.espocrm.com/administrat...p-and-restore/

[espcrm]

It look like a standard script function, I think I only ever run bash script less than 5 times in my lifetime as there was no other option at that time.

Using the CLI I believe, you can probably use it. Here is my guess:
(1) download, edit the file, upload it somewhere, probably same folder as EspoCRM or 1 level above it, as for editing I think you need to edit; filepath, password, username in that fle.
(2) use a commandline tools. For example CMD for Windows, but I remember Windows don't support Bash 'language' so you must install some 3rd party Bash 'decoder'... but Linux by default I think they support Bash language.

So my guess is... do you remember how you use your 'CLI' to upgrade your server? Instead of running, "php update" which is basically saying, "Using PHP to run the file call update".

In this case you would need to invoke the Bash command, something like, "bash backup.sh" and it should run the file using the program/language bash. Finally to verify my theory I did a search online and briefly reading through the guide it seem to be right:

https://www.cyberciti.biz/faq/run-execute-sh-shell-script/

Either run with "bash filename" or "sh filename"

[espcrm]

Reading item script I think he made it even easier, maybe you only need to edit/amended the path.

He grab the other details for you using these code I think;


DB_NAME=$(php -r "\$config=include('data/config.php'); echo @\$config['database']['dbname'];")
DB_USER=$(php -r "\$config=include('data/config.php'); echo @\$config['database']['user'];")
DB_PASS=$(php -r "\$config=include('data/config.php'); echo @\$config['database']['password'];")

If you are successful in your venture I might give it a try too... manually updating make me lazy.

[item]

Hello,

create a Jobs ..

<?php

namespace Espo\Custom\Jobs;

class BackupJobs extends \Espo\Core\Jobs\Base
{

public function run()
{
$GLOBALS['log']->warning( "Begin BackupJobs");
$pdo = $this->getEntityManager()->getPDO();
$sql = "DELETE FROM scheduled_job_log_record WHERE status='Success';DELETE FROM job WHERE status='Success'";
$sth = $pdo->prepare($sql);
$sth->execute();

@exec('cd /PATH/backups;bash ./backup.sh > /dev/null &');
$GLOBALS['log']->warning( "End BackupJobs" );
}
}

+ scheduler.json add the entry for the new jobs .. clear cache
+ put this jobs run every week

change PATH. to something :

/blabla/blabla/espocrmroot/public

to /babla/backups. normaly www have access
change in the script to
make executable the script : https://www.andrewcbancroft.com/blog...pt-executable/

it's done

[shalmaxb]

Thank you for your help. I tried to execute the bash file in my local installation (WAMP environment) with Windows Subsystem Linux. But that is very complicated for me, as the command structure is different and I always get errors. Guessing, what could be right, takes hours.

I guess, with the php-script in the thread above I could avoid trying to execute the bash in Windows. I will try to implement it.

[shalmaxb]

Hello, I followed the instructuions and the script seems to work (at least no error), but there is no backup file anywhere.
I did not understand the second line of the bash:

DEFAULT_BACKUP_PATH=$(pwd)

Will I have to put there the path to my created backup folder? What does $(pwd) mean?

[item]

DEFAULT_BACKUP_PATH=$(pwd)

DEFAULT_BACKUP_PATH='C:\pathToBackupPlace". on windows

DEFAULT_BACKUP_PATH="/pathToBackupPlace"

This script of Yuri is interactive...user need to respond.

i have a little modified for non-interactive :

if [ ! -d "$BACKUP_PATH" ]; then
echo "Error: The directory '$BACKUP_PATH' does not exist."
exit 1
fi

if [ ! -w "$BACKUP_PATH" ]; then
echo "Error: Backup directory '$BACKUP_PATH' is not writable."
exit 1
fi

cd $PATH_TO_ESPO

if [ ! -f "data/config.php" ]; then
echo "Error: The '$PATH_TO_ESPO' is not EspoCRM directory."
exit 1
fi


Edit : if not forget : $(pwd) is i think when run from command line

./Backup.sh "/pathThoBackup". (it's a variable)