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

Change qmail/mysql directory

Discussion in 'Plesk for Linux - 8.x and Older' started by cmaxwell, Sep 1, 2006.

  1. cmaxwell

    cmaxwell Regular Pleskian

    25
    73%
    Joined:
    Aug 1, 2001
    Messages:
    150
    Likes Received:
    1
    One of our disk partitions was filling up so we changed the location of qmail and mysql by making symlinks as follows:

    /var/qmail => /home/var/qmail
    /var/lib/mysql => /home/var/lib/mysql

    Everything works fine, except the psadump backup fails to backup the mail or database files.

    Do we need to make a hard link instead or is there a better way of doing it?

    Thanks.
     
  2. wagnerch

    wagnerch Guest

    0
     
    You can't hardlink directories, so if psadump is that sensitive then you are SOL.

    I don't use psadump, but atleast I can tell you hardlinks for directories are not possible :).

    You could split the second disk into two partitions and mount each partition in /var/qmail and /var/lib/mysql.


    Another thing I thought of was the /etc/psa/psa.conf file, I have no idea if tweaking the QMAIL_ROOT_D, QMAIL_MAILNAMES_D, MYSQL_VAR_D variables will fix it -- or make it even worse.
     
  3. cmaxwell

    cmaxwell Regular Pleskian

    25
    73%
    Joined:
    Aug 1, 2001
    Messages:
    150
    Likes Received:
    1
    Thanks for your reply. It gave me an idea to run the psadump manually (not from cron) and here is the error I found:

    /usr/bin/mysqldump: Can't get CREATE TABLE for table `monitor_agent_reports` (Can't open file: 'monitor_agent_reports.MYD'. (errno: 145))

    I ran a repair on that MySQL table and it all works fine now. False alarm!

    Thanks for the good ideas.
     
  4. wagnerch

    wagnerch Guest

    0
     
    Good to know that psadump will freak out if there is table/index corruption.
     
Loading...