Where is The SQL Database of Plesk

[MaRiOs]

Anyone knows where is the sql db of plesk located ? so I can copy the files to another folder for backup reasons ?

 

[jamesyeeoc]

On RH systems it is normally kept in

/var/lib/mysql/psa

but you may want to backup the entire

/var/lib/mysql directory

or do a full mySQL dump and save that as well.

 

[MaRiOs]

mysqlhotcopy -u admin -p pass psa /targetdirectory ?????

 

[jamesyeeoc]

Since you have not done it before, you may want to try using it with the dry run option:

-n, --dryrun report actions without doing them

to see if it is going to do what you think.

And if you want multiple backups, use the --keepold --allowold options

 

[serve-you.net]

There's actually a cronjob that runs nightly to backup the admin db. have a look in /var/lib/psa/dumps/

 

[MaRiOs]

Finaly I came to the conclusion to create a script that will make dumps of all the available dbs once a day.

For fist i was thinkin about copying the folders but then its not so good cause if a db is updating this time it will maybe be corrupted.

So Im using this script :


#!/bin/sh

MYSQLDESTDIR=/root/sqlbackup/`date +%Y-%m-%d`

#This assumes admin uses password to access to mysql to show databases
ALLDBS=`mysql -u admin -pmypass -Bse "show databases"`

#Create our tempdir
mkdir $MYSQLDESTDIR

#Fill our tempdir with the DB's
for curdb in $ALLDBS
do
mysqlhotcopy -u admin -p mypass -q $curdb $MYSQLDESTDIR
done

#Create your backup
tar -czf /root/sqlbackup/`date +%Y-%m-%d`backup.tgz $MYSQLDESTDIR

#Remove our temp DB dir
rm -r $MYSQLDESTDIR


But i have hard time to make it work right since I get some errors.