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.

Backup mysql dir than mysqldump

Discussion in 'General Discussion' started by asmar, Apr 11, 2008.

  1. asmar

    asmar Well-Known Member

    Joined:
    Jul 16, 2004
    Messages:
    135
    Likes Received:
    0
    Trophy Points:
    16
    Hello all,

    I would like to ask if there is any problem by copying the whole mysql directory insteed of getting backups via mysqldump.

    I'm asking that as I am using a rsync script to get backups and it's easier than having another script to get mysqldumps (+load) and then rsyncing them.

    Prons and cons?

    Thanks
     
  2. fahed

    fahed Member

    Joined:
    Jun 13, 2007
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    Hi,

    When restoring the backup (mysql directory), the mysql version should be the same as before.
    :)
     
  3. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,461
    Likes Received:
    22
    Trophy Points:
    38
    cPanel Access Level:
    Root Administrator
    If any databases are using InnoDB tables, you will not get a proper backup using that method unless the MySQL process is shut down.
     
Loading...

Share This Page