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

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