M MaRiOs Guest Jul 2, 2005 #1 Anyone knows where is the sql db of plesk located ? so I can copy the files to another folder for backup reasons ?
Anyone knows where is the sql db of plesk located ? so I can copy the files to another folder for backup reasons ?
J jamesyeeoc Guest Jul 2, 2005 #2 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.
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.
J jamesyeeoc Guest Jul 2, 2005 #4 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
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
S serve-you.net Guest Jul 2, 2005 #5 There's actually a cronjob that runs nightly to backup the admin db. have a look in /var/lib/psa/dumps/
There's actually a cronjob that runs nightly to backup the admin db. have a look in /var/lib/psa/dumps/
M MaRiOs Guest Jul 4, 2005 #6 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.
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.
Facebook
Twitter
