1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    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.