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!

[MySQL Upgrade] How to do a full DB backup?

Discussion in 'Database Discussion' started by Eli L, Dec 17, 2009.

  1. Eli L

    Eli L Well-Known Member

    Joined:
    Aug 9, 2007
    Messages:
    61
    Likes Received:
    1
    Trophy Points:
    58
    Location:
    Bellingham, Washington, United States
    cPanel Access Level:
    Root Administrator
    Hey,

    Since upgrading to 11.25 theres a setting to upgrade MySQL from 5.0 to 5.1. Doing this it says:
    I cannot afford to lose my DB's and want to play it safe; so how do I do a full database backup?

    Thanks!
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #1 Eli L, Dec 17, 2009
    Last edited: Dec 17, 2009
  2. sven4o

    sven4o Member

    Joined:
    May 21, 2007
    Messages:
    19
    Likes Received:
    0
    Trophy Points:
    151
    All the databases' raw files are stored under the /var/lib/mysql folder. Copy the content of this folder to a separate storage and you will have a backup of your databases. You can also copy the my.cnf file from the etc/ folder. It contains your MySQL configuration.

    Alternatively, you can backup the databases one by one from WHM->PhpMyAdmin.

    We know cPanel because our web hosting customers love it!
    Check out our special cPanel hosting package!
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #2 sven4o, Dec 17, 2009
    Last edited: Dec 17, 2009

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