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

Delete old sessions?

Discussion in 'SiteBuilder' started by fluxx, Nov 25, 2010.

  1. fluxx

    fluxx New Pleskian

    22
    40%
    Joined:
    Apr 29, 2006
    Messages:
    9
    Likes Received:
    0
    Hi,

    I found 240.000 sessions in the database table "session" and all but a few are old and have been expired. Is there any special reason not to clear this large table or can it be cleared without causing any problems?

    fluxx
     
  2. Dmitry Frantsev

    Dmitry Frantsev Golden Pleskian

    28
    57%
    Joined:
    Sep 19, 2005
    Messages:
    1,911
    Likes Received:
    0
    Feel free to delete the data from session table (not table itself). It should not affect anything in Sitebuilder. BUT, just in case I can suggest you first make sitebuilder3 database dump:

    On system with Plesk installed:
    # mysqldump -uadmin -p`cat /etc/psa/.psa.shadow` sitebuilder3 > /root/sitebuilder3.sql

    On standalone server:
    # mysqldump -uroot -pPASSWORD sitebuilder3 > /root/sitebuilder3.sql

    Let me know about the resutls.
     
Loading...