Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

SQL backup for all accounts ahead of upgrade

Discussion in 'Database Discussion' started by lbeachmike, Sep 11, 2011.

  1. lbeachmike

    lbeachmike Well-Known Member

    Joined:
    Dec 27, 2001
    Messages:
    306
    Likes Received:
    1
    Trophy Points:
    316
    Location:
    Long Beach, NY
    cPanel Access Level:
    Root Administrator
    Hi there -

    I am going to upgrade SQL from 5.0 to 5.1 (yes, I know - should have done this long ago)

    I believe Tristan had previously provided a shell command for accomplishing this backup, or a suggested procedure for the backup.

    I'm looking for the shell command to execute to backup all SQL databases.

    Also, do I need to stop SQL before running a backup of all databases?

    Thanks.

    Mike
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  2. JawadArshad

    JawadArshad Well-Known Member
    PartnerNOC

    Joined:
    Apr 8, 2008
    Messages:
    458
    Likes Received:
    6
    Trophy Points:
    68
    Location:
    PK
    cPanel Access Level:
    DataCenter Provider
    Hello Mike,

    Here is the link that you are probably looking. If its possible, then you should generate dumps with the service stopped.


     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. lbeachmike

    lbeachmike Well-Known Member

    Joined:
    Dec 27, 2001
    Messages:
    306
    Likes Received:
    1
    Trophy Points:
    316
    Location:
    Long Beach, NY
    cPanel Access Level:
    Root Administrator
    Yup - that's the one! Thanks for the help!

    Mike
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  4. JawadArshad

    JawadArshad Well-Known Member
    PartnerNOC

    Joined:
    Apr 8, 2008
    Messages:
    458
    Likes Received:
    6
    Trophy Points:
    68
    Location:
    PK
    cPanel Access Level:
    DataCenter Provider
    I am glad I was able to offer assistance.

     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice