Backup database question

ℹ️ Support
1

Hello

found this command to backup my SQL database:

mysqldump --lock-tables -h [server] -u [username] -p[password] [db_name] > nextcloud-sqlbkp_date +"%Y%m%d".bak

What value shall I use for “server”? Is this the domain name or name of the webserver configuration file?

Kind regards
//neph

2

No, it’s the name of your database server. If it’s on the same machine, you can use localhost or even don’t set this value as this is the default setting.

3

For backing up my database I use this script with cron

#!/bin/bash
ZEIT=`date +%d.%m.%y__%T`
echo ">>>  $ZEIT busql START" >> /media/bu/mountbu.log
MONAT=`date +%m`
DATZEIT=`date +%d%H%M`
mkdir -p /media/bu/sql/$MONAT
mysqldump -u root -pPASSWORD nextcloud > /media/bu/sql/$MONAT/$DATZEIT.sql
ZEIT=`date +%d.%m.%y__%T`
echo "<<<  $ZEIT busql ENDE" >> /media/bu/mountbu.log
4

wwe: close old topics