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!

backup mysql databases

Discussion in 'General Discussion' started by neonix, Jan 9, 2006.

  1. neonix

    neonix Well-Known Member

    Joined:
    Oct 21, 2004
    Messages:
    124
    Likes Received:
    2
    Trophy Points:
    168
    I will be upgrading from mysql 4.0.25 to mysql 4.1.

    WHM shows a warning that
    "Updating from mysql 4.0 to mysql 4.1 is not automaticlly reversable. You should backup your databases if you think you might wish to downgrade in the future."

    I would like to backup all mysql databases on the server before attempting to upgrade to 4.1.

    Since, I have always used incremental WHM backup, I need guidance to backup only mysql databases on my server through SSH commands. I have a backup harddisk and am on RHEL.

    Thanks for your help.
     
  2. aby

    aby Well-Known Member

    Joined:
    May 31, 2005
    Messages:
    638
    Likes Received:
    0
    Trophy Points:
    166
    Location:
    India
    mysqldump should work for you. Please checkout various options for mysqldump too.

    mysqldump -u username -p databasename > database.sql
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. neonix

    neonix Well-Known Member

    Joined:
    Oct 21, 2004
    Messages:
    124
    Likes Received:
    2
    Trophy Points:
    168
    Hi,

    Since I want to backup all the databases; will this command serve my purpose? Will this backup all user/reseller databases?

    mysqldump --all-databases --opt -u root -p > /backup/mysql_DBs/ALL-db_backups.sql


    Thanks for your help.
     
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