1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice

Where is The SQL Database of Plesk

Discussion in 'Plesk for Linux - 8.x and Older' started by MaRiOs, Jul 2, 2005.

  1. MaRiOs

    MaRiOs Guest

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

    jamesyeeoc Guest

    On RH systems it is normally kept in


    but you may want to backup the entire

    /var/lib/mysql directory

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

    MaRiOs Guest

    mysqlhotcopy -u admin -p pass psa /targetdirectory ?????
  4. jamesyeeoc

    jamesyeeoc Guest

    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
  5. serve-you.net

    serve-you.net Guest

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

    MaRiOs Guest

    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 :


    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

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

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

    #Remove our temp DB dir

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