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

    0
     
    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

    0
     
    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.
     
  3. MaRiOs

    MaRiOs Guest

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

    jamesyeeoc Guest

    0
     
    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

    0
     
    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

    0
     
    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.
     
Loading...