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

Mysql Crash

Discussion in 'Plesk for Linux - 8.x and Older' started by ferrisr, Dec 5, 2005.

  1. ferrisr

    ferrisr Guest

    0
     
    MySQl CRASHED a couple days ago. Apparantly, plesk overwrites the daily mysql dump every time it dumps, instead of keeping a few days worth of backups around, and now horde doesn't work. What are the chances that more data than horde was lost, and is there a way to fix horde? It's giving errors about datatree_seq.

    bafserv dumps # cat bafsoft.com/backup_restore.err_log
    Can't locate DBI.pm in @INC (@INC contains: /usr/local/psa/lib/perl5 . /usr/local/psa/lib/perl5/5.8.5 /usr/local/psa/lib/perl5/5.8.5/i686-linux-ld /usr/local/psa/lib/perl5/site_perl/5.8.5/i686-linux-ld /usr/local/psa/lib/perl5/site_perl/5.8.5 /usr/lib/perl5/5.8.5/i686-linux-ld /usr/lib/perl5/5.8.5 /usr/lib/perl5/site_perl/5.8.5/i686-linux-ld /usr/lib/perl5/site_perl/5.8.5 /usr/local/psa/lib/perl5/site_perl/5.8.0 /usr/lib/perl5/site_perl/5.8.0 /usr/lib/perl5/site_perl) at /usr/local/psa/lib/perl5/BU/DB.pm line 8.
    BEGIN failed--compilation aborted at /usr/local/psa/lib/perl5/BU/DB.pm line 8.
    Compilation failed in require at /usr/local/psa/lib/perl5/BU/PSA/DB.pm line 8.
    BEGIN failed--compilation aborted at /usr/local/psa/lib/perl5/BU/PSA/DB.pm line 8.
    Compilation failed in require at /usr/local/psa/lib/perl5/BU/PSA/CommonFunc.pm line 11.
    BEGIN failed--compilation aborted at /usr/local/psa/lib/perl5/BU/PSA/CommonFunc.pm line 11.
    Compilation failed in require at /usr/local/psa/bin/psadump line 81.
    BEGIN failed--compilation aborted at /usr/local/psa/bin/psadump line 81.

    That is the log from individual dumps, and i have mysql.daily.dump.x.gz where x is 0-8. And, would this horde data happen to be in a psadump of the whole server? I have one from when horde was working. And, how can I fix and configure these daily dumps, so if this happens again, I don't run the risk of even more data loss?

    And is there a way to only restore selected mysql databases from a psadump, instead of having to restore all the clients, etc.?
     
  2. jshanley

    jshanley Guest

    0
     
    Perl Module

    Install DBI and see if that helps.
     
  3. ferrisr

    ferrisr Guest

    0
     
    I installed all that, so mysql dumps should work, but how can I do some recovery?
     
Loading...