The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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

Discussion in 'Database Discussions' 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:
    8
    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!
     
    #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:
    1
    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!
     
    #2 sven4o, Dec 17, 2009
    Last edited: Dec 17, 2009

Share This Page