[Solved] How can I specify new directory for saving backups?

bkm · August 7, 2018, 3:52pm

Ok, I tried to ask this question in another thread but it eventually devolved into something else completely.

So, Her it is again…

Where in the system can I specify the directory for saving database backups?

Is it possible to do this as part of the “bench backup” command?

The default system saves backups to ~/frappe-bench/sites/[sitename]/private/backups/

I would like to know if I can change that in the system. Or even better, if I can specify that as part of the backup command.

Is there possibly an alternate way to do this? Like maybe running a backup command from inside MariaDB? Would that cause harm to ERPNext?

Looking for ideas here. Where in the code is the actual backup process?

Thanks,

BKM

bhavikpatel7023 · August 7, 2018, 7:35pm

Initiate:

github.com

frappe/bench/blob/9062a75c150776aa517355928bbe94430420c693/bench/commands/utils.py

import click
import sys, os, copy


@click.command('start')
@click.option('--no-dev', is_flag=True, default=False)
@click.option('--concurrency', '-c', type=str)
def start(no_dev, concurrency):
	"Start Frappe development processes"
	from bench.utils import start
	start(no_dev=no_dev, concurrency=concurrency)


@click.command('restart')
@click.option('--web', is_flag=True, default=False)
@click.option('--supervisor', is_flag=True, default=False)
@click.option('--systemd', is_flag=True, default=False)
def restart(web, supervisor, systemd):
	"Restart supervisor processes or systemd units"
	from bench.utils import restart_supervisor_processes, restart_systemd_processes

This file has been truncated. show original

Transfer to frappe:

github.com

frappe/frappe/blob/develop/frappe/utils/bench_helper.py

import importlib
import json
import os
import traceback
import warnings
from pathlib import Path

import click

import frappe
import frappe.utils

click.disable_unicode_literals_warning = True


def main():
	commands = get_app_groups()
	commands.update({"get-frappe-commands": get_frappe_commands, "get-frappe-help": get_frappe_help})
	click.Group(commands=commands)(prog_name="bench")

This file has been truncated. show original

Backup Utils:

github.com

frappe/frappe/blob/develop/frappe/utils/backups.py

# Copyright (c) 2015, Frappe Technologies Pvt. Ltd. and Contributors
# License: MIT. See LICENSE

# imports - standard imports
import gzip
import os
from calendar import timegm
from datetime import datetime
from glob import glob
from shutil import which

# imports - third party imports
import click
from cryptography.fernet import Fernet

# imports - module imports
import frappe
from frappe import conf
from frappe.utils import cint, get_file_size, get_url, now, now_datetime

This file has been truncated. show original

File Paths:
https://github.com/frappe/frappe/blob/d5aec6e80c4799947610cfd686e369aee81a43cf/frappe/utils/\_\_init__.py

bkm · August 7, 2018, 8:18pm

@bhavikpatel7023 - Thank you for the code links. It certainly answered this part of the question:

Unfortunately, it doesn’t help me figure out how to run a backup from the command line and specify output file name and location.

The .py code reads well and offers some clues to the process, but I am not a developer. So, I am not able to figure out where to actually make changes to all those variables so they would allow me to get my desired results. Even though I found the variables in the code for specifying file name and path, I have no idea how I can influence their values.

Thank you though. It proved to be good reading and insightful to the overall process.

Still looking for an easy way (via command line) to execute an ERPNext database backup and specify the output file name and path.

BKM

bhavikpatel7023 · August 8, 2018, 7:10am

Hiii bkm,

Right now there is no optional parameter for file path. But you can develop with optional path parameter.

bkm · August 8, 2018, 11:15am

Ok, that pretty much matches what I have found in the tons of research I did into the bench commands. Thank you, but I am not a developer so the “develop” option is out for me.

So, what MySql command can I use to run a valid ERPNext database backup?

At least from the mysql commands I can maybe force a file name and path.

Can anyone suggest the correct mysql syntax for this?

BKM

bhavikpatel7023 · August 8, 2018, 12:53pm

mysqldump -u YourUser -p YourDatabaseName > wantedsqlfile.sql

bkm · August 12, 2018, 11:13pm

Ok, I finally solved this problem and detailed the steps to take in the following post:

The explanation in the above link solves this issue.

BKM